hello: i have this huge problem. it's killing me.i have this store procedure : CREATE PROCEDURE siesta @param1 int AS declare @ne1 varchar(20) declare @text varchar(20) if( select count(*) from tabla3 where campo1=@param1)<1 begin select @ne1=(select campo2 from tabla3 where campo1=@param1) insert into tabla3 values(@param1,@ne1) end else begin print 'already in the table' end GO the procedure insert if it's not there . and if the person is already in the table send a message. the problem is that i want to call the store procedure from visual basic 6.0 but i want to see the PRINT 'already in the table'. how can i do it? i've tried several things but ... . THANK YOU FOR YOUR HELP.
Please don't duplicate post, and this is a Spanish Forum. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.