LAVA Forums Buy cool LAVA gear Forums RSS Feed

Welcome Guest ( Log In | Register )

> Related links

Check out our Database and File IO Code Repository Files or visit the LabVIEW Wiki Database and File IO articles.


Tags
(This content has not been tagged yet)
 
Reply to this topic Start new topic
> SQL toolkit variant problems, Help!
atk_nut
post Apr 7 2005, 10:54 PM
Post #1


Active
*

Member
Posts: 19
Joined: 7-January 05
Member No.: 1336
LV:7.0
Canada


OK, here's the issue. I'm trying to duplicate a record with the SQL toolkit. In the insert record vi, it takes a cluster of data, converts it to variant, parses the datatypes and inserts the record.

What I want to do, is develop a vi that programmatically inserts a record based on the column info and an array of strings. (In stead of building a cluster to pass to the vi.) The problem is, how do you "build" a cluster variant from an array of strings.

I have attached a vi that illustrates the problem. The goal: Make variant2 look like variant1!

Any help would be appreciated.
Attached File(s)
Attached File  convert_variant.vi ( 41.01K ) Number of downloads: 164
 


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post
Ad
post Apr 7 2005, 10:54 PM
Post #















Tags
(This content has not been tagged yet)
Go to the top of the page
Quote Post
atk_nut
post Apr 19 2005, 10:11 PM
Post #2


Active
*

Member
Posts: 19
Joined: 7-January 05
Member No.: 1336
LV:7.0
Canada


Ok.

It turns out it was simpler than I thought (If you have OpenG installed.)

See attached.
Attached File(s)
Attached File  convert_variant.vi ( 41.69K ) Number of downloads: 194
 


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post

Reply to this topicStart new topic

 




Time is now: 2nd December 2008 - 12:26 AM