says "syntax error"; no record added

The following article explains how to display SQL queries on the page:

http://xlinesoft.com/phprunner/docs/debugging_tips.htm

Thanks
I should have mentioned it: I am on the edit page (stand alone not in-line). All the fields are correct displayed, the error comes when the add button is pressed.
The debug booolean pointed shows me the queries that are performed to build the fields and the drop-downs content but not the final UPDATE sql statement.

Post the code of the "Before record added" event.

Pretty easy: there is no code at all <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=64149&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

I recommend to contact support directly sending your project and database for investigation. You can do that at http://support.xlinesoft.com.

I was quite surprise that a simple thing haven't worked, so I tried one even more simply: a table without any connections and the insertion worked. It means that there are some master/detail issues that have still to solve.
So I will ask to the support how to print the SQL command right before adding a row in the table.

You need to contact support directly in this regard. Send us your project and database for investigation. You can do that at http://support.xlinesoft.com.