Subject | Re: Bug with Last, OrderingItemNo and Pos |
---|---|
Author | anthpjc |
Post date | 2002-08-19T04:01:20Z |
Hi,
(IBO 4.2hg, BCB6(SP2), FB 1.0-796)
I've also experienced some problems with the OrderingItemNo;
I've got ordering set for 3 attributes, 2 from the key relation and
one from a relation selected by a nested select.
When I've set the ordering item to 1 I've received the ISC Error
Code: 335544569 'column unknown' on the non-key relation column upon
which the ordering item is set, then when changing the OrderingItemNo
to 0 the error is gone but the ordering set on the column is non-
existent.
anth
(IBO 4.2hg, BCB6(SP2), FB 1.0-796)
I've also experienced some problems with the OrderingItemNo;
I've got ordering set for 3 attributes, 2 from the key relation and
one from a relation selected by a nested select.
When I've set the ordering item to 1 I've received the ISC Error
Code: 335544569 'column unknown' on the non-key relation column upon
which the ordering item is set, then when changing the OrderingItemNo
to 0 the error is gone but the ordering set on the column is non-
existent.
anth
--- In IBObjects@y..., "Miguel" <miguel@i...> wrote:
> I think that I have found an IBO bug. I am using the last IBO
version
> avaliable and FB 1 Release Version.
>
> I usually have two indexes, ascend and descent to get that when I
call Last
> Dataset procedure and the navegability can be very fast with IBO 4.
It works
> very fine but if I call Last procedure and I change the
OrderingItemNo, my
> DBGrid (I don't use native controls) begins to do strange things,
the
> TDataset becomes empty, if I change the OrderingItemNo again I see
the
> TDataset empty again or two or three records, and so on. You can
test it
> calling Last and changing the ordering.
>
> Jason, has you any idea about this? If I remove the POS parameter in
> OrderingLinks I haven't any problem.
>
> My OrderingItems by example:
>
> Código=CNAE;CNAE DESC
> Descripción=TITULO;TITULO DESC
>
> My OrderingLinks:
>
> CNAE=ITEM=1;POS=0
> TITULO=ITEM=2;POS=0
>
> If I change this to::
>
> CNAE=1
> TITULO=2
>
> My problems go out.
>
> My KeyField is ID, an autoincrement field value that I get with a
generator
> using GeneratorLinks or IB trigger.
>
> Thank you.