Is't possible to use column number instead of field name

[poupou]

I would like to use SQL code like

rename column xx to yy

But I would like to use position number instead xx because I don't know the name of my column but I know is place.

Thanks

Redg

 

[danceman]

select yy as xx from table

the as statement allows renaming fields or aggregates or concatenate char data types

Attitude is Everything

 

[rgbean]

You could use the AFIELDS() function to get the current field name and then the always flexible macro expansion!

USE mytable
=AFIELDS(laFields)
lcSecond = laFields[2, 1]
ALTER TABLE mytable ;
RENAME COLUMN &lcSecond TO yy

Rick

 

[baltman]

If you use the "copy struct to TableStruct Extended" you will have a table where the record number "reccount()" is the column number.

Perhaps you could use that for the basis of some sort of macro/procedure that would use the structure to look-up the actual field name when you refer to a column number.

If your field names are "Excel" like e.g. "A", "B" etc., you can use the column number as a variable when referring to the column as an ASCII map character. Thus:
X=1 and chr(64+x)="A"
X=2 and chr(64+x)="B"
X=3 and chr(64+x)="C"

Brian