Edit

GetDatabaseFieldSize (fileName, fieldName)

Result Type: Number

Definition: Returns the type, or if the field is text, the maximum length of the fieldName in the internal MoneyWorks file fileName.

Examples:  GetDatabaseFieldSize("transaction", "namecode")

returns 11, the maximum length of a namecode in MoneyWorks.

GetDatabaseFieldSize("name", "colour")

returns SHORT, colours being stored as a number in MoneyWorks.

See Also:

GetDatabaseFields: Get table field names from the database schema as a delimited string

GetDatabaseFields GetDatabaseFiles