MS Access data types vs. LabView

[dacad]

Working to add data to a database and am running into issues with two data types.

Can these data types [below] be inserted into an Access table with the standard  DB Tools Insert Data vi ?

First is the Data/Time data type.  While I found a work around for this, I would still like to find out for future reference.

Second is the Boolean data type.  After rooting under the hood of the Insert Data vi, it appears it parses this field from a Boolean to a String.  Is there a simple way of inserting this and maintaining the Boolean data type (Equivelant to MS Access Yes/No or True/False)

Thanks

Doug

[mishkin]

Hey Doug,

Boolean and currency data types are not directly supported by the LabVIEW Database Connectivity Toolset. You can read/write these datatypes as strings, but there's no direct way to do it currently. More info here:  Using Boolean and Currency Data Types with the LabVIEW Database Connectivity Toolset

Cheers,

[dacad]

That is what I thought though it didn't really seem conclusive from what I read in the Database Conectivity Toolset User Manual.

I ended up with strings and can work with that welll enough.

Thanks

Doug

[Dennis_Knutson]

You can work with whatever types you want if you use the Execute SQL Query and not depend on just the top level functions. Search the net for a SQL tutorial and go from there.

[dacad]

If I get some time, I'll dig deper into that.  Right now, I have a project that needs to be delievered and using strings will provide the funtionality that I need.

 Thanks for the feedback though.  Always useful to know what might be possible for upgrades and future work.

Doug