Takes ten parameters, TableName, OldProcName, NewProcName, Type, Params, GroupTypes, Label, Note, DevNote, Source

Description:

In the table specified by TableName, update the procedure named ProcName with the new specified values. If the procedure is not being renamed, OldProcName and NewProcName should be identical.

• ProcName is plain text
• Type must be one of the values available when creating or editing a Procedure in the Admin interface
• Params is plain text
• GroupTypes is delimited by the builtin value of $I for each value
• Label is multiline text
• Note is multiline text
• DevNote is multiline text
• Source is multiline 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:

NewTableProc "MemTab.Person", "ListAll", "ListAll", "Table Report", "", ("DB Admin" & $I & "Office Admin"), "List All", "Lists all users in the system", "Last updated by Bob to change the sort order", pSource