We have a informix database with stored procedure named LicenseTotals() We have a quicker version to run the software using SQL Lite. However, the query below throws error when SQL Lite is used.
SELECT name,value FROM TABLE( FUNCTION LicenseTotals()) (pkid,name,value,UserValue,DeviceValue)
Below is the error I get;
System.Data.SQLite.SQLiteException (0x80004005):
SQL logic error or missing database near "TABLE": syntax error
Aucun commentaire:
Enregistrer un commentaire