You might also try the free Zeoslib components. Their TZQuery doesn't need any special TClientDataSet events to process your particular query.
The MyDAC components (not free) can do the same thing. I use both. http://zeos.firmos.at/portal.php http://www.devart.com/mydac/ --- In delphi-en@yahoogroups.com, David Smith <djsmith_1...@...> wrote: > > The TQuery component doesn't know how to determine which records to update > based on the information in that query. If you use a TClientdataset you can > use it's various events to make these determinations (by using a returned > index value for example). In your case, you could use a different TQuery than > the one that retrieved the result set, and generate a query on the fly based > on index values for example. > > Dave > > --- On Thu, 5/13/10, forbvijay <forbvi...@...> wrote: > > From: forbvijay <forbvi...@...> > Subject: [delphi-en] Re: prob. with Tquery.requestlive > To: delphi-en@yahoogroups.com > Date: Thursday, May 13, 2010, 5:13 AM > > > > > > > >  > > > > > > > > > > > > correction to the entered query it should be as 'select * from table limit 10 > offset 20;' > > > > thanks, > > vijay. > > > > --- In delphi-en@yahoogroups.com, "forbvijay" <forbvijay@> wrote: > > > > > > hi, > > > > > > do any one know how to request a "live result set" in MySQl when query > > has offset(eg: select * from table where limit 10 offset 20;). it is > > throughing an error like 'invalid use of keyword'. > > > > > > Thanks, > > > Vijay. > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] >
