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 = ""
>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?