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

Actually, you need to make two calls.

One call with an invalid value and one call with a valid value.

This is what I added to your sample app in order to work around this issue:

procedure TFormMain.cnMainAfterConnect(Sender: TIB_Connection);


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

  cnMain.SchemaCache.GetDomainName( 'SPORDERCUSSUM', 'CUS_ID' );


Please let me know if this doesn’t make sense and you need more help.



Jason Wharton



From: [mailto: ]
Sent: Thursday, May 12, 2016 10:49 PM
Subject: RE: [IBO] IB_Query - Unsupported column type: 0


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?