dbtools fetch element data

[dave_helmut]

Hi,

I am calling a Stored Procedure from a MS-SQL 2005 database, and it returns 2 dozen fields.  I need to bundle the result data into a cluster for my customer.

His cluster contains Booleans, Strings, and I32s, and DBLs.

 

I need to do the same, but my data is coming frmo the "dbtools fetch element data" function.  Problem is, I can't seem to get the output variant data to convert to the native data types in order for the bundle function to match the customer's original Cluster.

Can someone point me to a LV function code example to do this?  I've tried using "Database Variant To Data", but I haven't found the magic way to make it so the bundle function sees a native data type.  

LV Help and this forums aren't telling me what I need to know.

Any help greatly appreciated!

Dave 

[dave_helmut]

After more digging, I found this link: http://zone.ni.com/devzone/cda/tut/p/id/4998

Which I think showed me what I need.  Here is what I did, does this seem right?  I just input a Boolean Constant to the Variant to Data function, and the output will be what the database gives me?  Seems like this should work...

 

[dave_helmut · Accepted solution]

OK perhaps the "Database Variant to Data" is more appropriate?