variable in DCT and SQLserver

[Pierre_F]

hi

One of my programs is checking in a SQLServer database, a recordset containing a lot of double lines to remove.

in order to avoid to do the parsing in my LabView code,  I began to try to remove them directly by SQLserver request. this request contains table variables. unfortunately, the recordset is returning zero values (wherehas it works in SQLserver directly OR from labview without variables)

I realized by creating the little code I send you joined (LV2015) that the SQL variable are simply not recognized when using the DCT.

is there a solution to make them useable? did I lose my time by working with something not compatible?

thanks in advance for your help

[caillotantoine]

Hello Pierre_F, 

I do not really understand what you are eager to do. You just want to read varable from an SQL database?

What do you mean by DCT? 

Best reagards,

Caillot Antoine