dimanche 12 avril 2015

Calling Informix Stored Procedure from SQL Lite

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