Subject RE: [IBO] IB_Query - Unsupported column type: 0
Author Michael Horne

I added the 2 lines and that seems to have stopped the error.

 

Thanks

 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Friday, May 13, 2016 12:57 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IB_Query - Unsupported column type: 0

 

 

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);

begin

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

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

end;


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

 

Thanks,

Jason Wharton

www.ibobjects.com

 

 


From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Thursday, May 12, 2016 10:49 PM
To: IBObjects@yahoogroups.com
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.

 

Thanks!

 

Jason Wharton

 

 


From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, May 10, 2016 1:24 AM
To: IBObjects@yahoogroups.com
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

test4.zip

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: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, May 9, 2016 4:15 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IB_Query - Unsupported column type: 0

 

 

This error will happen with certain statements.

Maybe set the CheckParams property to false?

 

Jason