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 _______________________________________________ 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/1F9764A4E4484E989722D8D42B872DF5@OwnerPC ** 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.
