>hi all,
>
>a client of mine wants to have a system of reporting wherein he selects the columns from a list of about 30 fields which are from about 10 different tables. and, only the selected fields should appear in the report print out.
>
>now, based on his selection of fields certain joins etc will have to be done to extract the desired data from the respective tables.
>
>my problem is that in the worst case when he selects all the fields, my SQL statement exceeds the limit of 254 characters (which i am storing in a character variable) how can i store more than 254 caharacters in a memory variable which i then would like to execute through macro expansion ?
>
>alternately, if somene has a better & more viable solution, can you please share it with me ?
>
>with sincere thanks in advance.
some thing like

m.lcsql = "Select * from abc "+;
"where abd = value1 "+;
"and abd1 =value2 "+;
......
......

&lcsql

makesure that it odes not cross the 8192 char limit

suhashegde