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/[email protected]/
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.
