Hi,
I'm trying to run a query against a Interbase 2007 database.
It's like this:
SELECT * FROM PROCEDURE_POS('01-SEP-2005');
The query is tested from excel and from the "query analyser" for Interbase and works great!
But qlikview gives me the the following error:
SQL Error:[INTERSOLV][ODBC InterBase driver][InterBase]Dynamic SQL Error, SQL error code = -804, Data type unknown, unknown ISC error 335544796
SQL Scriptline:
SQL State:21S01
SQL SELECT * FROM PROCEDURE_POS('01-SEP-2005');
Do anyone have a clue how to fix this?
Thanks,
Kjetil