Q: Is there a way to keep the Visual dBASE 7 designer from overwriting absolute paths with relative paths? For example, the code:
sql = "SELECT * FROM 'X:\DATA\TEST.DBF'"
is changed to:
sql = "SELECT * FROM '..\..\DATA\TEST.DBF'"
after using the designer.
A: Use database aliases, then
you won't be bitten by that ever.