Order BY and "Garbage after statement..."

[alexis]

Hi,

This produces the dreaded "Garbage after statement...."

Prices:

LOAD OrderID,

     OpenClose,

     Ask,

     Bid

FROM

TestPrices.xls

(biff, embedded labels, table is Prices$)

ORDER BY OrderID;

and this works fine:

temp:

  LOAD OrderID,

     OpenClose,

     Ask,

     Bid

FROM

TestPrices.xls

(biff, embedded labels, table is Prices$)

;

NoConcatenate

Prices:

LOAD * Resident temp

Order by OrderID;

drop Table temp;

Any ideas?

[#2 · Accepted solution]

Hi Alexis,

an Order By-Clause is only valid for resident tables.

Unfortunaly there comes no (syntax) error from the editor when using it in the wrong way. 

RR

[alexis]

Thank you for responding to my question Roland - I was not aware of that.

Alexis

[maksim_senin]

That would be a good thing to show more informative message in this case.