I am using executeSQL in this fashion.
Go to Record/Request/Page [No dialog; ExecuteSQL ( " SELECT RID FROM Invoices WHERE "Invoice ID" = ?" ; ""; ""; $order)]
Invoices::RID = Get(RecordID)
$order is set to a predetermined Invoice ID that matches the invoice IDs in the database. This scripts brings electronic payment data into the solution and applies them to the invoice.
Not really working how I want it to. There are only 125 records in the test database and the data viewer is returning values like "261 335" for the eSQL evaluation. Pretty weird.
Any ideas? I hoped this would save me the time of doing a find for the record and allow me to go directly to it. I am guessing I have the syntax right.