>Hi All,
>I have a problem when calling SQL server scalar function from VFP9.
>If I use the following syntax :
>
>

>lcReturnValue='     '
>lcParametersIn=['A','B','C']
>lcComamnd=[EXEC ?@lcReturnValue=dbo.MyFunctionMane ]+lcParametersIn
>lRet=SQLEXEC(nHandle,lcCommand)
>

>
>I expect lRet=1 and lcReturnValue=whatever my function returns
>This works on my machine when I run against SQL server 2005 and 2008 back end, but on my laptop and my coworkers computers it fails, with "...syntax error around '=' "
>
>The following will work on any machine.
>
>

>lcComamnd=[SELECT dbo.MyFunctionMane(]+lcParametersIn+[)]
>lRet=SQLEXEC(nHandle,lcCommand)
>SELECT SqlResult
>

>
>For testing purposes I created a simple function that imitates PADL() in VFP.
>In SQL Server
>
>

>IF OBJECT_ID(N'dbo.PADL', N'FN') IS NOT NULL
>    DROP FUNCTION dbo.PADL;
>GO
>CREATE Function [dbo].[PADL] (@_String nvarchar(255),@_Len int=10,@_PadChar char(1)='0')
>        Returns nvarchar(255)
>        BEGIN
>			SET @_String=REPLICATE(@_PadChar, case when @_Len>=len(LTRIM(RTRIM(@_String))) then @_Len-len(LTRIM(RTRIM(@_String))) else 0 end ) + LTRIM(RTRIM(@_String))
>		    RETURN @_String
>        END 
>

>
>IN VFP I make a call to this function
>
>

>pcReturn=' '
>lcCommand=[EXEC ?@pcReturn=dbo.PADL '123',10,'0']
>lnreturn=SQLEXEC(nHandle,lcCommand)   && on my computer return 1, on my laptop returns -1
>?pcReturn   && on my computer returns '0000000123'
>
>lcCommand=[SELECT dbo.Padl('123',10,'0')]
>lnreturn=SQLEXEC(nHandle,lcCommand)
>SELECT SqlResult
>BROWSE      && works on both computers
>

>
>Is there some kind of settings on the server that I am missing.
>Any suggestions please.
>
>Thank you in advance
>
>Yelena

IMHO, only select syntax should work. Or you should declare the variable first, say,

declare pcReturn varchar(100)

pcReturn = dbo.myFunc(params)