Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Editing a database

Questions related to using nuBuilder Forte.
Post Reply
Esnitiv620
Posts: 3
Joined: Thu Feb 04, 2021 10:07 am

Editing a database

Unread post 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.
kev1n
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

Unread post 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.
You do not have the required permissions to view the files attached to this post.
Esnitiv620
Posts: 3
Joined: Thu Feb 04, 2021 10:07 am

Re: Editing a database

Unread post 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?
kev1n
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

Unread post by kev1n »

Is just one field not saved or any?
Are there any errors? Check nuDebug Results and the Developer Console output.
Esnitiv620
Posts: 3
Joined: Thu Feb 04, 2021 10:07 am

Re: Editing a database

Unread post 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.
You do not have the required permissions to view the files attached to this post.
kev1n
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

Unread post by kev1n »

The column P.nummer doesn't exist in your Bestelproduct table. Use phpMyAdmin to view the database column.
Post Reply