Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Download tables which are part of DataBase
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00658400
Message ID:
00658434
Views:
13
>>Hi everybody,
>>
>>I'm working on DataEntry application at this moment. One of the regimes is "Download new version of Lookup tables". These tables are part of Lookups database and only few really change.
>>
>>So, somebody will put these two or free tables in Download directory of DataEntry. These tables have a link to a DataBase. I guess, I can not just copy tables from this directory to Lookups directory, because I would have problems with links.
>>
>>One solution would be to open old table exclusively, zap and append from the new (if I would be able to open it without its Database). I'm wondering, is there another "back door" way? Fixing database on the fly (with low-level functions)?
>>
>>Appreciate your guidance.
>
>Hi Nadya,
>
>You might try to open both tables, SCAN through the new source table and go through the target table completely replacing the records one-by-one with SCATTER/GATHER. New lookup tables typically contain more records, however if the target table will have more records than the new source you may just delete the rest.
>This way you will reuse the existing amount of records.

Hi Nick,

I've ran a test. I just copied file from one place to another and was able to open table just fine. May be I was incorrect in my original assumption, that it should not work this way... I'll run more tests on Monday to be sure, that simple copy works...

BTW, did you talk with Michel about the problem, we discovered yesterday with Account Setup?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform