Welcome to the nuBuilder Forums!

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

Invalid Table name error

Questions related to using nuBuilder Forte.
Post Reply
Sam
Posts: 10
Joined: Tue Sep 04, 2018 8:59 am

Invalid Table name error

Unread post by Sam »

Hi Toms,

When Insert data into table I get error: Student is not a valid table name for a Subform
You do not have the required permissions to view the files attached to this post.
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: Invalid Table name error

Unread post by toms »

Sam,

Please show me your form properties. (In, the Options Menu (top right)
form_propertiers.JPG
You do not have the required permissions to view the files attached to this post.
Sam
Posts: 10
Joined: Tue Sep 04, 2018 8:59 am

Re: Invalid Table name error

Unread post by Sam »

Herewith is the photo
You do not have the required permissions to view the files attached to this post.
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: Invalid Table name error

Unread post by toms »

Hmmm, there's no way to know what's wrong from this picture. Is there any object of type 'subform' on that form?
If you dump your db (to an sql file) and upload it here (or e.g. TinyUpload.com) , I'll tell you what's going wrong.
(Remove/replace any confidential data, if there are any)
Sam
Posts: 10
Joined: Tue Sep 04, 2018 8:59 am

Re: Invalid Table name error

Unread post by Sam »

toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: Invalid Table name error

Unread post by toms »

Thanks but I'd need an sql dump (.sql file) of your database
db.png
Export instructions:
https://www.inmotionhosting.com/support ... phpmyadmin
You do not have the required permissions to view the files attached to this post.
Sam
Posts: 10
Joined: Tue Sep 04, 2018 8:59 am

Re: Invalid Table name error

Unread post by Sam »

toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: Invalid Table name error

Unread post by toms »

Ok - I found the mistake. Table names (and also field names) are case sensitive.

Type the Table Name in lower case:
student.png
You do not have the required permissions to view the files attached to this post.
Sam
Posts: 10
Joined: Tue Sep 04, 2018 8:59 am

Re: Invalid Table name error

Unread post by Sam »

Thanks, you're a star.
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Invalid Table name error

Unread post by admin »

.
Post Reply