Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Synchronize Databases pref. in FPD25
Message
 
To
23/05/2002 02:17:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00658516
Message ID:
00660286
Views:
8
Thanks Wally for responding

I have disabled the pack procedure manual and automatic and also reuse of deleted records for performance purpose.

I already have enough files and non-tech people handle computers here and they can really mess around thus I was reluctant to have more files, as it is I have many to maintain.

>Bhavbhuti,
>
>It is a programming problem, you're on the right track to solve it.
>
>I'm sure you know this, but let me review briefly some things. When a record is deleted it is not really deleted, it is only marked for deletion, it is not deleted until the PACK command does that in maintenance operation. So, these records that you're feeding into the central computer may not be deleted. If you issue 'SET DELETED OFF', then you can see the 'deleted' records. You can even work with them in your programming. You can RECALL them to undelete them. So, if your users can refrain from doing the maintenance procedure that issues the PACK command until after they export info on the floppy to the main computer, then you've got those records all along, just need to analyze them in code. This might be least expensive means for you.
>
>Another alternative might be to modify on those various source machines that feed data to the big main computer so that every time a user deletes a record that it is first copied into a 2'nd and identical table that simply lists the records deleted. This would be a better solution because it wouldn't risk that the users would get rid of the record by doing that maintenance procedure that has the PACK in it.
>
>Hope this helps.
>
>Wally Noll
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform