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?