How to pass value to SQL Query in Data Environment's Command Object at run-time?

[rpk_20061975]

In DataEnvironment I have a Command Object in which I have
given following SQL Query:

-------------------------
SELECT * FROM customer WHERE billno = billnumber
-------------------------

Here billnumber is a public variable in Module.
This variable accepts value at run-time.

How to call variable in DataEnvironment's SQL Query?

[mahemathu]

In DataEnvironment I have a Command Object in which I have
given following SQL Query:

-------------------------
SELECT * FROM customer WHERE billno = billnumber
-------------------------

Here billnumber is a public variable in Module.
This variable accepts value at run-time.

How to call variable in DataEnvironment's SQL Query?

Hi,

You can follow the below commands for (VB 6): Just try calling the below function by placing under a command button in any of the form from where you want to call the datareport.

Note:
Also goto DataEnvironment1 -> Connection1 -> ADD a Command1 and rename the Command1 as customer. Now goto customer properties -> In General tab select SQL Statement and type in...... SELECT * FROM Customer WHERE billno=?

Private sub Comman1_Click()

Load DataEnvironment1
With DataEnvironment1

If .rscustomer.State <> 0 Then .rscustomer.Close

.customer (billnumber)

End With
Datareport1.Refresh
If Datareport1.Visible = False Then Datareport1.Show

End Sub


Enjoy!

Buzz me if it works !!!