determining or producing field names & definitions

Is there a technique or utility to produce a file layout containing
the field name, field type (char, date, etc),
maximum length etc without having to examine each field and/or the
data entered for that field.

We are doing some data importation and trying to determine the data
characteristics and boundaries

I am running FileMaker Pro 5.0v3 on a Windows machine.


Any ideas, tips or suggestions greatly appreciated


Sincerely

George

On 2009-02-12 13:28:02 -0800, George Lewycky said:

> Is there a technique or utility to produce a file layout containing
> the field name, field type (char, date, etc),
> maximum length etc without having to examine each field and/or the
> data entered for that field.
>
> We are doing some data importation and trying to determine the data
> characteristics and boundaries
>
> I am running FileMaker Pro 5.0v3 on a Windows machine.

Sure, go into Define Fields, and print the field list for each file. FM
5 was a while ago but you should find a Print button on the define
fields dialog screen. You'll get field name, data type and other info,
such as calculations, validations, etc.

FWIW, FM text fields do not have inbuilt field length limitations.
Those must be done with validations, which don't fire until after the
field is exited.

You can also print scripts, should you desire to do so.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA