SQLQuery Method

Placement holder defining the SQLQuery method.

Syntax

ArrayList SQLQuery( 
   string fieldList,
   string whereClause,
   ArrayList whereValues,
   string orderByString
)

Parameters

fieldList: A comma separated list of field names or "*" for all fields
whereClause: The built where clause to allow selection of the reuqired data from the table.
whereValues: The assocciated parameter values for the where clause.
orderByString: Any order by clause in string format

Return Value

An array list of strings containg the selectionr results that can be iterated be the client code.

Remarks

This method provides the ability to perform powerful selection processing of the database table.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IToSQL Interface
IToSQL Members