Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Createa a method for creating dynamic queries

Former Member
0 Likes
263

Hi,

I am trying to create a public method in a class to generate Dynamic SQL Queries.The method has 4 parameters :

WHERESTRING TYPE STRING

FROMTABLE TYPE STRING

SELECTFIELDS TYPE STRING

INTOTABLE TYPE ANY TABLE

the process is :

SELECT (selectfields) FROM (fromtable) INTO <INTOTABLE> WHERE (wherestring).

However I get error in the INTOTABLE, it does not recognize the parameter. What am I doing wrong ?

1 REPLY 1
Read only

Former Member
0 Likes
235

Resolved myself!