Starting fetch from last row
Posted: Mon 11 Oct 2010 08:20
Hi;
We have a large market in our country. Our customers are already using our solitions.
In only one year we achieved a rapid increase in our customer databeses and 500 million new data have been processed during this period of time.
We decided to use SDac component (because our datas are coming slowly and your component has fetch property), so we are testing your trial version of sdac. If your product satisfies our needs
we are willing to purchase it.
But there is a problem which we don't know how to solve it.
The problem is : We want to begin fetching in grid from last row.
before using sdac we are using a code like:
ADOQuery1.SQL.Text := 'SELECT * FROM SLT_INVOICE_001';
ADOQuery1.Open;
ADOQuery1.Last;
in now when i use SDAC with fetchall property false:
MSQuery1.Open;
(Sounds like good, everythink is good, fetching record properly.)
we want to begin fetching from last row.
when i use MSQuery1.Last;
the component gets all of records.
it shouldn't get all of data when i use MSQuery1.Last
According to us we must fetching records from last row.
Is there a property like :
MSQuery1.FetchAll := False;
MSQuery1.FetchFromLastRow: True;
MSQuery1.Open; ( like scrolls last row.)
How can we solve that problem?
We wish we can come to a solid soluiton by our approchement .
Thanks for your relation
Best Regards
We have a large market in our country. Our customers are already using our solitions.
In only one year we achieved a rapid increase in our customer databeses and 500 million new data have been processed during this period of time.
We decided to use SDac component (because our datas are coming slowly and your component has fetch property), so we are testing your trial version of sdac. If your product satisfies our needs
we are willing to purchase it.
But there is a problem which we don't know how to solve it.
The problem is : We want to begin fetching in grid from last row.
before using sdac we are using a code like:
ADOQuery1.SQL.Text := 'SELECT * FROM SLT_INVOICE_001';
ADOQuery1.Open;
ADOQuery1.Last;
in now when i use SDAC with fetchall property false:
MSQuery1.Open;
(Sounds like good, everythink is good, fetching record properly.)
we want to begin fetching from last row.
when i use MSQuery1.Last;
the component gets all of records.
it shouldn't get all of data when i use MSQuery1.Last
According to us we must fetching records from last row.
Is there a property like :
MSQuery1.FetchAll := False;
MSQuery1.FetchFromLastRow: True;
MSQuery1.Open; ( like scrolls last row.)
How can we solve that problem?
We wish we can come to a solid soluiton by our approchement .
Thanks for your relation
Best Regards