Paul McNett wrote: > 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.
So how wide are your character key fields? _______________________________________________ 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.
