evdberr,invalid table name

[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?

[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.

[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

[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.

[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.