AddField

<< Click to Display Table of Contents >>

 

AddField

AddField(Name, [Table])

This method adds a new Field from a table to a Query. The Name parameter determines the name of that new field added to a Query. The Table parameter represents the name of a table to which that Field belongs. The next script contains an example of using this method.

Sub Button1_Click()
  Screen.Item("E3Browser").Item("Query").AddField "Field1"
End Sub

 

NOTE

This method fails if the QueryType property is configured to 1 (one, qtStorage).

Was this page useful?