I am creating a little app that uses an SQLite database (first time). It works fine in the LC environment but I don't understand how to define the path to the database so that it's found in the standalone. For developing purposes I put the database in the same folder as the LC Stack, so I just give the database name:
Code: Select all
put revOpenDatabase("sqlite","db_test",,,,,,)
Obviousely the database is not found and I have no idea which path to specify . I tried with:revdberr,Database Error: no such table: test_mail
Code: Select all
put item 1 to -2 of the longFilePath of me into thepath
put revOpenDatabase("sqlite","thepath/db_test",,,,,,)