Back in the days of FactorySQL, I could write a SQL query that executed a stored procedure and returned the value, as a string:
DECLARE @newSortID char(15)
– Second Paramater value can not be more than 15 characters
EXEC [dbo].[UFGeneratedKey] ‘098’, ‘tblSortationKPI’, @newSortID OUTPUT
This value was placed in a string tag, called RecordID, and passed to the database. No problems.
But now, with Ignition, it only returns ‘1’, which is the “success” result value, not the value itself. In researching this anomaly, I have discovered in the Help pages that, in Ignition, the SQL query must return a numerical value.
What gives? This is a MAJOR show stopper for us migrating from FSQL to Ignition. So any guidance on how to resolve this would be greatly appreciated. RecordID MUST be a 15 character value.