Hi Mike,
They might complain about keys being 4 or 8 times as large as integers too. :-) That's the tradeoff. One trip to get the key, or use really big keys.
If you store keys as binary, length 16, those keys don't work in comboboxes, which is a pain.
>Hi Borislav
>
>You realize you're hitting the backend/table 3 times? Once to grab the record, once to send the update and once to grab the new ID?
>
>That's the kind of thing DBAs complain about.
>
>By using GUID there are no extra round trips required to get new ids.
Charlie