>>
The macro substitution is a standard way to build dynamical queries because VFP doesn't offer any other alternatives.>>
>>What methods do other development platforms offer that are more robust than VFP with or without macros?
>>
>
>MS SQL Server T-SQL doesn't have macro substitution but it offers EXECUTE command and sp_excutesql system stored procedure to execute dynamic SQL. VFP could have EXECUTESQL() function wich would eliminate need for macro substitution in this case.
If MS ever adds a front end to SQL, it would probably be FoxPro - I don't consider SQL a development platform. To me - but I'm a hillbilly - it's just a back end!
Would we notice the 1 or 2 nano seconds gained if VFP had an EXECUTE function?<g>
Terry
Imagination is more important than knowledge