Subject Re: [IBO] Error on IB_Query
Author Helen Borrie (TeamIBO)
At 05:26 PM 22-04-02 -0300, George Hugo wrote:
>Some others info about the App
>The Select statment:
>
>Select C.*,
>(Select Desc_Seg From Segmentos S Where S.ID_SEG = C.ID_SEG),
>(Select Desc_FPagto From FormaPagto F Where F.ID_FPAGTO = C.ID_FPAGTO)
> >From Clientes C

Change it to
Select C.*,
(Select Desc_Seg From Segmentos S Where S.ID_SEG = C.ID_SEG)
as Desc_Seg,
(Select Desc_FPagto From FormaPagto F Where F.ID_FPAGTO = C.ID_FPAGTO)
as Desc_FPagto
From Clientes C

and, in the query's property editor, give those two subselected columns the
COMPUTED attribute.

Also, I don't see why you are a pointer to pass the dataset
reference. Just pass a TIB_Query - it's already a pointer.

Because you are hopping around the houses, possibly you will cure the 'no
statement handle' problem by testing whether statements are prepared before
calling Open.

You might like to look at the TIB_StatementSource component, which will
look after this for you. You can track an implementation of this in the
sources for the IB_SQL project.


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com