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.
>>
--sb--