>> I have these table that access in buffering mode. How do i delete the
>> record when I am still in the buffering mode ?
>
>like you do in non-buffering mode using DELETE (or DELETE SQL)
>if you have table buffering - it will go into the buffer and will be
>commited upon tableupdate
>
>Arnon
>
>Can i use PACK command to
>> phisically delete the record ?
>you have to use the table with no buffering and open it exclusively
>
>there is no need to PACK after each delete..
If you do not pack after deletions and have "SET DELETE ON" in your application, to improve query response you need to make sure that you have an index tag on DELETED(). I have found that for very large database files, query response it greatly improved if I leave SET DELETED OFF, use a character(1) field, named ISDELETED, to mark my deleted records with 'D' for example, add an index tag on ISDELETED#"D", and use the additional clause ...and ISDELETED#"D" in my queries. When a record is "DELETED", only the ISDELETED flag is actually changed, the record is, in fact, not deleted.
Once you get used to testing for deleted this way, it is not much different than testing for DELETED() vs ISDELETED="D". I think that you will find it more flexible and actually safer in the long run.
Anyone have any pro or con comments?
Larry