Page 1 of 1
evdberr,invalid table name
Posted: Wed Jun 15, 2011 10:29 pm
by kcwvc52
what are some of the possible reason why i might be getting revdberr,invalid table name. do i have a limit of how many columns i can put into the sqlite table?
Re: evdberr,invalid table name
Posted: Wed Jun 15, 2011 11:24 pm
by jharris
I doubt the number of columns is your issue. How many columns do you have?
Could you post some code? It would be easier to help.
Re: evdberr,invalid table name
Posted: Thu Jun 16, 2011 2:32 am
by kcwvc52
i wish i could post code. the client ask me to keep any details of the project confidential(and the info i posted would show what i am working on). that's why i ask it the way i did. what are some examples of things that can cause that error. is is alternating between integers, reals, and text a problem? btw i have a few less than 50 columns (i think 47). this has kinda baffled me cause the statement looks to be perfect. as i have learned with sql, things have to be a little better than perfect
Re: evdberr,invalid table name
Posted: Thu Jun 16, 2011 3:31 am
by BvG
most likely you actually have tried to use a table name that is a reserved word. for example in sqlite, "index" is a reserved term, and trying to use a table or row with that name can and will break in anyoing ways. for example the engine might return to you that the name you're trying to use is invalid, which can break your code if you do not watch out.
Re: evdberr,invalid table name
Posted: Thu Jun 16, 2011 5:13 am
by kcwvc52
interesting i checked through it and just ended up retyping it and found that i had duplicated a column on accident. i'm guessing that could cause a problem.