[AccessD] OT - VB6 Data Environment - Changing SQL Text Of Command Object At Run Time

To all,

I have a very simple app, which uses a data environment and one command.  Lets say for example the SQL text of the command at design time is SELECT MyName FROM tblPersonnel, is it possible to change the actual SQL text at run time to something else, lets say SELECT MyAddress FROM tblPersonnel.  I have tried something similar and the query seems to generate ok, but when I go back to design and open the command it has the original SQL text in there.  Is there anyway to modify and save the SQL text at run time.

Thanks in advance for any help on this.


Paul Hartland
paul.hartland at fsmail.net
07730 523179