I wonder if it's the PRINT. The results of PRINTs come back to the client as informational entries. What happens if you remove it?
-Mike
>Hi everybody,
>
>I am having a problem with receiving results from SQL 7.
>
>
>On SQL server I have foloving stored proc:
>
>CREATE PROCEDURE validateEntry @field nvarchar(7)
>AS
>
>Select * from Table where x = @Field
>
>IF @@RowCount = 0
>BEGIN
> PRINT('Error, Entry does not exist')
> Raiserror ('Error, Entry does not exist', 16,1)
>END
>
>I cal this stored proc. FROM VFP6 via SPT:
>
>a = SQLEXEC(gnHandle,"validateEntry '12' ")
>if a = -1
> AERROR(aSQLError)
> IF aSQLError[1] = 1526
> MESSAGEBOX(aSQLError[2],"Error")
> ENDIF
>endif
>
>Problem is that I get in array instead message from Stored procedure
>message:
>
>Conectivity error. Unable to retrieve specific error information
>Driver is probably out of resurces.
>
>If I cal procedure with entry which exists, everything is OK
>
>Thanks in advance,
>
>Toni