Page 1 of 1
Invalid Table name error
Posted: Fri Sep 07, 2018 2:11 am
by Sam
Hi Toms,
When Insert data into table I get error: Student is not a valid table name for a Subform
Re: Invalid Table name error
Posted: Fri Sep 07, 2018 4:20 am
by toms
Sam,
Please show me your form properties. (In, the Options Menu (top right)
form_propertiers.JPG
Re: Invalid Table name error
Posted: Fri Sep 07, 2018 6:03 am
by Sam
Herewith is the photo
Re: Invalid Table name error
Posted: Fri Sep 07, 2018 7:50 am
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)
Re: Invalid Table name error
Posted: Fri Sep 07, 2018 8:44 am
by Sam
Re: Invalid Table name error
Posted: Fri Sep 07, 2018 8:51 am
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
Re: Invalid Table name error
Posted: Fri Sep 07, 2018 9:02 am
by Sam
Re: Invalid Table name error
Posted: Fri Sep 07, 2018 9:20 am
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
Re: Invalid Table name error
Posted: Fri Sep 07, 2018 10:37 am
by Sam
Thanks, you're a star.
Re: Invalid Table name error
Posted: Sat Sep 08, 2018 12:05 am
by admin
.