|
Ooops. yeah, grouped. Order it descending and get the first. =========================================================== R. Bruce Hoffman, Jr. -- IBM Certified Specialist - AS/400 Administrator -- IBM Certified Specialist - RPG IV Developer "America is the land that fought for freedom and then began passing laws to get rid of it." - Alfred E. Neuman -----Original Message----- From: Phil Groschwitz <sublime78ska@yahoo.com> To: RPG400-L@midrange.com <RPG400-L@midrange.com> Date: Wednesday, March 14, 2001 5:43 PM Subject: Re: Embedded SQL & commitment control >Bruce, > >Ok, but the problem I run into there is getting the >highest key value. If I use 'max(key)' I can't use >the for update clause and if I use 'order by key desc' >I can't use the for update clause. > >So I'm wondering - is the way I'm trying to do it >unorthodox? > >Phil > > >> >> Yeah, see the row must be selected for Update when >> not using the >> serializable on set transaction. >> >> On the cursor you might try adding the "for update" >> clause to the select in >> the cursor declaration. >> >> >> >=========================================================== >> R. Bruce Hoffman, Jr. >> -- IBM Certified Specialist - AS/400 Administrator >> -- IBM Certified Specialist - RPG IV Developer >> >> "America is the land that fought for freedom and >> then >> began passing laws to get rid of it." >> >> - Alfred E. Neuman >> >> >> >> +--- >> | This is the RPG/400 Mailing List! >> | To submit a new message, send your mail to >> RPG400-L@midrange.com. >> | To subscribe to this list send email to >> RPG400-L-SUB@midrange.com. >> | To unsubscribe from this list send email to >> RPG400-L-UNSUB@midrange.com. >> | Questions should be directed to the list >> owner/operator: david@midrange.com >> +--- > > >__________________________________________________ >Do You Yahoo!? >Yahoo! Auctions - Buy the things you want at great prices. >http://auctions.yahoo.com/ >+--- >| This is the RPG/400 Mailing List! >| To submit a new message, send your mail to RPG400-L@midrange.com. >| To subscribe to this list send email to RPG400-L-SUB@midrange.com. >| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. >| Questions should be directed to the list owner/operator: david@midrange.com >+--- +--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.