AnsweredAssumed Answered

Execute sql

Question asked by Hudi on Oct 3, 2012
Latest reply on Oct 4, 2012 by beverly

First time using the new FMP12 execute sql function. I'm trying to get a list of ID's from a table but can't seem to do so.

 

Btw, this is going to open up a whole new way of doing things around here if I can only get it to work.

 

here is what I have

 

ExecuteSQL ( "SELECT ID FROM Students WHERE _f_omit=1" ; "";"")

 

(ID is a field

Students is a table)

 

Its pulling up a "?"

 

Any help is appreciated!

Outcomes