Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GENDBC and Incremental fields
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00964753
Message ID:
00964993
Vues:
8
Here what I am doing when i uodating some of my clients. I keep in different place an empty database with empty tables. When I need to change some fields in tables I do it there & after that I am updating my development DB. ALL Incrementa fields are normaly Interger fields (not autoinc). During update I APPEND FROM table & right after that & Do:
USE NewTableWithoutIncFields EXCLUSIVE && To make sure that nobody has access to that table
ALTER TABLE NewTableWithoutIncFields ALTER COLUMN AutoIncField
SELECT NewTableWithoutIncFields
SET ORDER TO ThatFileldThatIsAutoInc
GO BOTTOM
next_key = AutoIncField+1
ALTER TABLE NewTableWithoutIncFields ALTER COLUMN AutoIncField I AUTOINC NEXTVALUE next_key
USE
ERASE NewTableWithoutIncFields.BAK
* ERASE NewTableWithoutIncFields.TBK  If table has MEMO field
*COPY or whatever You want to do with it
>I send an upgrade that include .exe file and a programa that execute Gendbc from a forder, it create an exactly copy of the database and table structures that I have and make a APPEND FROM, replacing old tables with new ones. Everything have been working fine until I decided to use AutoIncremental fields.
>
>
>
>>I do such things too. But sorry I can't see how GenDbc gets into play on remote site. Wouldn't you use gendbc at deveoper side?
>>Cetin
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform