>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?
A GUID is universal so it could work in this case. Here's a simple code to create the key:
FUNCTION GetGUID
LOCAL loGUID
loGUID=CREATEOBJECT('Scriptlet.Typelib')
RETURN STREXTRACT(loGUID.GUID,'',CHR(0))