|
Post by Chris Iverson on Mar 14, 2019 0:49:37 GMT -5
The included sample, "Simple Database.bas", will now run on Linux successfully(thanks, Carl!), but it will only run successfully once.
After that, the IDE MIGHT crash, OR display an error. If you check the error logs, you see the error: "table Payables already exists".
So, even though the Records.db file is being created and manipulated successfully on the first run, the second run doesn't see it.
After testing, I've determined that:
1) DefaultDir$ is set to the path of the bas file you opened. (In this case, $LB5-Path\bas_files) 2) Records.db does NOT get created in this folder; it gets created in the same folder as the LB5 executable you're running. (lb5alpha.exe, lin32-348, etc) 3) Changing the FILES statement to hard-code the correct path to the Records.db file works. 4) Copying the Records.db file into the bas_files folder works, but the code does not modify this copy. It still modifies the one in the binary folder.
|
|
|
Post by Carl Gundel on Mar 14, 2019 8:42:56 GMT -5
Thanks.
Changing the sqliteconnect lines (2 of them) to this makes the program work.
sqliteconnect #records, "./bas_files/Records.db"
But sqliteconnect should be respecting DefaultDir$.
|
|