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 ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only