Article View: comp.sys.next.programmer
Article #268DBKit: updating key fields
From: & Garrett
Date: Tue, 28 Jul 1992 00:21
Date: Tue, 28 Jul 1992 00:21
21 lines
1562 bytes
1562 bytes
It would appear that one can't update key fields. When I change non-key fields and then save changes, the sybase table is updated correctly. When I try to save changes that include changes for properties marked as key, I get "Error occured during transaction." It would appear, quite simply, that DBKit builds the where clause of the update statement from the current (changed) values of the key fields rather than from their original values. - The key for this particular table is a five field key. If I change my Model to make one of the key properties non-key, I can then update that field (as long as I don't change any of the remaining key fields, so it can still find the original row). - I can even edit _all_ the key fields so that the row has the same key as another row in the table, so that when I try to save I get "al_appt record has been modified in the database since the last fetch." instead. I think that's proof positive. This is a complete disaster. Any ideas? Any knowledge of plans to fix this? Colin Garrett colin@delphi.bsd.uchicago.edu (NeXTMail)
Technical Details
Message-ID:
<1992Jul28.002103.29635@midway.uchicago.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!cis.ohio-state.edu!pacific.mps.ohio-state.edu!linac!uchinews!newsShow Full Headers
Complete Article Headers
Newsgroups: comp.sys.next.programmer Path: arc1-ca.pugleaf.net!sparky!uunet!cis.ohio-state.edu!pacific.mps.ohio-state.edu!linac!uchinews!news From: colin@agincourt.bsd.uchicago.edu (& Garrett) Subject: DBKit: updating key fields Message-ID: <1992Jul28.002103.29635@midway.uchicago.edu> Sender: news@uchinews.uchicago.edu (News System) Organization: University of Chicago Computing Organizations Date: Tue, 28 Jul 1992 00:21:03 GMT Lines: 21