>In FoxPro 6 when I run a delete sql statement it only marks the records for deletion. How can I code it to delete the records right away?
>
>BTW: this is a Visual FoxPro 6 problem...

Hi John,

This isn't just a VFP6 problem. This behavior is in all versions of FoxPro.

I'm concerned about why you think you need to delete records "right away." This is not a viable option in a multi user system. Most people who want to deleted records immediately are wanting to re-use primary keys, which isn't a good idea.

If you're re-using primary keys and are still developing your application, now is the time to re-think your design.