Wayne:

SQL property is readonly. The only way I found to do it during runtime, is to drop it from the dbc and recreate it. I use the code from GENDBC to make a prg that I can pass the new SQL string.

It would be nice to be able to change it on the fly, then issue requery().

Charlie