Entering large data stream to Database

[tst]

Excellent!

P.S. Are you coming to NIWeek?

[mikeporter]

Unfortunately not.  Can't put the finances together this year

Mike...

[kkronline]

Mike,

please send the VIs for LV7.1.

Thanks in advance.

Karthik

[tst]

---

@kkronline wrote:

Mike,

please send the VIs for LV7.1.

---

Look at post #10 and then give Mike a lot of stars.

[Pablop]

Hey Mike (or any interested users out there!)

I'm banging away on my main application and have made use of your DB tools, mostly just the basic ones. They work great. But I was wondering about your advice on writing a large amount of data into the DB. It goes something like this:

1) The operator hits the test buttons
2) 80 unique pieces of data are generated, mostly numeric, a few boolean, some string. My program shoves them all into a cluster (with clsuters in it) and passes it to a Write DB VI.
3) I want all of these items to be entered in a single DB row. Date/Time Stamp, Part Number, Serial Number and then all of the other stuff

Seems like the only way I know how to accomplish this is to write an enormous INSERT statement explicitly using the name of each field and then use the Execute SQL VI. Is that about it for options?

[tst]

You can try doing something like the attached VI (I believe this is based on code originally written by Jean-Pierre Drolet), but you should note that this is not tested code, it was just a quick example.

You will need the OpenG data tools package to do the variant cluster parsing.

[Pablop]

I'm not able to open the file, I must not have the correct tool set.

[tst]

Follow the instructions at the link and then download the data tools package (you will also need the string package).

If you want another approach, you can try modifying Ben's example here.

[m_min]

Mike,

Your database drivers are totally awesome... Thanks so much for your contribution..

Regards,
min

[msimpson]

I may be to late, but can you backsave these to v 6i?  They'd help me out quite alot.

Thanks,

Mark