Page 1 of 1
Error on SQL Builder when trying to add table
Posted: Fri Jan 19, 2018 1:57 am
by Celson
When I try to add a table on SQL Builder (I choose the table on dropdown) I see the following error:
See screenshot in attachment.
Re: Error on SQL Builder when trying to add table
Posted: Fri Jan 19, 2018 5:51 am
by toms
Hi,
Does it happen with any table or just the 'employee' table?
Re: Error on SQL Builder when trying to add table
Posted: Fri Jan 19, 2018 12:04 pm
by Celson
It happens with some tables. When I try to use one of the zzzz tables it works. For the tables built by me, in my tests it works in one of them and does not work in two tables created by me.
I was following that YouTube video that teaches to build a financial application in nuBuilder. I was using the SQL builder on product table to join with customer in order to show the customer name on customer column (instead of his id). In this moment, when I tried to show the tables (choose on dropdown field) it happened. With both customer and product tables.
Re: Error on SQL Builder when trying to add table
Posted: Fri Jan 19, 2018 12:10 pm
by toms
Quoting Steve:
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.
Could this be the reason?
Re: Error on SQL Builder when trying to add table
Posted: Fri Jan 19, 2018 12:35 pm
by Celson
Nothing was changed in phpMyAdmin after I started to follow the tutorial. I did it BEFORE to follow it. I've deleted a table from there.
Try to follow the tutorial "How To Build An Invoicing Application With nuBuilder". The error occurs at 2:14 of the video.
Re: Error on SQL Builder when trying to add table
Posted: Fri Jan 19, 2018 12:38 pm
by Celson
Hmmm... I think you found the problem! I just logged out then logged in... then I tried again and it works!!
Re: Error on SQL Builder when trying to add table
Posted: Fri Jan 19, 2018 6:56 pm
by admin
.