LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Using SQLplus command in LabView Database toolkit

Hi ,

 

I would like to ask something but before that this is my set up background

 

OS          : Win 7,

LabVIEW : 2012

 

I have successfully connected with Oracle database using Labview Database toolkit.

The problem now is since I need to query the data from the database,

it will takes time for the labview to process it (since there is so much data in a specific table),

 

let say that the table in database is "Serial Number", and the data that I want from that table is "SN123"

if I query the data from that table, the labview will process it in a long time since it will not only give me "SN123" but also other data inside the "Serial Number" table.

 

(Refer to attachment)

 

but if in SQLplus, there is a command that can be execute to specifically call the "SN123" data,

 

For the SQLplus, the steps to retrieve the data is like this:

1. Key in the command to get the ID of the "SN123"

2. Key in the command "SN123" ID to retrieve the data.

 

I wonder if there is a way to put this command on labview database so it will be faster to retrieve the data.

 

0 Kudos
Message 1 of 1
(2,419 Views)