Page 1 of 1

sql query of non cspro file

Posted: May 2nd, 2020, 10:58 am
by AriSilva
Is there a way to execute sqlqueries on an outside file other than csdb or paradata files?
Furthermore, the base I´m trying to access is on a server and has to be logged in with a psw.

Re: sql query of non cspro file

Posted: May 4th, 2020, 8:04 am
by Gregory Martin
You can query any SQLite file:
numeric result = sqlquery("sqlite-database-filename.db", "SELECT ...");
However, it must exist on the local filesystem. At the moment, there is no way to query an external server.