if You try to select like
example
table1
nr number
status varchar2(1)
after query
select * from table1 a, table1 b
where a.nr = b.nr
You get cursor with fields
nr,status,nr_1,status_1
because each column must be unique identified by name and there is more then 1 column with this name
And You can't define alias name AFTER query execution
in your example
Text1 := FieldAsString('Status')
Text2 := FieldAsString('Status_1')
Best regards
Vents Lauva
[This message has been edited by Vents Lauva (edited 06 March 2001).]