>>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.
Another option would be to break the statement up as follows:
lcsqlstring = "INSERT INTO " + lctable + " ( "
lcSQlString = lcSqlString + lcsqlfields + " ) VALUES ("
lcSQlString = lcSqlString + lcvalues + ")"
This can be broken up even further, if you continue having problems.
However, IMO, Borislav's solution would probably be the best way to go.
Carsten M. Thode