3 Replies Latest reply on Oct 23, 2012 7:46 AM by lkeyes

    ExecuteSQL - Multi-word table names, and command line

    lkeyes

      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).

       

      Something like:

       

      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.

       

      Many thanks!