SELECT – Simple

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

Syntax

SELECT * FROM tablename

Parameters

tablename

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

Return Values

One of the following error values can be returned:

• E_OUTOFMEMORY
  
  
• DB_E_ERRORSINCOMMAND
  
  
• DB_E_NOTABLE

Remarks

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