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.

Reply via email to