sqlite 'invalid database type' error in standalone
Posted: Thu Jan 02, 2020 3:36 pm
Hi,
I have searched the forum for a solution to my problem but can't seem to find anything that works. I am using the latest version of LC (community) on windows. I'd be grateful for any help as I'm starting to wonder is it just me or is there a bug in LC.
I can access the database in the IDE but not in a standalone. I am using the code....
put "DB" into ldatabasename
put specialFolderPath("Engine") & slash & ldatabasename into ldatabase
get revOpenDatabase("sqlite", ldatabase, , , , )
I have also tried
put "DB" into ldatabasename
put specialFolderPath("Engine") & slash & ldatabasename into ldatabase
get revOpenDatabase("sqlite", ldatabase )
The database is located in the same folder as the standalone.
In the standalone settings I have tried automatically detecting inclusions and also tried manually selecting the inclusions
sqlite
database (tried with and without)
ssl
HTTPD
Answer
Ask
It does work when I save as a standalone for Windows using runrev 2-8-1 on my OSX machine and then run the standalone on Windows 10.
I have been using this platform since runrev 2-8-1 and can usually find a solution but not this time
Thanks in advance for any advice.
Paul
I have searched the forum for a solution to my problem but can't seem to find anything that works. I am using the latest version of LC (community) on windows. I'd be grateful for any help as I'm starting to wonder is it just me or is there a bug in LC.
I can access the database in the IDE but not in a standalone. I am using the code....
put "DB" into ldatabasename
put specialFolderPath("Engine") & slash & ldatabasename into ldatabase
get revOpenDatabase("sqlite", ldatabase, , , , )
I have also tried
put "DB" into ldatabasename
put specialFolderPath("Engine") & slash & ldatabasename into ldatabase
get revOpenDatabase("sqlite", ldatabase )
The database is located in the same folder as the standalone.
In the standalone settings I have tried automatically detecting inclusions and also tried manually selecting the inclusions
sqlite
database (tried with and without)
ssl
HTTPD
Answer
Ask
It does work when I save as a standalone for Windows using runrev 2-8-1 on my OSX machine and then run the standalone on Windows 10.
I have been using this platform since runrev 2-8-1 and can usually find a solution but not this time
Thanks in advance for any advice.
Paul