>>Thank you, Mike,
>> for the explanation. I really like that idea. It might take me a bit to wrap my head around doing it all the time, from now on. :-) Can't go back and re-write all my code.
>>
>>I am trying to get the code to work now. I am having problems with the sql statement and am trying to figure out why now.
>
>My favorite trick for such cases, i.e. with code snippets generated on the fly, is to execscript() them - the executed script can be seen in the debugger, at least the first level of it, and I have had only one case where I had to go deeper.
>
>The next trick is to save the script into a tmp.prg. If it errors out, suspend, copy into tmp.prg (via either _cliptext=lcScript, modi comm tmp, paste, or strtofile(lcString, "tmp.prg")), then open this prg and see what you got - debug it as any other prg. Keep in mind that your code is suspended, so all the variables are still there, all objects are alive and kicking, and all the tables are still open.


Nice, I will see what I can do with this. :-)
Thanks.
Beth