|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.
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.
This error will happen with certain statements.
Maybe set the CheckParams property to false?