Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Surrogate Keys - Have I got the right idea
Message
From
12/01/2001 15:36:39
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00434523
Message ID:
00463221
Views:
20
James:

> Actually, there is another solution. The user can generate offline keys using
> integers, and when going back on line, the application database can return a
> header portion of the key (or session portion). With this scenario, the
> client application controls part of the key and database controls the other.
>
> Header: 123 + Client:124578 = 123124578 !

Although your example may not work for large amount of users/data, it's
certainly a good example of the advantages of evaluating a situation instead
of blindly following a principle !

Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform