Page 1 of 1
Error: itemust is not a valid table name for a Subform
Posted: Mon Nov 23, 2020 12:54 pm
by Celson
Hello,
I am facing this error when trying to add a record to a new form I build with fast forms. Could somebody help me to discover what is wrong?
This is the snapshot with the error:
{D006D60A-19E9-4474-A597-EECB5D1A317D}.png
Some more information:
When I try to add the table in a SQL Builder it does not add it. If I press F12 I see an error. See snapshot:
{075AB277-0AB0-4253-B35E-FCDA0743B101}.png
Thanks in advance!
Re: Error: itemust is not a valid table name for a Subform
Posted: Mon Nov 23, 2020 1:05 pm
by kev1n
Hi,
Can you run this command in the developer console?
and show the result here (just the relevant part where the table itemust appears)?
Re: Error: itemust is not a valid table name for a Subform
Posted: Mon Nov 23, 2020 1:41 pm
by Celson
Hi,
I don't know what happened but when I logged in as globeadmin now and tried to add a record, it worked now!
Also, when I try to choose the table on SQL Builder it can be chosen now and appears on diagram!
Nothing was made by me for this!
Look... I now see I made mistake on a field... The field "ius_gus_codigo" is not correct to be a foreign key on grupoust table... I must call it "ius_grupoust_id". I know the name of field will not make it work or not, but I like to name all correctly."
Here is the snapshot:
{D64F64EE-2636-4E20-BB96-9D70EE0F23BA}.png
Re: Error: itemust is not a valid table name for a Subform
Posted: Mon Nov 23, 2020 7:32 pm
by Celson
Well, it just happened again, now with another new Fast Form built for the new database table "tarefas".
Note that the table "tarefas" does not appear when I call parent.nuFORM.tableSchema
The only thing I did that can be different (in both cases) is: I opened the database (phpMyAdmin) in another tab while I was filling the Fast Form.
1. Error after click on Save button
{31AC231D-4E84-4D29-8FD3-C86FD0DA8682}.png
2. Calling parent.nuFORM.tableSchema inside F12
{1F352F1B-8A0F-4CD6-A19B-B1C273959E9E}.png
Re: Error: itemust is not a valid table name for a Subform
Posted: Mon Nov 23, 2020 8:06 pm
by kev1n
Celson wrote:
Note that the table "tarefas" does not appear when I call parent.nuFORM.tableSchema
Did you log in afterwards?
Re: Error: itemust is not a valid table name for a Subform
Posted: Mon Nov 23, 2020 8:19 pm
by Celson
kev1n wrote:Celson wrote:
Note that the table "tarefas" does not appear when I call parent.nuFORM.tableSchema
Did you log in afterwards?
Yes! After I logged in it worked great!