>We made an application recently that contains a feature to run code snippets from memo fields of table. From this experiense I can say following:
> 1. There are no way to run such code correctly except putting it into procedure file, compile it and use by 'SET PROCEDURE'. COMPILE command does not require SP3 at the client computer, as far as I know, just make EXE file at the version with SP3.
It does require SP3 if you legally install the runtiume, rather than installing the development engine on each target system. You must have a licensed copy of VFP per system to install the development version of VFP on each target system.
> 2. Compiling by 'SET PROCEDURE' in VFP 6 EXE file does not works - shows error 'file MyProcedures.prg does not exist' even when you specify exact path. Looks like VFP search EXE project file information for 'MyProcedures.fxp' instead of compiling of file on disk.
If you have the development version installed, and issue SET DEVELOPMENT ON, it will compile on the fly.
> 3. You may also run VFP COM object and use 'DoCmd' method to compile PRG in run-time. This REQUIRE SP3 for VFP 6 at client computer, as far as I know.
No, this requirees the full development version to be installed on the system. The FoxServer engine is part of the development engine; to have COM services under the runtime, you have to write and compile a COM .DLL or .EXE and install it under the runtime, and in order to compile under the runtime, SP3 or SP4 must be installed.