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 <[email protected]> wrote: From: forbvijay <[email protected]> Subject: [delphi-en] Re: prob. with Tquery.requestlive To: [email protected] 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 [email protected], "forbvijay" <forbvi...@...> 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]
