Hi Venelina,
Thank you for answering. You were right but I find it not so very obvious because my parameter had the character value "0099". However, I got it working now and this is what I found out. My parametervalue lcFieldValue = [0099]; My lcFieldName = [MYSQLTABLEFIELDNAME]; My lcInsertString = [INSERT INTO MYSQLTABLE (]+lcFieldName+[) VALUES (]+lcFieldValue+[)] and
nInsert = SQLEXEC(nCon,lcInsertString) gives the result 99 in the SQL - table. What I had to do was to include additional apostrohes around my lcFieldValue, i.e. lcFieldValue = [']+[0099]+['] gives the result 0099.