Hi Mike,

Thanks it works.

I have changed stored procedure to this:

CREATE PROCEDURE up_Check @field nvarchar(7)
AS

DECLARE @DBID INT
SET @DBID = DB_ID()

DECLARE @DBNAME NVARCHAR(128)
SET @DBNAME = DB_NAME()

IF not EXISTS(Select * from dbo.Table where Table.X = @Field)
BEGIN
RAISERROR (50001, 16,1, @DBNAME, @DBID)
END

Return @@RowCount

Now VFP get proper message. It should work also with SELECT and @@Rowcount, but ?


Toni