DOA with FilterDialog InfoPower

[junior]

The FilterDialog Infopower component works very slow with TwwOracleDataset. Because's DOA don't let me set the property FilterMethod = fdQueryModify , just with FilterMethod = fdByFilter.
How i can proced to optimize this search
I need this answer URGENT !!!

[This message has been edited by junior (edited 22 February 2000).]

 

[Marco Kalter]

The wwFilterDialog is not compatible with the TOracleDataSet when using fdQueryModify. As a result the filter will be applied on the local data, which is of course slow for large result sets. You can try to make the result set smaller, or you can use TOracleDataSet's native QBEMode instead.

------------------
Marco Kalter
Allround Automations

 

[aleithner]

will there be a fix/workaround for that problem (using fdQueryModifiy)?

 

[Victor]

wwfltdlg.pas:

Insert after line 1100:
if wwIsClass(Datasource.DataSet.ClassType, 'TCustomADODataSet') then
wwSetConnection(tempDataSet, wwGetConnection(datasource.dataset));

next lines:

if datasource.dataset is TOracleDataSet then
TOracleDataSet(tempDataSet).Session := TOracleDataSet(datasource.dataset).Session;