🚀 go-pugleaf

Lawrence,

First off, avoid using PUBLIC variables in your VdB programs. It is
especially unnecessary in VdB 7.01. If you really really need to have
something that is "public", you can assign a custom property to the
_app, such as _app.myPublicThing="Hello, world!"

To answer your questions, you do not need to use macros. The .sql
property is a string. Using your examples, you could do this:

" select  * from [&mpath]\itemf.dbf"

would become:

" select  * from " + mpath + "\itemf.dbf"

If you think any item in the path will contain spaces, then you will
have to have quotes around the full path name you are creating with
something like this (I have used brackets for clarity):

[ select  * from "] + mpath + [\itemf.dbf"]


--
Geoff Wass
Kuala Lumpur, Malaysia


== In news groups use a reply (not e-mail) so all can help and learn!
==
== Report Inprise/Borland bugs...
== http://www.inprise.com/devsupport/bugs/bug_reports.html
== dBASE Archives http://forumsearch.borland.com:88/
== or http://www.dejanews.com
== Alan Katz's Visual dBASE Magazine http://www.ksoftinc.com/vdb/