MB Software Solutions General Account wrote: > How are you handling the generation of the primary keys? Are you using > GUIDs? I can't see this scenario working any other way without great > complexity in sync code.
Yeah, I'm using GUIDs. But I must also write code to check for 'similar' records which could be redundant data entry. Then there's the issue of order numbers, and the like. For those, when 'offline', they don't get the actual number, they get something like 'temp_0001'. When online, the main db server will dish out a proper number. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

