DataWindow Reference分析和总结最新分析和总结.docxVIP

DATAWINDOW REFERENCE 1 OPERATORS AND EXPRESSIONS 1 About DataWindow painter expressions 1 Computed fields 1 Filters 1 Validation rules for table columns 2 Operators used in expressions 2 Operators used in expressions 2 Relational operators 2 BETWEEN and NOT BETWEEN operators 3 LIKE and NOT LIKE operators 3 Logical operators 4 Comparing strings 4 Case-sensitivity examples 4 Trailing blanks examples 4 Evaluating DataWindow painter expressions in scripts 4 Using Evaluate within the Describe function 5 Using Evaluate with conditional property expressions 6 ACCESSING DATA IN SCRIPT 6 Methods for accessing data 6 About DataWindow data expressions 7 Data in columns or computed fields when you know the name 7 Data in numbered columns 7 When the expression is evaluated 8 Getting and storing the data 8 Data structures for data 8 Examples of data structures 9 Assigning data to arrays 9 Any data type and data expressions 9 Examples 9 Setting DataWindow data 10 Expressions with a named column or computed field 10 One or all items in a named column or computed field 10 Items in the column from selected rows 11 Items from a range of rows in a column or computed field 12 Expressions with column numbers 13 Single items 13 A block of rows and columns 13 Expressions that access whole rows 14 Selected rows 15 ACCESSING DATAWINDOW PROPERTIES IN 15 What are DataWindow object properties?. 15 Specifying property values in the painter 16 Methods for accessing property values in scripts 16 About the Modify and Describe functions 17 Advantage and drawbacks 17 Advantage 17 Drawbacks 18 Handling errors 18 Modify 18 Describe 18 About DataWindow property expressions 18 Basic structure of DataWindows and property expressions 18 Data types of property expressions 19 DataWindow property values 19 DataWindow property expressions 19 Handling errors in the Error event 19 Syntax for property expressions 19