Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GENDBC and Incremental fields
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00964753
Message ID:
00964993
Views:
9
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform