help on data report using sql

[mamba]

im using data envi. ,how can u have restriction in a query for example. select employee from emp_tbl where emp_id = ' " & text1 & " ' from visual . and show it in data report. another thing, how can u pass value from visuaBasic to a data report Richtextbox. Ty more powerl

[eimroda]

try this:

If de.State = 1 Then de.Close
de.Commands("myCommand").CommandText = "SELECT ...... WHERE emp_id ='" & Text1.Text & "'"
de.Open
 
myReport.Show