Sergey,
Thanks again. Steve Gibson had suggested something similar, so I will continue working on it.
>Ha David,
>
>That's why I sad "the closest ....". :)
>You can get what you want if you issue this command at the beginning of the app where there are no tables open or use code below.
oMA = CREATEOBJECT("MaxArea")
>Select( Select(1))
>? Select()
>USE prod
>? Select(1), oMA.GetMaxArea()
>RETURN
>
>DEFINE CLASS MaxArea AS Session
>FUNCTION GetMaxArea()
>RETURN Select(1)
>ENDFUNC
>ENDDEFINE
>
>>Sergey,
>>
>>Thanks. Yes I know of that one, but if say:
>>
>>select 255
>>use mytable
>>
>>Then select(1) will return 254, when really I want 255, or whatever the max value really is. So, it sounds like what I'm looking for doesn't exist.
>>
>>
>>
>>
>>>The closest one is SELECT(1) that returns the highest-numbered unused work area.
>>>