I'm creating a Data Project with Visual Basic 6.
I'm designing a database with DataEnvironment Activex Designer.
I want to have the possibility of changing the SQL statement of the command
object at runtime.
I already saw the SQL string in the CommandText propertie of the command
object, but if I write:
DataEnvironment1.rsCommand1.CommandText = " SELECT * FROM Table1 WHERE
Table1.Customer = CustomerVariable"
Visual Basic does not accept CommandText.
So, what should I put after rsCommand1?:
DataEnvironment1.rsCommand1.... = " SELECT * FROM Table1 WHERE
Table1.Custommer = CustomerVariable"
(The Database was created in Microsoft Access).
Thanks a lot for your attention.