How do I a smallint SQL database value using the Database tools?

[jim006]

I'm using the Database Toolset with Labview 7. I'm building up a parameterized Query to a Stored Procedure in my SQL Database. It doesn't appear that smallint output types are supported because zero is always loaded into the variable.

Is this correct? I'm I doing something wrong?

Feedback welcome... thanks!

[mikeporter]

It's probibly not an issue with datatypes since LV has far more datatypes than most databases. What exactly are you trying to do? Are you getting the 0 when running the stored procedure? Could you perhaps post a bit of code (LV and SQL) that demonstrates the issue?

Mike...