Hi Andy , just fowarding you a old mail from Howie on this subject.
However this is not a complete solution because the records are still in the
DB , but just are not being shown. AFAIK you cannot issue a "pack" from
ODBC...
Let me know if you solve the pack issue !!!
Hope this helps Justin
----- Original Message -----
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 19, 2000 3:21 PM
Subject: Re: foxpro deletes
> 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
>
You said :
----- Original Message -----
From: "Andy Ewings" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 18, 2000 2:54 PM
Subject: CF and Fox Pro
> Ok I hate Fox Pro as much as the next person but unfortunately I have to
> make some changes to a site that is driven by fowpro databases and I'm
> getting a problem....
>
> The client has a Remote Management System which maintains the data in
these
> FP tables that drives their site. He is trying to delete a record from a
> table but there is some logic in the CF pages that won't let him delete
the
> record if there are any related records in another table (which there are
in
> this case). So.....he does the natural thing and deletes all of the
related
> records in the other table (through his CF RMS) and then goes back to
delete
> this original record. However the Fox Pro database thinks these related
> records are still there as the PACK command has not been issued. As I
> understand it the records are not permanently deleted until the pack
command
> is issued. Iv'e tried adding this command to the sql statement in the CF
> page that deletes these records but I get an ODBC error......anyone have a
> quick easy solution to this
>
> Andy
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> ------------------------------------------------------------------
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.