B.6 SELECT – Simple

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

SELECT * FROM tablename

Parameters

tablename

The name of the table from which to retrieve data.

Return Values

One of the following error messages can be returned:

• E_OUTOFMEMORY
• DB_E_ERRORSINCOMMAND
• DB_E_NOTABLE

Remarks

When invoked by the Open method, this statement returns the same recordset that tablename would. In other words, it causes a table to be opened with all fields and all rows available.