-
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.
-
i'm not quite getting ur point, but u can try this
data1.execute ("Insert into Table 1 where Field1= " & trim(text1.text))
