Thanks in advance for your forebearance of my ignorance. I have many years of SQL experience(sybase,oracle,mysql,sql/ds,etc), but am new to foxpro.
I can't seem to grasp the notion of work area. Inside my application code, I can use the "select 0" and "use (table name)" commands to gain access to a table, but there are other parts my application where I have not done this, and can still do "select * from (table name) into (some other table name) where (constraints)". My application is intended to run on a client platform, where tables are stored on a network-connected data server. Can someone please explain the bindings(or whatever) that happens during compiletime and runtime that "select (work area)/use (table name)" controls?
Or why these explicit commands are apparently not always necessary?
Many thanks, PC