AnsweredAssumed Answered

Can variables be used in OFFSET function in EXECUTESQL ?

Question asked by jimhohnc on Jan 12, 2018
Latest reply on Jan 12, 2018 by jimhohnc

Hi Everyone,

 

I have tried below two :

 

EXECUTESQL ( " SELECT record from Database OFFSET 1 row " ; " " ; " ; ) ==> This works well

 

EXECUTESQL ( " SELECT record from Database OFFSET $variable row " ; " " ; " ; ) ==> This does not work, return ?

 

I have checked $variable's value is 1.

 

Any syntax mistakes? or variables are not support is OFFSET / FETCH function.

 

Please help.

Outcomes