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!