SQL toolkit variant problems

[atk_nut]

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.

Download File:post-1336-1112914459.vi

[atk_nut]

Ok.

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

See attached.

Download File:post-1336-1113948711.vi