Dynamic SQL Statement (DATA ENVIRONMENT) 
Author Message
 Dynamic SQL Statement (DATA ENVIRONMENT)

Hello.

I am in the process of creating my first data report with vb6, but I am
having trouble.

1 This is the code a do in SQL statement...

 Select names From tbNames
 Where Parameter;

2 In form i do...

    Parameter: ((id=1) or (id=2))
    DataEnviroment.OPEN
    DataEnviroment.CommandTxt Parameter;

the data report dont show noting.
Can you Help me.

Henrique Paulo

--
--
Henrique Paulo
Database Applications & Internet Developer




Tue, 12 Nov 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. dynamic sql & the data environment

2. Data Environment - SQL statement

3. Application provided SQL-statement in Data-Environment Command

4. Data Environment & SQL Statements

5. How to pass a variable into a SQL Statement Command is Data Environment

6. Dynamic SQL Statement With SQL 6.5

7. SQL query: from SELECT statement to stored procedure with dynamic PL/SQL

8. Dynamic Data Environment Code

9. Dynamic Data Environment Code Help

10. setting dynamic path in Data Environment Connection

11. DAO Sql statement doesnt work in an ADO environment

12. Dynamic SQL statements with OpenRecordSet function

 

 
Powered by phpBB® Forum Software