Stored Procedure

[Jagjit]

Hi

I have stored procedure for insert . I want if record is successfully inserted or not it should display message in form.

Thanks

[szlamany]

You would need to show us the code you are using for working with the SPROC from VB.

[TysonLPrice]

What DBMS you are using maybe helpful also

[Jagjit]

Hi

I am using Sql Server 2008

Thanks

[TysonLPrice]

Could you show us your code? There are a number of ways to call SPROCs. We need to see what you are doing. The answer depends on that.

[szlamany]

@Jagjit - you've been a member her since 2011 and you have 324 posts. You are obviously not new to the forum!

Did you not see my post - #2? Why did you ignore it?

Now we are up to 5 posts - and you have Tyson asking for the same thing I asked for in post #2.

If I show you code to do this - and it doesn't match the methods you already have in place, then I am wasting my time and I am wasting your time.

[Jagjit]

Dear szlamany

O.k don't waste your time . i will send you the code

Thanks

[szlamany]

Well - that makes no sense - I guess I'll let others assist you. Have a good day!

[gibra]

If you use a Command, as it should be, the Execute method returns the number of affected records:
I.e. when insert a new record value of lngRecordsAffected = 1:

    Dim lngRecordsAffected As Long
    With cmd
        .ActiveConnection = CN
        .CommandType = adCmdStoredProc
        .CommandText = sql_string
        ' add your parameters
        .Execute lngRecordsAffected
    End With

Otherwise you may to use a Output parameter (but Access database doesn't support it)