Data Environment question

[a2427]

I created an connection and a command object using data env.. I created an SQL query for the command object using the SQL builder. The query contains a parameter I want to assign from a text box at runtime so my sql has the ? in it. How can use the data environment command now to execute the quuery and fill in the parameter.

I can do it if I don't use the data environment but all my other connections and command are defined in the data env. so I would like to stay consistent.

[shwan]

i'm not quite getting ur point, but u can try this

data1.execute ("Insert into Table 1 where Field1= " & trim(text1.text))