General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
PACK will do NOTHING if there are no deleted records.
Well, almost nothing... it will go through the motions to eof, then when it finds nothing deleted it simply erases the copy it has made and ends.
good luck
>Hi,
>I am implementing a function to automatically fix 2091 errors, everything worked until I packed the file and the file was one char less than normal.
>It is only a problem when trying to cleanup partial records (Control Characters) appended to the end of the file.
>
>>Oh you're talking about the old FEOF marker (Ctrl+Z). It doesn't have any use and not available on all tables (and I really don't have an idea under what circumstances it's added).
>>Cetin
>>
>>>Hi,
>>>After the first record is saved a CHR(26) character is positioned at the end of the file, is stays there untill a PACK is issued.
>>>
>>>If you append another record it is replaced.
>>>
>>>
>>>>>Hi,
>>>>>Is there any reason why PACK doesn't replace the EOF marker on a DBF.
>>>>>
>>>>>Is it that way by design or is it a bug.?
>>>>
>>>>What do you mean? There is not such a marker. It's a virtual calculated marker.
>>>>Cetin
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only