Database connectivity toolset and nested transaction

[csch]

Is it possible to make nested transactions with the Database Connectivity Toolset ?

By nested transactions I mean that I want to open a transaction inside a transaction.

I use LabVIEW 6.1 and Database Connectivity Toolset 1.1

Any ideas are welcome.

[Ben]

Hi csch,

No, I don't have any ideas to offer, but,
I am curious.

Why do you want to do that?
and
What will it buy you?

Ben

[csch]

Hi Ben,

I want to make measure configuration. The idea is that a measure is composed of measure steps and measure instruments hierarchicaly. From a measure I can configure a measure step and from this measure step I can configure the measure instruments and from the measure instruments I can configure a particular instrument.

My idea was to start a transaction for each hierarchy level so I can accept or cancel some parts or the totality of the configuration. If you can build hierarchical transactions, this problem is relavely simple.

I hope this explanation is clear enough. It is always hard to explain concepts wihtout a picture.

[csch]

Hi Ben,

I want to make measure configuration. The idea is that a measure is composed of measure steps and measure instruments hierarchicaly. From a measure I can configure a measure step and from this measure step I can configure the measure instruments and from the measure instruments I can configure a particular instrument.

My idea was to start a transaction for each hierarchy level so I can accept or cancel some parts or the totality of the configuration. If you can build hierarchical transactions, this problem is relavely simple.

I hope this explanation is clear enough. It is always hard to explain concepts wihtout a picture.

[pravin b]

Hi csch;
Though it's not very clear from the post, i presume you are using the Measure Software. If it's not the case please disregard this. If you are using Measure this might be helpful.

Measure is an add-on package for Microsoft Excel. It provides simple DAQ, GPIB, and Serial tools for communicating with your serial port or with National Instruments DAQ and GPIB hardware. There is no built-in functionality in Measure to communicate with any other software. So i don't think you could access the functionality of LabVIEW database connectivity toolset with Measure.

The best way to enhance the functionality of your Measure application in Excel is to use Visual Basic for Applications (VBA), the built-in programming language in Excel that allows
to you write macros to automate processes on your spreadsheet (including acquisition processes).

I was also wondering if you are using GPIB or DAQ. You also talk about transaction for each hierarcial level in your post, is that just configuration or transaction with a system database?

Regards,
Pravin Borade
Applications Engineer, National Instruments

[Kamran S.]

You may be able to do this in a different manner. Your options depend on how the database has structured the data. For example you can have a table defining "measures", another table defining "measure setps" and so on.

Each measure has an ID (MID) and each measure step has an ID (MSID) and these can be related to each other to provide the hierarchy. So in this case you could just get a measure, then query for all the measure steps that match (the MID and MSID) and sort them based on some attribute/criteria and work down in that manner.

This would provide a clean data architecture and enable you to reuse steps in multiple measures if you needed to. I'm not sure how your database is building the hierarchy, in the end there are some parent ch
ild relationships defined ... these would be very similar to the IDs referred to above.

Like you said, had to explain without a picture.
Regards,
Kamran