Executes the specified SQL statement for selecting records of a database.

var rs = xxDBC.ExecuteQuery(strQuery);

Parameters

• strQuery : String, definition of the Query which should be execute

Return Values

xxResultSet object including the results of the query.

 

Examples

// create new xxDBC object
var dbc = new xxDBC();
//set the source for the connection
dbc.Source = "MSSQL";
//opens the connection
var status = dbc.Open();
// execute a query command at the database
var rs = dbc.ExecuteQuery("select * from database..table where field1 = 'value'");
// processing ...