The date is stored as the number of days since 30.12.1899 and if you're not
careful this is the date you end up with when trying to use blank. I don't
quite remember how to explicitly set a date to blank, you could try
ib_query.FieldByName('DATE_BIRTH').Clear

Set

At 11:22 09.03.2001 -0000, you wrote:

>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
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>