Createa a method for creating dynamic queries

Former Member — Wed, 28 Nov 2007 10:55:31 GMT

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 ?

Re: Createa a method for creating dynamic queries

Former Member — Fri, 29 Aug 2008 12:55:03 GMT

Resolved myself!