RE: STRSQL request gives CPF4802

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

> -----Message d'origine-----
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Dennis Lovelady
> Envoyé : jeudi 12 novembre 2009 11:49
> À : 'Midrange Systems Technical Discussion'
> Objet : RE: STRSQL request gives CPF4802
>
> > I'm joining 3 tables, clients, addresses and clientadresses 
> to get the 
> > clients living in a town.
> >
> > What determines the order of the select?
> > They seem to be mostly in the order of the fields in the select.
>
> The ORDER BY clause (which is missing from your text) 
> determines the order.

Ok I created a logical with key on clientName but the request took ages and I got the message that an index was being created with clientName during the execution. So I made my own index and used that. The request runs instantly.

I thought the LF was equivalent to an index?