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 move this post to Developer Forum. Kindly don't duplicate posts. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Follow as suggested and further discussionhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4758 here. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.