Connect to SQLite problem

[Rob van der Sloot]

After some time out of LC, I wanted to do some research into connecting to a SQLite database, but are confronted with problems.
Can someone tell me why I get an integer problem with the following script? The answer I get is " "tConID is not an integer: Problem creating or accessing database!"

on mouseUp
global gConID
local tConId

put revOpenDatabase("sqlite","E:\Software\SQLite\SQLiteDBs","TestDB12.sqlite",,,,,,) into tConID

if tConID is empty then
answer warning "tConID is empty: Problem creating or accessing database!"
exit to top
else
if tConID is not an integer then
answer warning "tConID is not an integer: Problem creating or accessing database!"
exit to top
end if
else
answer information "Database is created! " & return & "The connection ID is: " & tConID
put tConID into gConID
end if
end mouseUp

Thanks
Rob van der Sloot

[FourthWorld]

Try using the complete file path in the third argument.

[sturgis]

The example from the dictionary for sqlite is this: revOpenDatabase("sqlite",filepath,[sqliteOptions])
So, you'd want to instead do something like this..
put revOpenDatabase("sqlite","E:\Software\SQLite\SQLiteDBs\TestDB12.sqlite") into tConID