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