Stored Procedure

[BenBabb]

I am having trouble using stored procedures and need some guidance.  

If I try to run the stored procedure code I get an error saying I am not providing a required input, but from the LabVIEW it looks like I am providing it.

But I keep getting this error.

The database table looks as follows:

@ID is generated in the procedure, it is looked up and inserted.  

I do not have any ability to get into the database myself.  This is a stored procedure writtin by my IT department's DB engineer.  The above image has the required feilds highlighted in yellow that I needed to provide when my code runs.  

Can anyone see where my mistake has been made?

Thanks for the feedback.

Ben

[aputman · Accepted solution]

The procedure isn't going to match up the parameter names with the values you provide.  You only provide 5 params but there are 8 in the stored procedure.  In your case, SerialNumber will be passed into ID, PartNumber into SerialNumber, etc.  Add some blank params in your cluster if they aren't required.

[aputman]

Actually what i said may not be entirely true.  It depends on the definition of the SP itself.  Your picture just shows a list of the parameters but not necessarily in the same order as defined by the SP.

[BenBabb]

Aputman,

Thank you very much.  That is exactly what I needed.  I guess I was confused because my IT Database manager said those values were not required, but LabVIEW must require them.  I put all of the paramaters in and just updated the ones I needed to.  This solved my issues.

Cheers,

Ben

[aputman]

FYI, this is the way that i like to create my parameters.  Hope it helps.