Missing records after packing Paradox table
Windows 95
Database Desktop 7
Paradox 5 table
I've recently encountered a weird problem where records were not being
selected in a query unless I included an ORDER BY clause in the SQL. This
led me to believe that somehow my table was corrupt in such a subtle way
that the BDE could not detect it. I decided to pack the table to see if that
would make a difference, and lo and behold, the same records that were not
appearing in the query had been deleted from my table.
I ended up solving the problem by copying the table, emptying it and the
packing it to create a fresh copy. I then performed a SELECT on the corrupt
table including an ORDER BY to ensure that all records were selected, and
then added the result set to the new table. All records, except one were
added (now that's another problem).
Can anyone tell me what would cause this and how I can prevent it?
Helge
begin 666 Helge Bredow.vcf
M0D5'24XZ5D-!4D0-"DXZ0G)E9&]W.TAE;&=E#0I&3CI(96QG92!"<F5D;W<-
M"D]21SI"96%C;VX@5&5C:&]N;VQG>2!0='D@3'1D#0I4251,13I3;V9T=V%R
M92!%;F=I;F5E<@T*0412.U=/4DLZ.S8Q(# X(#DS,38@,3(R,CL[5V5S="!0
M97)T: T*3$%"14P[5T]22SM%3D-/1$E.1SU154]4140M4%))3E1!0DQ%.C8Q
M(# X(#DS,38@,3(R,CTP1#TP05=E<W0@4&5R=&@-"E523#IH='1P.B\O=W=W
M+F)E86-O;BYC;VTN874-"D5-04E,.U!2148[24Y415).150Z:&5L9V5 8F5A
78V]N+F-O;2YA=0T*14Y$.E9#05)$#0H`
`
end
end
