An irritating little feature of foxpro. I have two copies; one at work and one at home.
At Home when I create a query, then select a query destination using the browse button, then view the SQL the table location is shown as relative; eg if I want to store table stock.dbf in C:\Stock then the SQL reads "..\..\stock.dbf". Which, when I compile, does cause problems .
At work no problem - the SQL reads "C:\Stock\stock.dbf"
Anybody else experienced this?