bigtom

Need a little help with eSQL selecting wrong data

Discussion created by bigtom on Oct 9, 2014
Latest reply on Oct 9, 2014 by bigtom

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.

Outcomes