SELECT – Simple

This statement returns all the fields and all the rows from the table specified.

Syntax

SELECT * FROM tablename

Parameters

tablename

Specifies the name of the table from which to retrieve data.

Remarks

When invoked by means of the Open method, this statement returns exactly the same as tablename would. In other words, it causes tablename to be opened with all fields and all rows available.

Return Values

One of the following error values can be returned:

• E_OUTOFMEMORY
• DB_E_ERRORSINCOMMAND
• DB_E_NOTABLE