Subject Re: [IBO] TIBOTable and QR
Author Jason Wharton
I don't think it is possible to get a descending sort using this property.
You have to supply the name of an index with a descending sort to accomplish

I believe I did make the IndexFieldNames have a way to do descending but I
cannot remember exactly how. A peek in the sources would tell.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Daniel Rail" <drail@...>
To: <>
Sent: Wednesday, October 31, 2001 6:13 AM
Subject: Re: [IBO] TIBOTable and QR

> Have you tried using the IndexFieldNames property in TIBOTable?
> Daniel Rail
> Senior System Engineer
> ACCRA Med Software Inc. (
> At 31/10/2001 07:22 AM, you wrote:
> >Hello,
> >
> >I am having to use a TIBOTable instead of my usual TIBOQuery because it
> >part of
> >a master-detail relationship for printing a report. the key field my
> >TIBOQuery
> >(master) and TIBOTable (detail) use is called UARN. It works fine,
> >especially
> >as the max number of records in the detail TIBOTable per UARN is 30 so
> >not
> >worried about the size of the table.
> >
> >There is however a problem, my printout needs the detail records in a
> >certain order:
> >
> >LIST > EFF_KEY > ALT_KEY (first one is a varchar(4) carrying a year, then
> >the other two are date fields and I need them all descending)
> >
> >The problem is that to make this happen I need to set the TIBOTable to an
> >use
> >an index like:
> >
> >create descending index index1 on hist (uarn, list, eff_key, alt_key)
> >
> >Now it works however there is 1.8million records in this table and the
> >becomes quite large, Im trying to keep my GDB down as much as possible.
> >
> >Is there a way of sorting this TIBOTable information locally at the
> >end?
> >This would negate the need for a large index and as there is likely to be
> >only upto 30 records for each Master record, it wouldnt be slow,
> >
> >Any ideas welcomed.
> >
> >Cheers,
> >
> >Andy
> IB Objects - direct, complete, custom connectivity to Firebird or
> without the need for BDE, ODBC or any other layer.
> - your IBO community resource for Tech Info
> keyword-searchable FAQ, community code contributions and more !
> Your use of Yahoo! Groups is subject to