TSmartQuery : Set EOF = True after 1000 Records

jfudickar · Post by **jfudickar** » Sun 27 Aug 2006 21:07

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

Plash · Post by **Plash** » Fri 01 Sep 2006 07:01

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.

jfudickar · Post by **jfudickar** » Fri 01 Sep 2006 11:19

This is a good news.

Did you have a timeframe for this?

Greetings
Jens

Plash · Post by **Plash** » Fri 01 Sep 2006 11:35

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.