Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I update a Database VFP3.0
Message
 
To
10/03/1997 04:12:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00023526
Message ID:
00023660
Views:
26
>>>>I have a new table that I want to send to a client but
>>>>I don't know how to update his database correctly
>>>>the table has new fields in it.
>>>>
>>>>Help
>>>>
>>>>Thanks,
>>>>Greg Heinz
>>>
>>>I did not try this, but I think you can send him the database files and the new table.
>>
>>I have done this, but it is important that your client has not changed the database himself. If so, you may end up scrambling some files. If he doesn't have VFP, you should be safe.
>>
>>I think that Bruce Campbell, our Anonymous Bureaucrat, is trying setting the database files to be read-only. Is there any update on this? If so, then it would simplify this kind of updating, because you would know exactly what was on the clients' machines.
>>
>>Barbara
>
>When you are taking about database files, do you mean *.dbc and/or *.dct?
>
>I have a table wich is a part of a database. The table stores the prices for products. If the prices changes, do I only have to send myTable.dbf and myTable.cdx to the customer?
>
>Thanks in advance

Niklas: DATABASE files are the 'container' files: DBC, DCT, DCX. TABLES are the DBF files, DBF, FPT, CDX. So if you've only changed the prices in MYTABLE.DBF, then just send the MYTABLE files.

If you've changed the file STRUCTURE - added a field, changed a field length, etc. - then you will need to upgrade the DATABASE.

Hope this helps

Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform