BASE : Problem creating a sub form

[Franky42]

I have a database under MySQL
In Base, I am able to create forms on my database through ODBC
When I create a subform and just add a field of the linked table. I can see the field correctly.
When I leave the edit mode, I have an SQL error that prevent to load the data

Statut SQL: HY000
Code d’erreur: 1000

SELECT * FROM artnouveau.auteurs WHERE ( artnouveau.auteurs.Num Adresse =:link_from_Num Adresse )

syntax error, unexpected NAME, expecting ‘)’ or OR

Maybe it is linked to the space between link_from_Num and Adresse?
What should I do?

[Ratslinger]

Hello,

Best to avoid using spaces - in databases, file names, folder names etc. Will cause headaches sooner or later.

For the parameter the space is meaningless. Use :link_from_Num_Adresse. For data field surround with quotes back tick. Use this anytime for field or table names with spaces or mixes case. Try a statement like this:

Edit - MySQL uses back ticks not quotes:

SELECT * FROM artnouveau.auteurs WHERE artnouveau.auteurs.`Num Adresse` = :link_from_Num_Adresse

The parentheses in the Where section are not needed for a single compare.