Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table where I've stored the queries.
Table SQL_QUERY
ID, QUERY
1,SELECT * FROM EMPLOYEE
2,SELECT * FROM DEPARTMENT
//Now I am Looping this table -
for vLoopNumber = 1 to NoOfRows('SQL_QUERY')
Let vSQL = FieldValue('SQL_QUERY',$(vLoopNumber)); // it fetches the Query
// Now I want to load the FieldValue('SQL_QUERY',$(vLoopNumber)) i.e resultset of query in table.
Table:
LOAD *;
vSQL ; // here I want to execute the Select statement stored in variable vSQL.
Next vLoopNumber
---
Please let me know how to execute the Select statement stored in variable vSQL.
Regards
Nilesh
Try $(vSQL) instead of vSQL ;
Try $(vSQL) instead of vSQL ;
Thank you very much!
Regards
Nilesh