Problem with SQL ODBC...

10 hours ago10 hr

Hi,

I've got a script that grabs a numeric value from record #1 in a SQL table (SYS_TAB) (that only has ONE record EVER), a "last transaction number", to increment by one, then use that new value to update that SYS_TAB and three other SQL tables (INV_HDR, INV_REG, INV_TTL.

Sometimes, the value appears to NOT be returned properly, and I cannot figure out why...

It's SQL Server 14.0.1000.169, FileMaker 2026 (26?)

I have a log entry being created (partial here), as: ["notes"; "Save audit history, Trn #: " & $$ln_F1032 & ", User: " & $$UserID ; JSONString];..... and when this happens, the value in the string for $$ln_F1032 shows as a "?" (no quotes).

I've tried grabbing the value using FileMaker (External Data Source), and also using " ExecuteSQL ("SELECT F1032 FROM SYS_TAB" ; "" ; "") " to set the variable (currently in the code, as the FileMaker EDS failed).

Can anyone shed light on what causes the variable $$ln_F1032 to show as a question mark, and/or why this SOMETIMES fails, but works MOST of the time, no matter which method I use to grab that value?

Thanks in advance.