>>Hi,
>>
>>I'm trying to execute a SQL statement that I have generated dynamically. In Access, to execute that SQL statement, I can just use
>> RunSQL lsSQLString
>>
>>and it would run the string that I've built.
>>
>>How do I do that in FoxPro? Is there an equivalent of RunSQL? I can't use ExecSQL because I don't have a back-end. How do I execute SQL strings locally?
>>
>>Thanks. Any help is greatly appreciated.
>>
>>Anthony
>
>If you mean Pass-Through statement for SQL Server, you should use SqlExec function.
>If you just want to run some command (SELECT,DELETE,INSERT, etc) in Fox itself and you generated some string already, you can use Macro &:
> cString="Select .... From... Where..."
> &cString

also in VFP5.0
you can use the DOCMD() method

Arnon