VB6 beginners tutorial - Learn VB6

Advanced VB6 tutorial - Learn Advanced VB6

Systems Analysis - System analysis and Design tutorial for Software Engineering

You are here: Visual Basic > Advanced VB6 tutorial > Chapter 9

Writing SQL Statements

Structured Query Language (usually referred to as SQL) is the language you use to specify the data included in a Recordset. It can also provide you with the vehicle for specifying changes to data through the Database object's Execute method.

You can use a SQL Select statement in the form of a string as the first argument to the Database object's OpenRecordset method when you want to open either a dynaset or snapshot-type Recordset.

You also can use a SQL statement to update data and even modify database structure (such as table definitions and fields) when you pass such a statement in a string to the Database object's Execute method.

The following sections under this heading detail some of the more important features of SQL Select statements.



<< Previous | Content | Next >>

Home | About Us | Privacy Policy | Contact Us

Copyright © | All Rights Reserved