Can I save an SQL statement, created at runtime, as a query ?

[DaJoin]

I'm developing a form in wich I dinamicly create a query.
This query causes me trouble (2001 runtime error : You cancelled last operation) and I'd like to save the query I created at runtime, to find out what's wrong with it in the query window.

I tried to message it, but this way I cannot copy it to the clipboard or something .

Thanks in advance for your golden tips .

 

[grtammi]

When you get the error message, click Debug instead of End to see the code window, and then highlight and copy the SQL statement - you'll be able to analyze it then using whatever editor you choose ...

Greg
If you don't understand, just nod and smile ...