Fieldname Function

[Anonymous]

Hi all,

I have a table location and I want to find the fieldname as well as field number from the table. How can I do it?

I know the syntax of Fieldname function but don't know  how to and where to place this syntax in the script to make it work.

FieldName(1,'Table1')

Thanks in advance

[zebhashmi]

That was just an example.

you can use something like that in your script

Load

FieldName(2,'Your Table name') as NewFieldName

from ....

[zebhashmi]

That should work. it will give you a table with one field named ID1 data would be in it the name of filed number 2. make sure you have field number two in the location table.

[zebhashmi]

add from resident ....