Dunno. Safest thing is to specify the unfiltered master table in the from clause.
On Thu, Aug 23, 2012 at 9:37 PM, Gary Jeurink <[email protected]> wrote: > A new record would be by an administrator but the view is to update scores > after a football game [shared] by people looking for final scores. In my > view we find colGame rec where hmtm=[NEBR] and vstm=[miss st] and > season=[2012]... THEN UPDATE hmScore=62, vsScore[7] (go huskers). As long > as > I check the right key and the related records to update in the view wizard, > it works. I can here you pro's growl .. learn to write an SQL statement > > Does max[id]+1 work on a filtered list or does it just look at that list? > > Gary > > -----Original Message----- > From: Ed Leafe [mailto:[email protected]] > Sent: Thursday, August 23, 2012 3:12 PM > To: ProFox Email List > Subject: Re: auto increment > > On Aug 23, 2012, at 3:09 PM, Lew Schwartz wrote: > > > Unless speed is of the utmost importance, I've used > > > > select max(idno)+1 as idno from target into cursor nextkey > > > > to get the next value. > > Are all your systems limited to a single user? > > > -- Ed Leafe > > > > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAFuU78fKU=9C8sTJ=4gfe2omoy21p87_jndvn+fcuglbmb9...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
