Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you wildcard from a load table like the below script and it will use the aliases?
.
tab1:
Select * from transtable;
Load * resident tab1 order by C desc, B asc, 1 desc;
Will that work?
Thanks,
Neil.
tab1:
Select * from transtable;
Load * resident tab1 order by C desc, B asc, 1 desc;
it works and concatenates the 2 tables result, but why you do not order in the select?
tab1:
Select * from transtable;
Noconcatenate
Load * resident tab1 order by C desc, B asc, 1 desc;
Drop Table tab1;
Can tab1 be empty?
I mean never be loaded into? So 'tab1:' initiates a blank table?
My problem is I use autonumber on a concatenated string to make it unique.
But I lose the order of the 2 elements in the sort order, ie name and location
So then I need to sort those 2 elements as sort by text does not work in a expression, I need to sort in the load order.