AnsweredAssumed Answered

ExecuteSQL - Multi-word table names, and command line

Question asked by lkeyes on Oct 23, 2012
Latest reply on Oct 23, 2012 by 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!

Outcomes