Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GUID as Primary Key
Message
 
To
18/02/2003 12:25:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00754530
Message ID:
00754789
Views:
19
Hi Ken,

I use GUIDs as my PK in almost all my clients' applications. They have the added advantage that, if you end up with a SQL Server backend, you won't need to add a GUID field to the table to enable replication -- you'll already have one.

Cheers,

Andrew

>We have a new client who has remote locations. The situation does not call for a wide area network with "on-line" capability. The client would rather give the branch locations the ability to operate on their own and pass data back and forth periodically.
>
>This raises the issue of merging data and the worry about unique primary keys. I have heard about GUID keys as an alternative but, at the time, did not pay enough attention. Anyone have experience with this?
>
>Thanks,
>
>Ken


If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?


From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."


All my FoxTalk and other articles are available on my web site.


Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
Previous
Reply
Map
View

Click here to load this message in the networking platform