>>I have a GRID that I have sorted by last name, first name that is contained within a Pageframe. The underlying table is Keyed on Familyid (Seq#). How do I get the maximum number from the Family table without changing the sort order and inserting a new row.
>
>This code doesn't move the record pointer:
>
>SELECT max(familyid) as maxfid;
> FROM FamilyTable ;
> INTO cJunk
>
>lnMaxFid = cJunk.maxfid
>
It's good as long as buffering is off.
Edward Pikman
Independent Consultant