Problem with FetchRows - [FetchAll = False]

Mahyaa · Post by **Mahyaa** » Sat 19 May 2007 19:36

Hi
I have a problem with setting FetchRows of TOraQuery . (Delphi 7)

I use a TOraQuery which may return about 500 records .
SQL string contains join of three tables

Code: Select all

select T1.* from T1
inner join T2 on T1.k = T2.k 
inner join T3 On T3.k = T1.k
Where ...

In TOraQuery properties I set :
FetchAll := False;
FetchRows := 25; //-->(Default value)

but when execute the query all record are fetched (not considering FetchRows Value)
any other special settings should be done ?

Thanks

Mahya

Plash · Post by **Plash** » Mon 21 May 2007 09:03

The FetchRows property determines the count of records that are fetched when the dataset is scrolled to the last fetched record. For example, if FetchRows is set to 25, the dataset first fetches 25 records. When you move to record #26, it fetches next 25 records.
You cannot limit a count of records by setting the FetchRows property.

Mahyaa · Post by **Mahyaa** » Mon 21 May 2007 11:50

The FetchRows property determines the count of records that are fetched when the dataset is scrolled to the last fetched record.

OK , I know this : )
I want to get my query result page by page .

when i use TOraTable , Fethchrows property works fine but problem is with the TOraQuery I used .

I'd like to know if there is a special setting that may has effects to this property .

thanks

Plash · Post by **Plash** » Tue 22 May 2007 07:39

We could not reproduce this problem. Please describe why do you think that the FetchRows property works incorrectly. If it is possible, send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.