svein,
thanks for the suggestion, but I found the problem, if a date is not
filled in the query gives me a date, always '30/12/1899' instead of
nill or blank.
So the sort did work only it appeared to give the same date in all
the records, if I scrolled far enough in the grid I found the correct
dates.
What is the best way to avoid this ?
If there is no valid date the field should be nill or blank.

regards

Lee

--- In IBObjects@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

> Lee,
> the one thing that is different with your DATE_BIRTH field is that

Geb

> Datum includes a space. I don't know if this is the reason for your
> problems, but try changing Geb Datum to something less spacy and

see if

> that helps.
>
> Set
>
> At 09:59 09.03.2001 -0000, you wrote:
> >Hi,
> >I got a TIB_Query and a TIB_Grid.
> >I like to sort the grid in three different ways.
> >
> > with OrderingItems do begin
> > Clear;
> > Add('KlantNaam=NAME, FIRST_NAME');
> > Add('Geb Datum=DATE_BIRTH');
> > Add('Voornaam=FIRST_NAME, NAME');
> > end;
> > with OrderingLinks do begin
> > Clear;
> > Add('NAME=1');
> > Add('DATE_BIRTH=2');
> > Add('FIRST_NAME=3');
> > end;
> >
> >The DATE_BIRTH field is a date time field.
> >With the NAME and FIRST_NAME sort order I have no problems, this
> >works fine.
> >When I click in the grid on the DATE_BIRTH field, it does not sort
> >it, I get the same date in every field.
> >What am I doing wrong ?
> >
> >Regards
> >
> >Lee