>> When you set your grid's recordsource to Null, are you sure you don't loose your grid's columns design? Anyway, I'll test this tomorrow.
Yes you do! This is NOT a good solution unless you are using base class columns with no custom settings at all.
The better solution is is to use a "Safe Select".
Instead of running your SQLEXEC() directly into the target cursor, create a custom method which runs the SQLEXEC() for you but into a temporary cursor and then uses ZAP and APPEND FROM DBF() to populate the 'real' grid cursor. That way you won't lose any of your custom settings.
Unlike SQL Select, ZAP does not close the cursor object, so there is no need to screw around with the grid's recordsource.
----
Regards
Andy Kramek