HI.
I’m testing ExeOutput on an application that uses Sqlite as Database.
Everything works perfectly until I go to modify a record already present in the DB (I haven’t tried with Insert).
After modifying a text field, it appears in the list of records but if I exit and return from ExeOutput the record is the same unmodified
.
Surely I’m the one who’s making some settings wrong but I don’t know which settings to enable.
I would like to point out that the app works correctly in the cloud.
Thanks in advance for any help.
If your SQLite database file is inside your compiled software, it will not update.
Files like software.db must be outside the exe and in a folder that is writable by Windows. If this is the case, try:
Not near my desktop with all my files, but something like this:
$storagelocation = exo_getglobalvariable('HEPubStorageLocation', '');
//Create a new SQLite3 Database
$db = new SQLite3($_SERVER['DOCUMENT_ROOT'].'/../software.db');
If I recall the above $db = will place the database in same folder as your exe. You could also place in users/public.
1 Like