🚀 go-pugleaf

>The question I now have is why do you say SQL with .DBF is not
>recommended when the SQL designer is the same one that would be used to
>create the DMD?

The sql property of a query against a DBF should most often be nothing more
than:

  "select * from THETABLE"

This is essentially what's generated if you drag a DBF from the navigator to
the DMD design surface. The query designer is unnecessary and undesirable
for use with most queries against DBFs. OTOH, it can be useful for creating
joins of DBFs and queries against C/S tables.
__
Bowen Moursund (TeamB)
bowen at nerds dot com
http://lonestar.texas.net/~moursund/
Try this help resource:
http://www.dejanews.com/home_ps.shtml