ALTER TABLE
COPY TABLE
DELETE TABLE
DROP TABLE
RENAME TABLE
Abandoning changes
Deleting fields
Getting around in the Table designer
Moving fields
Resizing columns
Saving the table structure
Table designer
User-interface elements in the Table designer
Using the Table designer
Identifying a table language driver and code page
Using table language drivers
Using table language drivers versus global language drivers
Language Reference Contents
Topic group: Accessing and Linking Tables
Topic group: All Topic Groups
Topic group: Application Shell Elements
Topic group: Array Objects
Topic group: Bitwise Elements
Topic group: Character Sets and Language Drivers
Topic group: Command Window
Topic group: Core Language Elements
Topic group: Creating Applications
Topic group: Creating Tables
Topic group: Data Objects
Topic group: Date/Time Language Elements
Topic group: Debugging Applications
Topic group: Designing and Working with Reports
Topic group: Designing tables
Topic group: Editing Code
Topic group: Extending dBASE Plus
Topic group: File\OS Elements
Topic group: Form Objects
Topic group: IDE Language Elements
Topic group: Installation/SQL Connections
Topic group: Language Definition
Topic group: Language Syntax
Topic group: Local SQL Elements
Topic group: Math object elements
Topic group: Menus and Toolbars
Topic group: Miscellaneous Language Elements
Topic group: Operators and Symbols
Topic group: Preprocessor Elements
Topic group: Programming Intro
Topic group: Report Objects
Topic group: Security Issues
Topic group: SQL Designer
Topic group: String Object Elements
Topic group: Text Streaming Elements
Topic group: The dBASE data model
Topic group: Using the Form and Report Designers
Topic group: Working with Tables
Topic group: Xbase Elements
User's Guide Contents
class TableDef
Table properties
A few words of caution
Abandoning changes
Accessing and linking tables (overview)
Adding an OLE object to an OLE field
Adding and inserting fields
Adding rows to a table
ALTER TABLE
Binary fields
Browse component
Changing or deleting referential integrity
Changing the structure
Choosing index fields
Classifying information
CLOSE TABLES
Counting rows
CREATE TABLE
Creating a simple index
Creating complex indexes for dBASE tables
Creating custom field attributes
Creating master-detail relationships (overview)
Creating primary indexes
Creating secondary indexes
Creating the dBASE complex index
Data Access page
Data entry considerations
Data type mappings for CREATE TABLE
dBASE index concepts
Defining individual fields
Defining referential integrity
Deleting fields
Deleting indexes
Deleting rows
Designing tables in dBASE Plus (introduction)
Determining relationships among tables
DROP TABLE
Field types
Getting around in the Table designer
Hiding duplicate values
Identifying the information to store
Important guidelines for restructuring
Indexing and sorting dBASE tables
Indexing on a subset of rows for dBASE tables
Indexing versus sorting
Individual login via automatic password dialogs
Linking a form or report to tables (overview)
Linking master-detail in local tables
Listing SQL tables in the Navigator
Memo fields
Minimizing redundancy
Modifying indexes
Naming conventions
OLE fields
Performing calculations on a selection of rows
Performing operations on a subset of rows
Planning indexes
Primary and secondary indexes
Printing the table structure
Protected tables
Referential integrity (overview)
Removing an OLE object from an OLE field
Replacing data in rows
Restructuring tables (overview)
Rules for dBASE complex indexes
Running a table
Saving or abandoning changes
Saving the table structure
Searching tables
Selecting rows by setting criteria
Session objects
Sorting or exporting rows
Supported table types
Table designer
Table designer fields
Table names and types
Table navigation
Table tools and views
Terms and concepts
To select an index for a rowset
User-interface elements in the Table designer
Using an SQL JOIN statement
Using indexes to link multiple tables
Using local and remote tables together
Using the masterSource property
Using the Table designer
Using the Table wizard
Viewing and editing special field types
Viewing only selected table data
Creating complex indexes for dBASE tables
Creating the dBASE complex index
Rules for dBASE complex indexes
CREATE TABLE
Data type mappings for CREATE TABLE
Choosing index fields
Classifying information
Defining individual fields
Designing tables in dBASE Plus (introduction)
Determining relationships among tables
Field types
Identifying the information to store
Minimizing redundancy
Table designer fields
Table names and types
Terms and concepts
A few words of caution
Adding an OLE object to an OLE field
Adding rows to a table
Binary fields
Counting rows
Data entry considerations
Deleting rows
Memo fields
OLE fields
Performing calculations on a selection of rows
Performing operations on a subset of rows
Removing an OLE object from an OLE field
Saving or abandoning changes
Selecting rows by setting criteria
Table navigation
Table tools and views
Viewing and editing special field types
Viewing only selected table data
Indexing and sorting dBASE tables
Planning indexes
Creating master-detail relationships (overview)
Linking master-detail in local tables
Using an SQL JOIN statement
Using the masterSource property
Changing or deleting referential integrity
Defining referential integrity
Changing the structure
Restructuring tables (overview)
Replacing data in rows
Searching tables
Indexing and sorting dBASE tables
Sorting or exporting rows
Template Property Builder, Character page
Template Property Builder, Date page
Template Property Builder, Numeric page
Brief Editor keyboard mappings
dBASE Plus Classic keyboard mappings
Text editing shortcuts
Date and time overview
getTime()
SET TIME
setTime()
time() [File]
TIME() function
Adding, editing and navigating
Attaching popup menus to forms
Attaching pulldown menus to forms
Building blocks
Changing menu properties on the fly
Creating a custom toolbar
Creating menus with the designers
Creating toolbars and attaching them to forms
Examining menu file code
Features demonstration
Menu and menu item properties, events and methods
Menus and toolbars overview
The designer menu
Toolbar and toolbutton properties, events and methods
Topic group: Accessing and Linking Tables
Topic group: All Topic Groups
Topic group: Application Shell Elements
Topic group: Array Objects
Topic group: Bitwise Elements
Topic group: Character Sets and Language Drivers
Topic group: Command Window
Topic group: Core Language Elements
Topic group: Creating Applications
Topic group: Creating Tables
Topic group: Data Objects
Topic group: Date/Time Language Elements
Topic group: Debugging Applications
Topic group: Designing and Working with Reports
Topic group: Designing tables
Topic group: Editing Code
Topic group: Extending dBASE Plus
Topic group: File\OS Elements
Topic group: Form Objects
Topic group: IDE Language Elements
Topic group: Installation/SQL Connections
Topic group: Language Definition
Topic group: Language Syntax
Topic group: Local SQL Elements
Topic group: Math object elements
Topic group: Menus and Toolbars
Topic group: Miscellaneous Language Elements
Topic group: Operators and Symbols
Topic group: Preprocessor Elements
Topic group: Programming Intro
Topic group: Report Objects
Topic group: Security Issues
Topic group: SQL Designer
Topic group: String Object Elements
Topic group: Text Streaming Elements
Topic group: The dBASE data model
Topic group: Using the Form and Report Designers
Topic group: Working with Tables
Topic group: Xbase Elements
Topic group: Accessing and Linking Tables
Topic group: All Topic Groups
Topic group: Application Shell Elements
Topic group: Array Objects
Topic group: Bitwise Elements
Topic group: Character Sets and Language Drivers
Topic group: Command Window
Topic group: Core Language Elements
Topic group: Creating Applications
Topic group: Creating Tables
Topic group: Data Objects
Topic group: Date/Time Language Elements
Topic group: Debugging Applications
Topic group: Designing and Working with Reports
Topic group: Designing tables
Topic group: Editing Code
Topic group: Extending dBASE Plus
Topic group: File\OS Elements
Topic group: Form Objects
Topic group: IDE Language Elements
Topic group: Installation/SQL Connections
Topic group: Language Definition
Topic group: Language Syntax
Topic group: Local SQL Elements
Topic group: Math object elements
Topic group: Menus and Toolbars
Topic group: Miscellaneous Language Elements
Topic group: Operators and Symbols
Topic group: Preprocessor Elements
Topic group: Programming Intro
Topic group: Report Objects
Topic group: Security Issues
Topic group: SQL Designer
Topic group: String Object Elements
Topic group: Text Streaming Elements
Topic group: The dBASE data model
Topic group: Using the Form and Report Designers
Topic group: Working with Tables
Topic group: Xbase Elements
Topic group: Accessing and Linking Tables
Topic group: All Topic Groups
Topic group: Application Shell Elements
Topic group: Array Objects
Topic group: Bitwise Elements
Topic group: Character Sets and Language Drivers
Topic group: Command Window
Topic group: Core Language Elements
Topic group: Creating Applications
Topic group: Creating Tables
Topic group: Data Objects
Topic group: Date/Time Language Elements
Topic group: Debugging Applications
Topic group: Designing and Working with Reports
Topic group: Designing tables
Topic group: Editing Code
Topic group: Extending dBASE Plus
Topic group: File\OS Elements
Topic group: Form Objects
Topic group: IDE Language Elements
Topic group: Installation/SQL Connections
Topic group: Language Definition
Topic group: Language Syntax
Topic group: Local SQL Elements
Topic group: Math object elements
Topic group: Menus and Toolbars
Topic group: Miscellaneous Language Elements
Topic group: Operators and Symbols
Topic group: Preprocessor Elements
Topic group: Programming Intro
Topic group: Report Objects
Topic group: Security Issues
Topic group: SQL Designer
Topic group: String Object Elements
Topic group: Text Streaming Elements
Topic group: The dBASE data model
Topic group: Using the Form and Report Designers
Topic group: Working with Tables
Topic group: Xbase Elements
String functions [Local SQL]
TRIM()
Error Messages
Error Messages - Alphabetical List
Error Messages - Numerical List
Control statements
TRY
TYPE
type [Field]
type [Parameter]
Automatic type conversion
Explicit type conversion
Type conversion
type [Field]
type [Parameter]
CLEAR TYPEAHEAD
SET TYPEAHEAD