slqite3 issue

[vdubeau]

I tried following examples. my code is below:

Dim $con As New Connection
Try $con.Close()
$con.Type = "sqlite3"
$con.host = "./"
$con.name = "Invoices.db"
$con.Open
I get the message "Unable to locate database 'invoices.db' in ./"

I have the database file in the directory where the program resides.
What am i doing wrong? Any help is appreciated.

Thanks

[BruceSteers]

did you try an absolute path?

$con.host = Application.Path

I'd use the ./ path only for reading files, for writing (or other uses, i guess db) then i'd use Application.Path

[thatbruce]

Two notes:
1) You CANNOT write to a database inside the executable(nor any other file inside the executable.) The database must exist outside the executable.
2) As Bruce says you must use a FULL path to the sqlite file. Read up up on how Gambas uses relative paths.
b