Hi... ExecuteSQL newbie here.
1. I always thought it was odd that FM allowed muti-word table names, but now I'm working with a database that has them, I was wondering if there was a way to use these within an ExecuteSQL() command. The usual delimiters seem not to work (i.e. quotes around the full name).
ExecuteSQL(SELECT * from "my table") blah blah
2. Is there a way you can essentially "open a command line"... i.e. have a form defined that allows you to put the text of the ExecuteSQL in the top, and and see the results in the bottom? Kind of like the FoxPro command box (I wish!) or the Access SQL query.