Question
Hf Management Services LLC
US
Last activity: 12 Aug 2019 9:33 EDT
Parameterizing OFFSET in MSSQL is giving error
|
Parameterizing OFFSET in MSSQL is giving error |
|
User using the RDB-LIST to get the data from the external system. User is Parameterizing OFFSET value in MSSQL and he is getting the error There was a problem getting a list: code: 10743 SQLState: S0001 Message: The number of rows provided for a OFFSET clause must be an integer.
Exact Syntax in the SQL: OFFSET {diagTempPage.loop} ROWS FETCH NEXT 1000 ROWS ONLY
The loop property is an integer property on the diagTempPage. |
***Edited by Moderator: Lochan to tag SR***
Accepted Solution
Pegasystems Inc.
US
By default with RDB, property reference directives are replaced with string values--since the system does not have a way of determining the type which the database actually expects.
So even if the value of your diagTempPage.loop Property might be a number, the system will still pass the value as a string.
In many cases databases simply accepts the string and convert it to an integer--this does not appear to be one of those cases.
To solve the problem, you an specify a type with your property reference directive. In this case you should be able to use Integer, as follows:
{diagTempPage.loop Integer}
Pegasystems Inc.
IN
It appears that there is a problem with the value initialized or assigned in the variable diagTempPage.loop. Can you please print this value before the call to check whether it is truly an integer?
Accepted Solution
Pegasystems Inc.
US
By default with RDB, property reference directives are replaced with string values--since the system does not have a way of determining the type which the database actually expects.
So even if the value of your diagTempPage.loop Property might be a number, the system will still pass the value as a string.
In many cases databases simply accepts the string and convert it to an integer--this does not appear to be one of those cases.
To solve the problem, you an specify a type with your property reference directive. In this case you should be able to use Integer, as follows:
{diagTempPage.loop Integer}