SQL query through an imported database swift

726 views Asked by At

So I have imported a pre-made SQLite database into my application and according to the path set (that you see in the picture labeled "ThePath") the application can open the database. I imported the database by just dragging and dropping it into my App like i read online in other tutorials and I have the FMDB wrapper to help to handle all the database implications of everything as you can also see from all the objective-C files.

So after I saw i could open my database I tried to get a direct SQL query going as you can see in the code below but it says that it can't find the table name that I put in (See the error in bottom left). When I do the query in my SQL browser and my android app it comes out fine but here it doesn't seem to see anything.

Bottom Line: Does anybody see something wrong with this picture? Did i put the database in the wrong place or am i opening it wrong? please help as I am super new to swift!

enter image description here

2

There are 2 answers

0
Marcos.Serres On

In your line of Path, you are using: ("insight1-0", ofType: "sqlite").

That should be: ("insight1-0", ofType: "db")

4
Eliana Ferreira On

Are you sure that your table name is "Greek Mythology"? Separated by blank space?