Hi Tim,
well you understood it enough to solve the problem! Thank you very much, that did the trick.

-Larry

>Hi Larry,
>
>I am not sure I completely followed your question but is this what you are looking for?
>
>In your ABusinessObject
>this.RetrieveAutoIncrementPK = false;
>I think this was intended for integers, but if it is set to true, maybe it is the problem.
>Just a guess really.
>Tim
>
>>Hi Kevin,
>>
>>I have a form with a mmDataGrid. HookSetDefaultValues adds my primary key (a GUID) for new rows, all fine and the new guid shows in the grid. When I save the row, the row is saved, including the new guid, however then the column for that pk is cleared.
>>This doesn't happen when I switch to stored procedures, which is what I've been using up to now. I've repeated this test for several tables, same problem. (stored procedures causes a long 20 to 300 second delay when saving)
>>
>>I'm guessing by default the save is expecting to return a new pk from the backend database, however the sql server isn't generating the keys the code is. I've looked (and looked and looked) however I cannot find a flag/switch for this behaviour, though I'm sure I read it somewhere. Is there a switch I can turn off so it isn't expecting the new pk back from the sql server?
>>
>>Any suggestions?
>>
>>thanks,
>>Larry