nested SQL queries

[ponnaboy]

Hi,
Does Labview Database connectivity tool support nested SQL Queries ? If so can someone tell me how to perform the following query:
SELECT NAME,ADDRESS FROM EMP_TABLE WHERE salary=(SELECT MAX(salary) FROM EMP_TABLE)

[Wiebe@CARYA]

Hi,

The query is just passed to ODBC (, or the database). The Query you send is
(as far as I know) not parsed in any way by LabVIEW.

Some databases (a lot of them) do not support nested SQL Queries, other do.
First I'd make sure if the database you use does support them (e.g. by using
a build-in query tool). Then try the simplest nested query in LV.

Regards,

Wiebe.

"ponnaboy" wrote in message
news:506500000008000000E0B60000-1068850981000@exchange.ni.com...
> Hi,
> Does Labview Database connectivity tool support nested SQL Queries ?
> If so can someone tell me how to perform the following query:
> SELECT NAME,ADDRESS FROM EMP_TABLE WHERE salary=(SELECT MAX(salary)
> FROM EMP_TABLE)

[Russ@Davis]

Hi,
Another option that will keep the LV app more flexible is to create a stored procedure in the DB (if they are supported). Then, you make a simple call to the stored procedure and desired data is returned. This allows for the SQL statement to be debugged and changed withthout ever modifying your LV code.

RS