NewTableField

Takes six parameters, TableName, FieldName, Label, Note, Attr, DevNote

Description:

In the table specified by TableName, create a new field named FieldName.

The Label and Note are plain text and may include HTML. The Attr field is also plain text but individual attributes are delimited by the builtin value of $I. The DevNote field is plain text.

All fields need their data to be submitted as escpated HTML using the WebSafe$. When using the ListProcs command, the data is returned in this format already. Also, any data submitted via a URL parameter or URL encoded form data to Moxie has WebSafe$ applied automatically.

Example:

NewTableField "MemTab.Person", "Modified", "Last Modified", "Date and Time", ("[R]" & $I & "[=] $Now"), "Track and show the last time this record was updated"