Read data or value from a varaible from dabase

[Rlima]

 Hi  Brian...

 I just got my program to work,  I was on another issue, so I put this one a side, but today I just

 take it back and its working,  I only have one problem,  I have the answer from SQL server. the

 data type is  "variant"  how can I convert to a string type,

 Best Regards.

 Rlima.

[Brian_Beal]

In the database pallette, there is a function to convert the database variant to a different type.  I don't have the toolkit on this machine, so I can't give you the exact name.  Wire your variant to the input, and any string constant to the type input, and it will output a string.  It does not work on arrays, so you will have to index the array to get to the elements you need.

[Rlima]

      Thanks Brian...  

      I have my  vi working now.      Now that is done looks easy,  this is my first challenge

      using  SQL.  

       Thanks Again.

        Rlima.