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:
Error
Code:
Code
Database:
Db
Hoping that someone can point me in the right direction :)
SmashAndGrabAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pawan KumarDatabase ExpertCommented:
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....

EE
0
SmashAndGrabAuthor Commented:
Thanks.

I have simplified the path now..

path
I still get the error!

Frustrating to say the least!
0
Pawan KumarDatabase ExpertCommented:
Ok, Lets hardcode the path and then try ?
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

SmashAndGrabAuthor Commented:
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);
0
SmashAndGrabAuthor Commented:
sqlNewError.PNG
0
Pawan KumarDatabase ExpertCommented:
Not working correct ?

Use below-

@"C:\Users\FFTILSBL\Documents\Visual Studio 2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp\bizData.db"
0
SmashAndGrabAuthor Commented:
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
0
Pawan KumarDatabase ExpertCommented:
Use...

dbConn = new SQLitePCL.SQLiteConnection(@"C:\Users\FFTILSBL\Documents\Visual Studio\2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp\bizData.db", SQLiteOpen.READWRITE);
0
SmashAndGrabAuthor Commented:
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
0
SmashAndGrabAuthor Commented:
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?
0
SmashAndGrabAuthor Commented:
Any further ideas friend?
0
Pawan KumarDatabase ExpertCommented:
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.!
0
SmashAndGrabAuthor Commented:
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"
0
Pawan KumarDatabase ExpertCommented:
I wanted to store the value of Windows.ApplicationModel.Package.Current.InstalledLocation.Path + @"\C:\Users\FFTILSBL\Documents\Visual Studio 2015\Projects\MCRS_Mobile\WP7.VideoScanZXing.SampleApp\bizData.db

in a string variable.

and take that value and click on start and paste that value and press enter. then you should be in the DB folder.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SmashAndGrabAuthor Commented:
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
0
SmashAndGrabAuthor Commented:
hello?
0
Pawan KumarDatabase ExpertCommented:
Sorry I was traveling, I am looking..
0
SmashAndGrabAuthor Commented:
thank you :)
0
SmashAndGrabAuthor Commented:
would you like to use Team v?
0
SmashAndGrabAuthor Commented:
its on now if you want to look?
0
SmashAndGrabAuthor Commented:
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?
0
SmashAndGrabAuthor Commented:
hey - any luck?
0
Pawan KumarDatabase ExpertCommented:
Can you try accessing some other table using another query?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Phone

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.