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
Timothy Bryan