🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.programmer
Article #1506

DBKit - How to force "select for update"?

#1506
From: Mike Bray
Date: Thu, 15 Oct 1992 03:39
19 lines
1267 bytes
After playing around with DBKit, I have discovered that it does a 
simple select to fill a DBRecordList, for example, to display in 
a DBTableView.  If you make changes to the data, it is made to the 
RecordList.  Sending the DBModule a "saveChanges" messages causes
the kit to do a "select for update" on the affected rows, and then
the SQL update or delete as appropriate.

The behavior I want in my user interface is different.  I want to 
do a simple read to display data, but then be able to press a 
button labeled "edit", which re-reads the data using a select for update
clause, so the rows affected are locked until I update the data or 
cancel the edit.

The question is, how can I do this without having to resort to
using a DBBinder and my own associations, etc.

Thanks for any and all help!

Mike Bray  mrb@earth.wustl.edu
Technical Details
Message-ID: <1992Oct15.033914.13845@wuecl.wustl.edu>
Path: arc1-ca.pugleaf.net!sparky!uunet!usc!wupost!eclnews!usenet

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.next.programmer
Path: arc1-ca.pugleaf.net!sparky!uunet!usc!wupost!eclnews!usenet
From: mrb@earth.wustl.edu (Mike Bray)
Subject: DBKit - How to force "select for update"?
Message-ID: <1992Oct15.033914.13845@wuecl.wustl.edu>
Sender: usenet@wuecl.wustl.edu (Usenet Administrator)
Nntp-Posting-Host: earth
Organization: Washington University, St. Louis MO
Date: Thu, 15 Oct 1992 03:39:14 GMT
Lines: 19