Return to FileMaker.com
New function: ExecuteSQL
Hello to all,
first all: my english is very bad
I want try to use ExecuteSQL for search a record in a table and if exist retur 1 or 0 if not exist.
SetVariable $$try : ExecuteSQL(SELECT * FROM TABLE WHERE _ID = _ID ; " " ; " ";) but it doesn't work ( RETURN (?) )
is it possible to return 1 if exist or 0 if not exist ?
Thanks in advance!
SQL has trouble with the _ character in a field name. You have to enclose it in quotes.
Not IsEmpty ( ExecuteSQL("SELECT * FROM TABLE WHERE \"_ID\" = ?" ; " " ; " "; _ID) )
Retrieving data ...