The ACCESS Procedure for PC Files

SELECT Statement

Selects PC file columns for the view descriptor.

Requirement:	This statement is required.
Valid:	for DBF, DIF, WK1, WK3, WK4, Excel 4, Excel 5, and Excel 95 file formats under Windows operating environments
Applies to:	view descriptor
Interacts with:	RESET
Not allowed with:	UPDATE

SELECT ALL|<'column-identifier-1'>...<'column-identifier-n'>;

Details

The SELECT statement specifies which PC file columns in the access descriptor to include in the view descriptor. This is a required statement, and you can use it only when you create view descriptors. You cannot use the SELECT statement when you update a view descriptor.

If you use an editing statement, such as SELECT, it must follow the CREATE statement when you create a view descriptor.

See the CREATE Statement for more information about statement order.

The SELECT statement can take one or more of these arguments:

ALL

includes in the view descriptor all columns that were defined in the access descriptor and that were not dropped.

column-identifier

can be either the column name or the positional equivalent from the LIST statement. This is the number that represents the column's place in the access descriptor on which the view is based. To select the first three columns, submit this statement:

SELECT 1 2 3;

If the column name contains lowercase characters, special characters, or national characters, enclose the name in quotation marks. You can select as many columns as you want in one SELECT statement.

SELECT statements are cumulative within the same view creation. Submit these SELECT statements to select columns 1, 5, and 6.

SELECT 1;
SELECT 5 6;

To clear all your selections when creating a view descriptor, use the RESET ALL statement. You can use another SELECT statement to select new columns.

Top of Page