Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error when running query against Interbase

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

0 Replies