SystemTables of $Field System Variable

[#1]

Hi,

I know that systemvariable $Field represents all fields of loaded application. I also know that the $Table variable gives the corresponding table(s).

Wo do I act in script, if I only want the Fields of a specific table?

something like this:

tmpTableFields:

LOAD $Field FROM $Tables WHERE $Table = '<specific table name>';

What is the SystemTableName of $Fields ($Tables in upper example)? And is the where clause $Table = '<specific table name>' correct?

Any suggestions?

[#2]

Hi

As far as I know you cant use the systemvariables in the script.
Have a look at the table-functions NoOfFields & FieldName.
Used together with while and iterno you should be able to get the desired result.

/Fredrik

[rwunderlich]

I don't think $Table and $Field are available until the script has finished. Instead, use the functions

NoOfFields('tableName')

and

FieldName(num'tableName')

to get a list of fields.

-Rob