Subject | Query result not displayed |
---|---|
Author | Hedfi Mourad |
Post date | 2011-10-05T10:51:55Z |
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]
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]