Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing a DBC
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00302465
Message ID:
00302485
Vues:
26
>For an installed system on a client's PC, I need to change the DBC. I changed a local view. Can I just copy the new DBC & DCT and the data tables will be o.k.? Or do I have to backup the data and then append it back to blank tables?
>

It'd be better to send out the necessary alterations as a short program, doing the needed ALTER TABLE, CREATE SQL VIEW and the like on site, so that any other changes made at the site are retained.

You might want to considering using Stonefield's SDT product - it handles changes to DBCs, tables, indexes and the like by maintaining a separate set of tables containing metadata that can be used to create, repair and update systems in the field. It also provides very robust mechanisms that replace the somewhat risky PACK and REINDEX commands, and some rudimentary file repair tools as well. It's saved me countless hours of time; while I might've been able to develop most of the functionality in SDT, it would've cost far more in time and effort, and Stonefield's support has been outstanding. It now handles free tables as well as things in the VFP DBC, making even more valuable. You can distribute the necessary runtime functionality with your source code on a royalty-free basis, and Stonefield gives a discount to PUTM members.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform