>>I have some stored procedures in SQL 2005. Is there a way to run these from VFP? If so, is there a way to pass a parameter to it?
>>
>>Thanks!
>
>Sure:
>

>* 1. passing some constant as a parameter using named parameters
>SQLEXEC(sqlHandler, [EXEC YourSP @SomeParameter1=constant1,@SomeParameter2=constant2])
>
>* 2. passing some constant as a parameter using positional parameters
>SQLEXEC(sqlHandler, [EXEC YourSP constant1,constant2])
>

>These constants can be anything, direct values, or if you build the string before SQLEXEC values from some variables/fields:
>
>

>SQLEXEC(sqlHandler, [EXEC YourSP @SomeParameter1=1,@SomeParameter2='blah blah'])
>
>* 2. passing some constant as a parameter using positional parameters
>SQLEXEC(sqlHandler, [EXEC YourSP 1,'blah blah'])
>
>*** building the string bewfore SQLEXEC and using variables/fields
>TEXT TO lcSQL NOSHOW TEXTMERGE
>     EXEC YourSP <<variable_field1>>,'<<variable_field2>>'
>ENDTEXT
>SQLEXEC(sqlHandler, lcSQL)
>

>
>Of course you could use parameters :-)
>*** building the string bewfore SQLEXEC and using variables/fields
>TEXT TO lcSQL NOSHOW TEXTMERGE
> EXEC YourSP ?variable_field1,?variable_field2
>ENDTEXT
>SQLEXEC(sqlHandler, lcSQL)
>
>By using parameters (that little question mark) you dosn't care about proper type convertion VFP handle this, you are less vulnerable for SQL injections.

Thanks!