> > > What is the command that will find a column name in a table and returns true or false?
> > >
> > > Thanks.
> > > Dan-Yeung
> >
> > Is FIELD() what you're looking for?
> >
> > -BP
> > www.peisch.com
>
> I used ?field(id) at the Command Window and got "Function argument value, type, or count is invalid".
>
> Thanks.
> Dan-Yeung

field() is one typical example of an override function. It can take two parameters. One is numeric the other is a string.

If you give it a numeric value it will return the name of the field, given that the number does not exceed the amount of fields in your table. In that case it will return nothing. fcount() will give you the number of fields in a table.

If you give it a string then that string must be a name of a field in your table. It will then return the name of that same field, given again that the name exists in your table. Otherwise it will return nothing.

Boudewijn Lutge®ink
My Blog is here