>I'm actually using a vfp table via vfpoledb. So the record never gets removed. What is the default for "set deleted" during a web app?
SET DELETED is OFF by default.

You can add DELETED=True option to your vfpoledb connection string to change this behaviour.

For example:

Provider=VFPOLEDB.1;Data Source=northwind.dbc;Password="";Collating Sequence=MACHINE;DELETED=True