On Thu, 31 Jul 2008, Pritpal Bedi wrote: Hi Pritpal,
> This is an xHarbour compiled ( as of Jun 2007 CVS ) application, a very > large one. > RDD = > RDDADS > Here is a code snippet: > select verify > set order to 2 > seek substr(cCustId,2) // Generates RT Error and stats are > alias() == verify > recno() == 200120 or like > IndexOrd() == 0 > GenCode == 36 > Description == Workarea not indexed. > > This error comes ocassionaly and not all the time. > Table under the error may be different, above is only one instance. > I need to know under what circumstances this error can happen. But what's the error? > For sure "SET ORDER TO 2" statement is failing somehow on Advantage. We do not manage indexes in ADS RDD. All calls are directly redirected to ACE. If it refuses to set the order then probably index is not open for some reasons. > It is really difficult to understand where I put additional traps as > the error has no particular place in this very large application. Inside error handler please check workarea, current index, number of indexes and tags inside. Maybe you will find the reason. ADS RDD in [x]Harbour is only very simple wrapper to ACE library the above is basic functionality and I do not believe that it's a bug in order selection - it's basic functionality. Rather some differences in autoopen and/or production indexes handling which are later exploited by your code. best regards, Przemek _______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
