Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uniqueness of SYS(2015)
Message
From
25/06/2007 20:14:29
 
 
To
25/06/2007 08:15:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01235219
Message ID:
01235515
Views:
14
Cetin,

What sort of problems/headaches have you encountered with integers? What I really store in my primary key fields are the integers returned by a GetLastNumber() routine then converted to zero padded character strings.

Would'nt the use of GUID values as primary key values eat up a lot of disk space? That's already a 36 character field.

Thanks!

Dennis






>
>Dennis,
>I had a very simple demonstration code showing you can easily duplicate with 2 stations:) Believe me you can even duplicate doing that manually (programmatically easier to insert faster) sitting 2 persons on same table and inserting with say Ctrl+Y (where default is sys(2015)).
>GetLastNumber is returning integer I think. So I'd repeat, use GUID. Or start with integer, when you start to have headaches, revert to using GUID:)
>Cetin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform