Article Details
Id:19132
Product:finPOWER Connect
Type:NEW
Version:3.04.04
Opened:31/03/2022
Closed:04/04/2022
Released:09/06/2022
Job: J028545

ISSelectQueryBuilder.ExecuteDataReader obsoleted; use ExecuteDisconnectedDataReader from scripts instead

The ISSelectQueryBuilder.ExecuteDataReader function has been obsoleted - instead use the ExecuteDisconnectedDataReader function.

This makes it easier for C# scripts to use as optional by reference parameters make coding more complex.

For example:

int RowCount = 0;

// Using the old function requires all parameters to be specified and the by reference RowCount parameter must be defined
if (sqb.ExecuteDataReader(ref dr, false, ref RowCount, -1)) {
}

// New functions
if (sqb.ExecuteDisconnectedDataReader(ref dr)) {
}

// New function also returning a count of Rows
if (sqb.ExecuteDisconnectedDataReader(ref dr, ref RowCount)) {
}