How do you pass a boolean to the dynamic SQL vis in SQL Toolkit

[JellyBeans]

The way i have done it in the past and this is a workaround is to have text or numeric column hold a value (Yes/No, 0/255) to repersent the boolean.
There is no direct VI for that though.
Hope this would help you.

A Rafiq

[edisler]

Thank you for your answer. This is exactly what I ended up doing.

[Dobedani]

Hi there,

I am a newbee to LabVIEW. I am currently using version 5.0, whilst
waiting (aaaahhhhhhh) for version 6.0 to arrive. I am very curious to
know more about the dynamic SQL VI's. I guess they are part of LabVIEW
version 6.0?

Some time ago, I started an exercise in which I tried to generate an
SQL statement on-the-fly. I felt that getting string values quoted was
such a tedious work. Is there an easy way to do this? TIA

Kind regards,
Dobedani