Is it possible to change the SQL of a data environment child command at run time? I tried doing so with the .CommandText argument but that gives me an invalid procedure call error.
Thanks
Andrew
Printable View
Is it possible to change the SQL of a data environment child command at run time? I tried doing so with the .CommandText argument but that gives me an invalid procedure call error.
Thanks
Andrew
I recommend not using the Data Environment in such cases, but creating the SQL query at run-time by using the SHAPE command, and when you need to change it, just rewrite the query.