Page 1 of 1

Change table name - save new row problem

Posted: Thu Dec 14, 2017 2:06 pm
by pierrot
After manual rename of table under SQL and in Form editor, nuBuilder is displaying an error after saving new row in edit form.
Reloading page in web browser fix the problem.

Re: Change table name - save new row problem

Posted: Thu Dec 14, 2017 10:05 pm
by admin
pierrot,

Do you have a table named that?

Steven

Re: Change table name - save new row problem

Posted: Fri Dec 15, 2017 9:30 am
by pierrot
Yes I've.

It's repeatable error:
1. Create form with Fast Form creator.
2. Rename table in phpMyAdmin.
3. Rename table in nuBuilder Form.
4. Add new row in Browse Form and click Save.

Manual fix. Hit F5 and reload window with nuBuilder.

Re: Change table name - save new row problem

Posted: Fri Dec 15, 2017 11:30 am
by mkpbalajiin
It could be problem of lower case and upper case letter make sure table name and name in form are in same case

Re: Change table name - save new row problem

Posted: Fri Dec 15, 2017 12:16 pm
by toms
mkpbalajiin wrote:It could be problem of lower case and upper case letter make sure table name and name in form are in same case
I think it's more of a caching issue because the new table name is recognized after refreshing the page.

Re: Change table name - save new row problem

Posted: Fri Dec 15, 2017 5:57 pm
by admin
nuBuilder Forte loads the database schema at login (otherwise the system would slow down).

If you change something in phpmyadmin you'll need to login again.

I agree with mkpbalajiin though but I would say always use lowercase.

Steven