But it's returning 0 on the one that actually works.

1 on the one where, according to the SP trace, no call is even being made to the SP.



>It's strange,
>
>ms1=0 indicate command execution (Asynchronous execution=.T.) but connection settings in picture say AE=.F.
>
>You can fix it:
>

>DO WHILE ms1=0
>  ms1 = sqlexec(mconn,"" )
>ENDDO
>

>
>MartinaJ
>
>>I've got a stored procedure in SQL that is working for every other record that I'm trying to move from VFP.
>>
>>I build my sql statement and my call to the SP is
>>
>>

>>sele MasterFile
>>** set up parameters
>>
>>m.ErrMsg = ""   && this is an OUTPUT Parameter to return any error message from the SP
>>ms1 = sqlexec(mconn, 'exec dbo.InsMaster <<Parameter List>>)
>>if !empty(m.ErrMsg)
>>  **show error in messagebox
>>endif
>>errcnt = AERROR(mErrArr)
>>if errcnt > 0
>>  ** display Aerror msg in messagebox
>>endif
>>
>>rele all like mErrArr
>>

>>
>>The first call works and ms1 = 0
>>The second call does not work and ms1 = 1
>>
>>m.ErrMsg is empty
>>AERROR does not generate anything.
>>
>>Attached is a screenshot of my connection
>>
>>Anything look out of place? Any suggestions?