Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Anyone written code to replace SYS(2015)?
Message
 
To
27/09/2006 09:39:54
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01157093
Message ID:
01157579
Views:
24
Hello again, Cetin. Good to hear from you again.

>It's not needed. sys(2015) is guaranteed to be unique even if called
>within same millisecond. However result is not unique in a multiuser
>environment.

Multi-user. That's the complication we're having, although I do
believe it should be possible to still use SYS(2015) and have
things backward compatible on the MySQL database.

Now add on top of that:

1) A lot of clients with their own local database generating
there own "unique" keys based on their own system clock.

2) Each individual client database will be merged into a single
database, and everything has to be unique for things to work
properly.

3) There are many relationships based on these unique
keys.

All this makes for some long-term thinking and hair pulling
before you even write a single line of code :^).

Later,

Randall
--
Randall Jouett
Amateur/Ham Radio: AB5NI
I eat spaghetti code out of a bit bucket while sitting at a hash table! Someone
asked me if I needed salt, and I said, "I'm not into encryption." :^)
Previous
Reply
Map
View

Click here to load this message in the networking platform