SmashAndGrab
asked on
Table Not found - SQLITE error
I'm creating a windows phone 8 application.
I'm having some difficulty with my sqlite prepare statement. I get an error saying my table does not exist, although I've checked in multiple places for it, and it does exist, so I'm confused!
Error:
Code:
Database:
Hoping that someone can point me in the right direction :)
I'm having some difficulty with my sqlite prepare statement. I get an error saying my table does not exist, although I've checked in multiple places for it, and it does exist, so I'm confused!
Error:
Code:
Database:
Hoping that someone can point me in the right direction :)
Ok, Lets hardcode the path and then try ?
ASKER
hardcode?
Do you mean ..
C:\Users\FFTILSBL\Document s\Visual Studio 2015\Projects\MCRS_Mobile\ WP7.VideoS canZXing.S ampleApp\b izData.db
dbConn = new SQLitePCL.SQLiteConnection (Windows.A pplication Model.Pack age.Curren t.Installe dLocation. Path + @"\C:\Users\FFTILSBL\Docum ents\Visua l Studio 2015\Projects\MCRS_Mobile\ WP7.VideoS canZXing.S ampleApp\b izData.db" , SQLiteOpen.READWRITE);
Do you mean ..
C:\Users\FFTILSBL\Document
dbConn = new SQLitePCL.SQLiteConnection
Not working correct ?
Use below-
@"C:\Users\FFTILSBL\Docume nts\Visual Studio 2015\Projects\MCRS_Mobile\ WP7.VideoS canZXing.S ampleApp\b izData.db"
Use below-
@"C:\Users\FFTILSBL\Docume
ASKER
I changed it to:
dbConn = new SQLitePCL.SQLiteConnection (Windows.A pplication Model.Pack age.Curren t.Installe dLocation. Path + @"C:\Users\FFTILSBL\Docume nts\Visual Studio 2015\Projects\MCRS_Mobile\ WP7.VideoS canZXing.S ampleApp\b izData.db" , SQLiteOpen.READWRITE);
I get the same error
dbConn = new SQLitePCL.SQLiteConnection
I get the same error
Use...
dbConn = new SQLitePCL.SQLiteConnection (@"C:\User s\FFTILSBL \Documents \Visual Studio\2015\Projects\MCRS_ Mobile\WP7 .VideoScan ZXing.Samp leApp\bizD ata.db", SQLiteOpen.READWRITE);
dbConn = new SQLitePCL.SQLiteConnection
ASKER
i get the same error.
Take a look if you want..
Hello,
Please join the meeting, by clicking on this link:
http://go.teamviewer.com/v11/m52881968
Meeting ID: m52-881-968
Regards,
Buckwell Stuart
www.teamviewer.com - Easy online meeting & screen sharing
Take a look if you want..
Hello,
Please join the meeting, by clicking on this link:
http://go.teamviewer.com/v11/m52881968
Meeting ID: m52-881-968
Regards,
Buckwell Stuart
www.teamviewer.com - Easy online meeting & screen sharing
ASKER
I thought I'd setup a team viewer meeting?
If not, thats ok.
I tried the path you sent and it still didnt work.
Any ideas?
If not, thats ok.
I tried the path you sent and it still didnt work.
Any ideas?
ASKER
Any further ideas friend?
So I am assuming that the path is fine. Also could you please do one thing. Get the final string of the path , put that in the start and press enter and check if we are getting to the database folder.
I am looking for some other options.!
I am looking for some other options.!
ASKER
Sorry - I don't understand what you mean by:
" Get the final string of the path , put that in the start and press enter and check if we are getting to the database folder"
" Get the final string of the path , put that in the start and press enter and check if we are getting to the database folder"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok - If I paste this..
C:\Users\FFTILSBL\Document s\Visual Studio 2015\Projects\MCRS_Mobile\ WP7.VideoS canZXing.S ampleApp
into Windows explorer then it takes me to the folder where the database is.
Do you want to look on Team vweier?
http://go.teamviewer.com/v11/m52881968
Meeting ID: m52-881-968
C:\Users\FFTILSBL\Document
into Windows explorer then it takes me to the folder where the database is.
Do you want to look on Team vweier?
http://go.teamviewer.com/v11/m52881968
Meeting ID: m52-881-968
ASKER
hello?
Sorry I was traveling, I am looking..
ASKER
thank you :)
ASKER
would you like to use Team v?
ASKER
its on now if you want to look?
ASKER
Hi,
I found this on Google.
http://forums.macrumors.com/threads/help-with-no-such-table-error-with-sqlite.1141918/
I see that it mentions the path - the only trouble this is written in Xcode and not C#.
But it may point to the correct issue?
I found this on Google.
http://forums.macrumors.com/threads/help-with-no-such-table-error-with-sqlite.1141918/
I see that it mentions the path - the only trouble this is written in Xcode and not C#.
But it may point to the correct issue?
ASKER
hey - any luck?
Can you try accessing some other table using another query?
I think you path is incorrect. If our path is incorrect , SQLite internally creates an empty DB for you. <<So this new DB will not have any tables>>
Check below path....