Connect SQL - doesn't work

[Dzemous]

Why this connect doesn't work? 

local connect = dbConnect("sqlite",":resources/Mlife.db")

Script is in:

Resources/ZP (ZP this folder with script)

Data Base File is in main folder with scripts.

Script can't find data base file about name Mlife.db, but this data base file there is

[Simple0x47]

Move the database file to the ZP folder and change this to.

local connect = dbConnect("sqlite",":ZP/Mlife.db")

 

[Dzemous]

I don't will create multi data base. I want to have one for everything
 

[Simple0x47]

Then do it like this, put the database into the sql folder and for accessing the database use the exported function like this way.

exports.sql:query( theDatabaseID, theQueryString ) -- theDatabaseID is the key that holds the database value in main.lua, yours is 1, and the querystring is a query for example "INSERT INTO ..."

http://www75.zippyshare.com/v/Ko6JMf2O/file.html

[Dzemous]

Ok, thanks Can close this topic.