SET ORDER vs USE.... 1

[brigmar]

Real quick question:

I see code like this:

SELECT 0
USE table1
SET ORDER TO id

.. which I, in my thrifty ways would write as:

USE table1 IN 0 ORDER id

So I ask why is the first form so prevalent (version compatibility aside)?

I've been told the first form is faster. Why would that be so ?

 

[brigmar]

I agree, Mike. I was just after the 'why' behind some advice.

 

[Mike Lewis]

Brigmar,

I was just after the 'why' behind some advice.

Fair comment. It's always useful to understand this background info, regardless of whether it has an immediate application.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk