You need to make a setting in your ODBC config for this. For some strange
reason, the ODBC Driver defaults to showing deleted records. To fix this:
Open up Control Panel/ODBC (you can't do this through the CF Administrator
AFAIK)
Highlight the datasource and click on Configure
Click on Options
Uncheck the box that says Show Deleted Rows
HTH,
Howie
----- 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.
