Subject Re: [IBO] IB_Query - Unsupported column type: 0
Author Svein Erling Tysvær
Post date 2016-05-10T06:15:40Z
What about using a CTE to circumvent the problem?

with tmp(a, b, c) as
(select CAST(:a AS INTEGER), CAST(:b AS INTEGER), CAST(:c AS CHAR(15))
 from rdb$database)
select   CUS_ID,  CUS_STATE
from tmp t
left join spordercussum(t.a, t.b, t.c) on (1=1)

I haven't tried, but hope this doesn't give the same error.

HTH,
Set

2016-05-09 22:14 GMT+02:00 'IBO Support List' supportlist@... [IBObjects] <IBObjects@yahoogroups.com>:


This error will happen with certain statements.

Maybe set the CheckParams property to false?

 

Jason

 

 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, April 25, 2016 5:50 AM


To: IBObjects@yahoogroups.com
Subject: RES: [IBO] IB_Query - Unsupported column type: 0

 




Yes,

I get an error if testing only your executable.

If I compile with my delphi xe8 and IBO , there is no error.

 

Luiz

 

De: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Enviada em: domingo, 24 de abril de 2016 23:53
Para: IBObjects@yahoogroups.com
Assunto: RE: [IBO] IB_Query - Unsupported column type: 0

 

 

Thanks,

 

I am using Delphi 7, could you please try running the executable

included in the file to see what results you get.


Thanks

 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Saturday, April 23, 2016 8:02 PM
To: IBObjects@yahoogroups.com
Subject: RES: [IBO] IB_Query - Unsupported column type: 0

 

 

Hi,

 

I downloaded  your test sample, compiled and executed in IBO(latest version) and XE8.

I found no problem.

 

Luiz

 

De: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Enviada em: quinta-feira, 21 de abril de 2016 18:28
Para: IBObjects@yahoogroups.com
Assunto: [IBO] IB_Query - Unsupported column type: 0

 

 

Hello,

 

Getting an error when I try to open a TIB_Query which is selecting from a stored procedure.

 

Error: Unsupported column type: 0.

 

The query contains:

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

 

The error occurs with or without the CAST in the query, I added them so as to see if the problem was some sort of error with the prepare not being able to tell what kind of Param it was.

 

I created a test program which recreates the error and uploaded it to

test4.zip

 

 

 

 

 

Preview by Yahoo

 

 

 

 

 

 

 

 

 

 

Source and an executable, extract it and run Invview.exe check the

user, pass and then Push "Connect DB"

Then push "btPrepare" to generate the error.

 

Delphi 7

IBO 5.7.9_2360

Windows 8.1

 

Really don't understand why this is happening, I am going to continue to

try and trace the code in IBO but it is hard.  Please advise how to fix this.

Trying to get to the new version of IBO so I can upgrade to the new version

of Delphi.

 

Thanks

Michael Horne