DESPERATE Help Needed....

Hello all,

I am a total newbie to SQL. I created this sp and then with C++,
called it. My return value was 100 (which it was)

CREATE PROCEDURE sp_StoreIPs
@IPSource varchar(16),
@IPTarget varchar(16),
@TimeDate varchar(20),
@Name varchar(250)
as
declare @iReturn int
Set @iReturn = 100
return @iReturn
GO

Then when I added a INSERT statement like ...


CREATE PROCEDURE sp_StoreIPs
@IPSource varchar(16),
@IPTarget varchar(16),
@TimeDate varchar(20),
@Name varchar(250)
as
declare @iReturn int
Insert into LookUP (IPSource, IPTarget,TimeDate, Name) Values
(@IPSource,@IPTarget,@TimeDate,@Name)
Set @iReturn = 100
return @iReturn
GO


My return value was 0. I am assuming the the INSERT statement is
returning the 0 but how can I get around this?


Thanks
Ralph Krausse
www.consiliumsoft.com
Use the START button? Then you need CSFastRunII...
A new kind of application launcher integrated in the taskbar!
ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg