Hi Daniel,

>I agree with Erik. I've not come accross many situations where I needed macro substitution in VB. We need it in VFP when using commands such as SELECT SQL, REPLACE, etc.
>

Another place I use macro expansion is to restore an ON ERROR setting. That's all I can come up with for now. Most other places eval() handles it.


>It would be nice if we could use SQLEXEC() against local data.

You can use SqlExec() for local data if you connect via ODBC. But I'm not willing to do that.