High level query method that is aware of the data mode in operation. For porting data between different data layers use this method for SQL commands that can run against any backend.

o.query(lcSelect, lcCursor, lnResultmode)

Return Value

number of records retrieved or -1 on error.

Parameters

lcSelect
The SQL statement to run.

lcCursor
Optional - Name of the cursor to return result to. Uses cSQLCursor if not set

lnResultmode
See values for wwBusiness::ConvertData

Remarks

Query() should not use an INTO clause since the method will generate it.

Running Query() without any parameter will return all data from the datasource.

See also:

Class wwbusiness