Hello John,
Keep in mind that although Howie's advice may suffice because the deleted
records will not appear, they will still be present in the data table. The
FoxPro "Pack" command performs the following which of course can be
replicated: Copy to FileName for Not Deleted(), Rename OldFile, Rename
Newfile. Of course you would be advised to verify that the copy was
successful.
Regards,
Paige
----- Original Message -----
From: John Featherstone <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 19, 2000 9:05 AM
Subject: foxpro deletes
> I would appreciate help in deleting records from a Foxpro table. When you
> issue the 'delete' command via CF/odbc, this merely marks the record for
> deletion. to actually delete the record, Foxpro requires the 'PACK'
command.
> If this is not done, CF will continue to display those records marked for
> deletion. How do I permanently remove records from the table via CF/odbc?
> Thanks in advance
>
> John Featherstone
> LEADS Corporation
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.