Devart Forums

Hi,

i'm using the TSmartQuery with the DevExpress Grid Control.

IF the grid control is in the Enhanced Mode (GridMod = False) it fetches all Records until EOF.

I want to give the user the option to cancel the fetch process using the BeforeFetch Event.

The problem is that setting "Cancel = True" stops only the current execution, but didn't change the eof, and then the grid ignores this and tries to fetch again.

Is there any chance to solve this problem?

The DOA Components have something similar, there it was no problem.

Greetings and thanks
Jens

Currently ODAC doesn't have such feature. But in next biuld of ODAC TSmartQuery component will set EOF to True if you set to True AutoClose option of the component and set Cancel parameter in BeforeFetch event.

This is a good news.

Did you have a timeframe for this?

Greetings
Jens

New build of ODAC will be available in a month or later. If you use ODAC Professional we can send you the fix for ODAC sources.