>Eval() is not documented in the DTS package, but it is documented on Microsoft's Script site.
>
>It works just like the VFP EVAL() function. BUT, it is not available in VB. And CallByName does not perform the same function.
>
>It would be good to know if there is a built-in VB fucntion that performs the same function, or, barring that, if someone has written one.
>
Unfortunately, it'll be extremely difficult for VB, a compiled language that generates native code indirectly at compile time (at least at one point, VB's compiler emitted C which then was compiled and linked to produce the native executable; I haven't stayed on tp of the VB6 compiler's inner workings to know if it still does this). Both languages that you mention with asource code resolving EVAL() function like VFP or VBScript's are based on interpreters or incremental compilers that emit p-code. There are some things like runtime resolution of source expressions that interpreters do better than compilers, and you picked the classic example of one of them.
If you can spare the memory in your application, you could access the VFP runtime engine by creating a VFP-baed COM server that accepted a string, performed an EVAL() on it and returned the result in a fashion similar to what VisualFoxPro.Application does with its Eval method.
But then you could probably have written the app in VFP in the first place and saved a lot of time and effort...