Just to make sure: remove all other conditions from the WHERE clause,
leaving only PREGREF_DATEENTREE_PK = '01.01.9999' and see what happens.
Eventually, remove the condition PREGREF_DATEENTREE_PK = '01.01.9999'
(leaving all the rest) and see if you get your record. If you do without
the date condition, while you don't with the condition, you can blame
the date itself.
However, I'm pretty sure the date is not the cause.
I've sketched a simple example:

create table T (
F timestamp
);

commit;

insert into T values ('01.01.9999');

select * from T where F = '01.01.9999';

and it works as expected (one record in the result set).

regards
Tomasz

On 2011-10-05 12:51, Hedfi Mourad wrote:
> Hello everyone,
>
> Through an application, I've inserted a record to my 1.5 Firebird database.
> In this record, I've a Date column in which I've inserted '01.01.9999'
> value. The insertion was finished successfully, but when I execute the
> following query to show data record,
>
> SELECT * FROM PREGREF_PRE_GROUPE_REF WHERE PREGREF_GREF_CODE_FK_PK = 1022
> AND PREGREF_PRE_CODE_FK_PK = '4973461' AND PREGREF_DATEENTREE_PK =
> '01.01.9999' AND PREGREF_GREF_DATECR_FK_PK = '25.11.2010';
>
>
>
> The data are not displayed. I've user IBExpert and isql tool but I've always
> the same result
>
>
>
> Does anyone have an idea to resolve this problem.
>
>
>
> Best regard.
>
>
>
> [Non-text portions of this message have been removed]
>
>


--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__