UpdateTableField

Takes seven parameters, TableName, OldFieldName, NewFieldName, Label, Note, Attr, DevNote

Description:

In the table specified by TableName, update the field named OldFieldName with the new specified values. If the field is not being renamed, OldFieldName and NewFieldName should be identical.

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", "Modified", "Last Modified", "Date and Time", ("[R]" & $I & "[=] $Now"), "Track and show the last time this record was updated"