>Hi..
>
>If the variable 'lcvalues' on the following expression gets a big size.. only truncate and the sql expression is not accepted..
>
>Does anyone, could share any solution to concatenate it..
>
>
>lcsqlstring = "INSERT INTO " + lctable + " ( " + lcsqlfields + " ) VALUES (" + lcvalues + ")"
>
>
>TIA
>
>Claudio
How about:
TEXT TO lcsqlstring NOSHOW PRETEXT 15 TEXTMERGE
INSERT INTO <<lctable>> (<<lcsqlfields >>) VALUES (<<lcvalues>>)
ENDTEXT
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.