>Hello Everyone
>When I try to delete records in a vfp table using ado in an ASP page, the records are not removed. Instead the records become marked for deletion but are not actually deleted.
>If anybody knows how to actually delete the records or if it is not possible please reply.
>
>-Inigo
You need to run the PACK command to remove deleted records.
and if you call SET DELETED ON it will ignore any records marked as deleted in the table when doing queries and the like.
Another option if these dont work for you, this might.
SELECT * FROM MyTable WHERE ! DELETED()
I havnt done much ADO connections to VFP, so just have to see what works for you.