>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
You can change your approach and use INSERT ... From Name oObject. This way it will never be too long expression.
Edward Pikman
Independent Consultant