IN Clause (SQL Only)

See AlsovbhowSQLINSee                 ExamplevbhowSQLINEx>Low

Description

Use the IN clause to retrieve data stored in more than one database, such as a dBASE or Paradox database or in another Visual Basic database.  For example, you can use the IN clause to select all customers in a dBASE or Paradox table whose Customer ID has "A" as the first letter.

Notes

         You can use IN to connect to only one external database at a time.  An external database is one other than the current database.

         The IN clause has two parts: The databasename and connect string. The databasename is a fully-qualified path to the file or directory containing the database table and connect contains the database type and other parameters as needed.

         To specify an external database, append a semicolon (;) to the connect part, and enclose it with single or double quotation marks.  For example,  'dBASE IV;' or "dBASE IV;".

The following example uses the IN clause to specify a dBASE IV database table "SALES":

SELECT CUSTOMERS.CustomerID,
FROM CUSTOMERS
IN "C:\DBASE\DATA\SALES" "dBASE IV;"
WHERE CUSTOMERS.CustomerID Like "A*"