>>"Master" is a reserved word in VFP, maybe in the provider as well.
>
>Do you think this is what could make the OleDb provider go wild on specific occasions only? Usually, when there is something wrong, it should always generate an error. This is what confuses me about this OleDb thing it is that it does it sometimes and some other times not.

Well, you could test by SELECTing everything into a temporary cursor (NOFILTER) with a different alias (e.g. "Master1"), then running your main SELECT against that, to see if that makes a difference.

>
>>For ease of reading and maintenance I'd recommend using local aliases e.g.
>>

>>SELECT A.Numero, ...
>>FROM Master A ;
>>...
>>

>
>Thanks, but IMHO this is one of those things that makes things more difficult to understand. If I see A in front of a field as an alias, basically, it doesn't tell me anything about the original source.

If you want to do the test I outlined above, you make 1 change to the code with local aliases, rather than changing in many places, so maintenance is easier in this case.

As for readability, chacun a son gout, je suppose.