Hi everybody,

I am stil working on this strange behiavour in comm betwen SQL2,2000 and
VFP 7. Problem must be in select statement in Stored procedure. If RowCount is 0, strange message "Comunication error ocure". If I change logic and raiserror after select which return one or more record VFP receive raised error?

Example


* (field) in Table exist

CREATE PROCEDURE up_Check @field nvarchar(7)
AS

Select * from dbo.Table where X = @field

PRINT "Error"
Raiserror ("",16,1)
RETURN

* This works fine. VFP will get message "ERROR"


* in thi example (field) does no exist
CREATE PROCEDURE up_Check @field nvarchar(7)
AS

Select * from dbo.Table where X = @field

IF @@RowCount = 0
BEGIN
PRINT "Error"
Raiserror ("",16,1)
END
* This will return to VFP error "Conectivity error..."

Problem is when SELECT returns 0 rows. IN Query analyzer message OK in VFP not ?