Download Database - National Instruments

Contents
About This Manual
Organization of This Manual .........................................................................................xi
Conventions Used in This Manual.................................................................................xii
Related Documentation..................................................................................................xiii
Customer Communication .............................................................................................xiii
Chapter 1
Introduction
Installation .....................................................................................................................1-1
Installing the LabWindows/CVI SQL Toolkit Software.................................1-1
Overview........................................................................................................................1-3
Chapter 2
Getting Started
Database Concepts .........................................................................................................2-1
Structured Query Language (SQL)................................................................................2-2
ODBC Standard .............................................................................................................2-3
ODBC Administrator .....................................................................................................2-3
Third-Party ODBC Database Drivers ............................................................................2-4
ADO Providers ..............................................................................................................2-4
Database Sessions ..........................................................................................................2-5
Step 1. Connecting to the Database.................................................................2-5
Step 2. Activating SQL Statements .................................................................2-5
Step 3. Processing SQL Statements.................................................................2-5
Step 4. Deactivating SQL Statements .............................................................2-6
Step 5. Disconnecting from the Database........................................................2-6
Chapter 3
Using the SQL Toolkit Library
Function Summary.........................................................................................................3-1
Connecting to a Database ..............................................................................................3-3
Using Automatic SQL (Maps) .......................................................................................3-3
Using Explicit SQL Statements .....................................................................................3-5
Fetching Records ...........................................................................................................3-6
Inserting a Record ..........................................................................................................3-7
Updating a Record .........................................................................................................3-8
Deleting a Record ..........................................................................................................3-8
© National Instruments Corporation
v
LabWindows/CVI SQL Toolkit Reference Manual