Record Missing


2004-04-08 11:43:37 AM
delphi248
I'm transfer data from interbase 5.5 database to 6.5 database..Occasionally,
I
encounter a problem that certain records can't be found at interbase 6.5
database. However, i query the specific record (eg. using where statement),
the record will appear. If i query all record, the record will not appear.
Item Qty Nett Date
----- --- ---- ----
A 1 10.90 04/07/2004
B 2 16.00 04/07/2004
C 3 9.00 04/07/2004
1) If i query the records based on date, only two records appeared.
select * from table1 where date = "04/07/2004";
Result:
Item Qty Nett Date
----- --- ---- ----
A 1 10.90 04/07/2004
C 3 9.00 04/07/2004
2) First, i thought the B record is missing, then i try to query the record
based on date and item (B)...lastly, B record will be appeared.
select * from table1 where date = "04/07/2004" and item = "B";
Why this happen?
Thank You.
From Alvin