1 of 1 people found this helpful
The name of the field that contains the record number, or if you need the internal record ID, you need to add a calculation field that is = Get(RecordID)
... but for most purposes you should not be using the internal record ID
ExecuteSQL("SELECT \"fieldname\" FROM \"tablename\" WHERE \"anotherfieldname\"='value'";"";"")
If it's possible to get multiple values back, you should put a row separator in the 3rd parameter, or if you just want the first result, add "FETCH FIRST 1 ROWS ONLY", for example.
Dear Jason Wood,
Thank you for your valuable notes.