Link to home
Start Free TrialLog in
Avatar of SmashAndGrab
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:
User generated image
Code:
User generated image
Database:
User generated image
Hoping that someone can point me in the right direction :)
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Try Database Path.

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

User generated image
Avatar of SmashAndGrab
SmashAndGrab

ASKER

Thanks.

I have simplified the path now..

User generated image
I still get the error!

Frustrating to say the least!
Ok, Lets hardcode the path and then try ?
hardcode?

Do you mean ..


C:\Users\FFTILSBL\Documents\Visual Studio 2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp\bizData.db


dbConn = new SQLitePCL.SQLiteConnection(Windows.ApplicationModel.Package.Current.InstalledLocation.Path + @"\C:\Users\FFTILSBL\Documents\Visual Studio 2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp\bizData.db", SQLiteOpen.READWRITE);
Not working correct ?

Use below-

@"C:\Users\FFTILSBL\Documents\Visual Studio 2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp\bizData.db"
I changed it to:

dbConn = new SQLitePCL.SQLiteConnection(Windows.ApplicationModel.Package.Current.InstalledLocation.Path + @"C:\Users\FFTILSBL\Documents\Visual Studio 2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp\bizData.db", SQLiteOpen.READWRITE);
           

I get the same error
Use...

dbConn = new SQLitePCL.SQLiteConnection(@"C:\Users\FFTILSBL\Documents\Visual Studio\2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp\bizData.db", SQLiteOpen.READWRITE);
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
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?
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.!
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"
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok - If I paste this..

C:\Users\FFTILSBL\Documents\Visual Studio 2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp

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
hello?
Sorry I was traveling, I am looking..
thank you :)
would you like to use Team v?
its on now if you want to look?
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?
hey - any luck?
Can you try accessing some other table using another query?