>What is the maximum number of work areas in VFP 8 and VFP 9? SELECT(1) returns 32767, whereas the help for Private data session says - each private data session can have unlimited number of work areas.

According to Work Areas in Data Sessions help topic, "you can open and manipulate tables in 32,767 work areas". See also online http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp9/html/aaabec67-356e-4fa7-b483-d4db878e219f.asp?frame=true

>I tried to look for Technical Specifications in VFP Help, however, could not find it. Its too bad that we don't get printed documentation and searching in online help is not so friendly. (Perhaps Google should step in with search tool for Microsoft help files!) Does any one know where I can find technical details, such as max. fields, max table size, max. work areas, etc.?

See Visual FoxPro System Capacities in help. See also online http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp9/html/6e27027b-806b-4f96-b7e5-5f24af2901e0.asp?frame=true