I am getting an error when running a master/detail form stating ‘Error while accessing the database… error in SQL syntax…’ The form has a master table and links to a related table. The linkage was done in by choosing the related form using the master/detail relationship standard master/detail procedure on the menu. I think I’ve narrowed the issue to the fact that the first record in the master table has a leading apostrophe. So I’m thinking that an escape character or something is somehow needed in the sql that is generated so that the apostrophe can be handled. If I do a WHERE clause on the Master such that this record is skipped, the master/detail form works okay.
Any thoughts on how I might a) edit the relationship in SQL, and b) what might be the correct syntax. I don’t know where to find the generated SQL and how to modify the code generation.
The database is MySql.
Thanks for any thoughts!!