Passing a variable thru mysql in data report or data environment

[tandhy]

i got trouble in passing my variable from a form to show a data(some data not all) using query, such as "select * from table where field = '" & text1.text & "'

i could't pass the variable when i call the data report using show..
do anyone knows what i have to do...
thanks very much

[andioliver]

In your command inside your data environment, Create with your sql an parameter such as:

"select * from yourtable where data = MyData"

than at the properties of the command select parameters
There it should be already appeared 'MyData'
After this you should describe by selecting the type of your parameter, in your case date

After this before you execute your command set value of the parameter

dataenv.mycmd.parameter(0).value = date
dataenv.mycmd.execute


You should figure out..., good luck