pszSQL Parameter For dbOpen

pszSQL

Specifies the recordset to load as follows:

$image\sqrblit.gif$ A NULL pointer.

$image\sqrblit.gif$ The name of a table.

$image\sqrblit.gif$ An SQL SELECT statement (optionally with an SQL WHERE or ORDER BY clause).

$image\sqrblit.gif$ A CALL statement specifying the name of a predefined query (stored procedure).

In an SQL SELECT statement, the field containing the image must be specified first. For example, where photo is the image field and who is the sort field, the statement to select all records in the people table would be as follows:

SELECT photo,* FROM people ORDER BY who