Basically, when I open any of my forms with subforms, I get the above error message. I’m using Base as the frontend for a MySQL database. I’ve been successfully using this setup for quite a while, andI have no idea why it just started doing this. I’m sorry if this is a duplicate of another post, but I’m unable to find any answers that I’m able to make heads or tales of.
First try this:
Open the database file.
Edit → Database → Advanced Settings → Special Settings → Replace named parameters with '?'
Set this to yes.
This possibility couldn’t be set in every driver.
If there isn’t a possibility to set it in this way, you have to open the *.odb-file with a packing-program (ZIP). Try this with a copy, bot with the (only) original file!
Open content.xml inside the *.odb-file.
Search for
db:parameter-name-substitution="false"
and set this to
db:parameter-name-substitution="true"
Save content.xml and also save the *.odb-file.
1 Like
Perfect! Thanks! You prempted the first problem. (The “Replace named parameters…” checkbox wasn’t there.)