Database

[pmathuria]

Dear Sir,

I have written a code in Visual basic  for data updates which has primary keys and run as follows:

1. First select the table in the database

2. Move record  to first

3. Creates criteria for primary keys in database with input field, checks comparison, creates record count

4. If record count is 0 than adds new record

5. Else if record count is 1 than ask for overwrite the data by giving an option of yes/no/cancel

6. Close the database.

Please guide me for writing a exact code in Labview which follows above steps.

Thanking you

Sincerely,

Parag H Mathuria, PhD

Sound and vibration Lab

Emerson Climate Technologies, Inc.

1675 West Campbell Road

Sidney  Ohio - 45365.

Office #  937 498 3512

Fax # 937 498 3118

web site:

http://www.copeland-sid.com/

[Ankita]

Hi Parag,

I would suggest looking at the Database Connectivity Toolset (which can be purchased as an add-on to LabVIEW) for your application. The LabVIEW Database Connectivity Toolset offers connectivity to most popular databases through Microsoft ADO technology, complete SQL Functionality, and the ability to save records in XML format. It provides both easy-to-use and advanced functions to allow common database operations as well as detailed database accessibility. Here is a link that describes this Toolset in detail:

http://www.ni.com/toolkits/lv_db_conn.htm

Hope this helps.

Ankita