General information
Category:
The Mere Mortals .NET Framework
Environment versions
Network:
Windows 2003 Server
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only