Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
That was just an example.
you can use something like that in your script
Load
FieldName(2,'Your Table name') as NewFieldName
from ....
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.
add from resident ....