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.
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Editing a database
-
- nuBuilder Team
- Posts: 4307
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 447 times
- Contact:
Re: Editing a database
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.
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.
You do not have the required permissions to view the files attached to this post.
-
- Posts: 3
- Joined: Thu Feb 04, 2021 10:07 am
Re: Editing a database
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?
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?
-
- nuBuilder Team
- Posts: 4307
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 447 times
- Contact:
Re: Editing a database
Is just one field not saved or any?
Are there any errors? Check nuDebug Results and the Developer Console output.
Are there any errors? Check nuDebug Results and the Developer Console output.
-
- Posts: 3
- Joined: Thu Feb 04, 2021 10:07 am
Re: Editing a database
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.
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.
You do not have the required permissions to view the files attached to this post.
-
- nuBuilder Team
- Posts: 4307
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 447 times
- Contact:
Re: Editing a database
The column P.nummer doesn't exist in your Bestelproduct table. Use phpMyAdmin to view the database column.