Forums

Problem with DB update.

mieszko 06 Sep, 2016
Hello,
I have a form that save data to three tables, lets say: "table1", "table2", "table3" in database. Every record in every table has fields named "uid" and "verified". I am able to update a record only in "table1", but when I want to do it in two others, it doesn't work. What is more, when I change a table in DB Read and DB save to "table2" or "table3", data is updated in "table1" anyway. Why?
Thank you for help in advance.
GreyHead 13 Sep, 2016
Hi mieszko,

It's impossible to say what the problem is from the information here. If you want to update a record then the data to be saved must include the Primary Key value of that record, usually from the first column of the table and often named id or cf_id.

I don't see any obvious reason why changing the Table Name in a DB Read would not read the new table. if you add a Debugger action you can see the MySQL query that is being created. It might help to click the Delete cache icon in the Forms Manager toolbar but this is usually only needed when you have added or renamed columns in a table.

Bob
This topic is locked and no more replies can be posted.