I sow somewhere in the internet saying that if you have a memo field in the table and you are inserting a “” into memo the sqlexec returns an error message if you do not have accept null checked in the table definition.

So here is what I did. I changed the table definition to accept null for all the fields and now it seems to be working. There no real theory behind this, this is all me. Probably this may not be true, because when I open the table and changed the status of the field it triggered something and started working? I don’t know.

Thanks for your comments