Hi Helen,

I think I found the problem (but not the solution), it seems like the
OrderingLinks and OrderingItems properties are cleared at some stage during
run time. I set all the properties during design time and I do not clear
them myself. It almost seems like the properties are not stored. Weird. I'll
let you know if I find what causes this.

-Don



-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 06 August 2001 05:30
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Refusal of ordering and searching


At 05:18 PM 06-08-01 +0200, you wrote:

>I've got a simple one-table-non-joined query which I'd like to order and
>search on.
>
>The query looks like this:
>SELECT
> CUST_ID, NAME, SURNAME, ID_NO, PHONE_H, PHONE_W, PHONE_CELL,
> FAX, PH_ADDR_1, PH_ADDR_2, PH_ADDR_3, PH_ADDR_4, PH_CODE,
> PO_ADDR_1, PO_ADDR_2, PO_ADDR_3, PO_ADDR_4, PO_CODE,
> NOTES
>FROM
> CUSTOMERS
>
>The TIB_Query .OrderingItems property is set to:
>CUST_ID=CUST_ID;CUST_ID DESC
>NAME=NAME;NAME DESC
>
>The OrderingLinks property is set to:
>CUST_ID=1
>NAME=2
>
>The OrderingItemNo property is set to 1.
>
>I've done the sorting of tables plenty times now and for some reason the
>sorting on the most simple query of them all doesn't want to work. What
>other properties do I still need to set? The CUST_ID field is the table's
>primary key. I also have a problem searching through the table but I think
>once the sorting has been sorted out, the searching would also work.

Don,
Just an outside chance -
Does it make a difference if you use another word for the "user-friendly"
alias "NAME"? e.g. change the orderingitem entry to
CUSTOMERNAME=NAME;NAME DESC

and the orderinglink to
CUSTOMERNAME=2

NAME is sometimes a tricky word to use in Delphi because it's reserved.
Another one I've noticed causing problems is UNIT...

regards,
Helen



All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________




Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/