RemoveField

<< Click to Display Table of Contents >>

 

RemoveField

RemoveField(FieldName, [Table])

This method removes a field previously included in a Query. The FieldName parameter determines the name of a field to remove. The Table parameter represents the name of the table to which this field belongs. The next script contains an example of using this method.

Sub CommandButton1_Click()
  Screen.Item("E3Browser").Item("Query")._
    RemoveField "Field1"
End Sub

 

NOTE

If the Table parameter is omitted, the Query object tries to remove the field informed in the FieldName parameter in the first table found on the database.

Was this page useful?