|Subject||Re: [firebird-support] Re: two machines - different resultsets for ORDER BY|
> Give the following a try:Or set it Inactive / Active.
> ORDER BY StringField || '' ASC, IDField+0 DESC
> This will prevent any index from being used in the ordering, and
> should tell you whether you have a corrupt index. If so, drop the
> ind(ex)/(ices) and redefine them.