>Hi, Borislav
>
>No, This does not work. I still get 'string is too long.'
>>
>>TEXT TO lcSELECT TEXTMERGE NOSHOW
>> SELECT <<alist[1]>>, <<alist[2]>>........
>> WHERE <<aCond[1]>><<aCond[2]>>.....
>> ORDER BY <<cSort_Set>>
>> INTO CURSOR <<cTable_Name>>
>>ENDTEXT
>>&lcSELECT
>>
>
>I have tried it several different way, and can not get it to work. I put it around each select statement in the case statement. I put it around the entire case statement - got a string length of 9530 that time. The string length with len() is under 2000 for most time except above statement.
Can you cut that string?
Or split it to two different selects?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.