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:ed@leafe.com]

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: ProFox@leafe.com

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.