Page 1 of 1

Editing a database

Posted: Thu Feb 04, 2021 10:20 am
by Esnitiv620
How can I make a form in which I can edit a connected database? I have used an “input: text” and an “input: number” object in a browse and edit form. I can enter a number in the form, but is doesn’t change in the database. What do I need to change to make this work?
The database is in phpmyadmin and contains 3 tables.

Re: Editing a database

Posted: Thu Feb 04, 2021 10:40 am
by kev1n
Hi,

1. Make sure that the column exists in the database.
2. Re-login to nuBuilder after creating new columns.
3. Make sure the Object ID and the column name match (case sensitive!)
4. If the Datatype is displayed (v 4.5.), it means that everything is correct and saving should work.

Re: Editing a database

Posted: Wed Feb 10, 2021 12:58 pm
by Esnitiv620
Hi,
Thank you for your reaction.
We have checked each one of your points and they are all correct, but it still doesn’t work. Do you have any other tips that could make it work?

Re: Editing a database

Posted: Wed Feb 10, 2021 1:03 pm
by kev1n
Is just one field not saved or any?
Are there any errors? Check nuDebug Results and the Developer Console output.

Re: Editing a database

Posted: Thu Feb 11, 2021 10:04 am
by Esnitiv620
Hi,
I have checked the NuDebug Results.
It gives multiple errors, like the one below. I am new to nuBuilder so I have no idea how to fix this.

Re: Editing a database

Posted: Thu Feb 11, 2021 10:34 am
by kev1n
The column P.nummer doesn't exist in your Bestelproduct table. Use phpMyAdmin to view the database column.