Subject RE: [IBO] IB_Query - Unsupported column type: 0
Author IBO Support List

I’m working with the sample app and seeing the problem.

I have an idea what is causing it and a work-around is to do as follows:

Put a call in the connection’s AfterConnect event that calls this method:

  cnMain.SchemaCache.GetDomainName( 'z', 'z' );


What needs to happen is the cursor for handling domain names needs to be prepared before you attempt to prepare your statement.

It doesn’t matter what values you pass into that procedure as the important thing is that the internal query is prepared.


I’ll have a permanent fix for this in the next sub-release.




Jason Wharton



From: [mailto: ]
Sent: Tuesday, May 10, 2016 1:24 AM
Subject: RE: [IBO] IB_Query - Unsupported column type: 0


How do I get CheckParams in a TIB_Query?


select   CUS_ID, CUS_STATE

from spordercussum(CAST(:a AS INTEGER), CAST(:b AS INTEGER), CAST(:c AS CHAR(15)))


What is wrong with this query??????????


I upgraded to the new version 5.7.11 2388 still the same problem.


For a Sample program download and run

Contains Source and an Executable,

extract it and run Invview.exe check the

user, password and then Push "Connect DB"

Then push "btPrepare" to generate the error.




From: [mailto: ]
Sent: Monday, May 9, 2016 4:15 PM
Subject: RE: [IBO] IB_Query - Unsupported column type: 0



This error will happen with certain statements.

Maybe set the CheckParams property to false?