[Discuss] Advanced Database Query

[Bruno Costa]

Name: Advanced Database Query

Submitter: Bruno Costa

Submitted: 01 Jun 2010

File Updated: 03 Jan 2011

Category: *Uncertified*

LabVIEW Version: 8.6

License Type: BSD (Most common)

Description:

This component automatizes the work of: format sql statement, execute sql query and build a cluster with data output.

This function accept a sql statement with parameters like format into string and you can resize this function to the number of input parameters.

The output data can be a cluster or an array of cluster defined double clicking on function.

How to use:

Wire db connection input.

Wire sql statement with parameters like format into string function.

Resizes the function with the number of parameters into sql statement,

If the sql statement produces data output, double click on function to Edit columns of data outuput.

Requirements:

Database conectivity toolkit

Scripting tools

This function isn't 100% complete. It's need to complete some abilities and code improvements. If anyone want help me, be welcome.

My email is bitcosta@ig.com.br

Click here to download this file

[Yair]

Can you upload a video demonstrating the use of this Xnode? Screencast seems to be a popular site for doing these recordings.

[Bruno Costa]

Can you upload a video demonstrating the use of this Xnode? Screencast seems to be a popular site for doing these recordings.

Hi

I make a small screencast to demonstrate this component.

Bruno

demo.swf

[Yair]

Impressive.

Unfortunately, it doesn't quite fit the way I code (and I probably wouldn't want to use an unsupported Xnode in production code anyway).

[asbo]

Very cool indeed!