<<

EDIT
edit-data button
Edit Event dialog box
Edit mode
Edit Table Privileges dialog box
editCopyMenu
editCutMenu
editing
   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
   Editing a .WFM file
   Editing a Text object
   Editing in the Command window
   Editing properties in the .WFM file
   Editing the header and bootstrap
   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
   The Code Block Builder (overview)
   To create or edit a codeblock
   Using the Source editor
   Viewing and editing special field types
   Viewing only selected table data
    advantage of using forms
    code
    code blocks
       The Code Block Builder (overview)
       To create or edit a codeblock
    Command window
    For condition
    in-place (Text object)
    performing calculations
    special field types
    subset of rows
       Counting rows
       Performing calculations on a selection of rows
       Performing operations on a subset of rows
       Selecting rows by setting criteria
    tables
       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
    tables vs queries
    Text object
    tips
    using an index to limit rows
    WFM files
       Editing a .WFM file
       Editing properties in the .WFM file
       Editing the header and bootstrap
    While condition
editing tables
editing text
   Brief Editor keyboard mappings
   dBASE Plus Classic keyboard mappings
   Text editing shortcuts
editor
   SET EDITOR
   Source Editor [F1 context]
   Using the Source editor
    SET
Editor class
Editor component
Editor Properties dialog box
   Editor Properties dialog box, Appearance Page
   Editor Properties dialog box, Editor Page
   Editor Properties dialog box, Font Page
editorControl
editorType
editPasteMenu
editUndoMenu
EJECT
EJECTPAGE
ELAPSED()
element()
elements
   Aliases
   Command scope
   Common command elements
   elements
   Filenames
    Xbase command
       Aliases
       Command scope
       Common command elements
       Filenames
ELSE
ELSEIF
embedding
   Adding an OLE object to an OLE field
   OLE component
   OLE fields
    in OLE fields
       Adding an OLE object to an OLE field
       OLE component
       OLE fields
EMPTY()
emptyTable()
enabled
   enabled [form]
   enabled [Timer]
enableSelection
enclosing strings
encrypted tables
   Encrypted tables
   Individual login via automatic password dialogs
ENCRYPTION
    SET
ENDFOR
    FOR...
endOfSet
endPage
   choosePrinter( )
   endPage
ENDPRINTJOB
endSelection
ensureVisible()
Entryfield class
Entryfield component
ENUMERATE()
environment
    customizing
eof()
   EOF()
   eof() [File]
EPOCH
    SET
ERASE
ERROR
   ON ERROR
   SET ERROR
    ON
    SET
Error dialog box
error messages
   Error Messages
   Error Messages - Alphabetical List
   Error Messages - Numerical List
error()
   ERROR()
   error() [File]
errorAction
errorHTMFile
errorLogFile
errorLogMaxSize
errors
   Everything else (except Preprocessor) overview
   Types of bugs
    debugging
errorTrapFilter
ESCAPE
   ON ESCAPE
   SET ESCAPE
    ON
    SET
escExit
evalTags
event-driven applications
   Advantages of event-driven programs
   Developing event-driven programs
   How event-driven programs work
event handlers
    debugging
events
    programming (using Inspector)
EXACT
    SET
exact matches
exactMatch
example
    program
Exception class
excluding variable types (Debugger)
EXCLUSIVE
    SET
executables
   Building the Executable
   Starting dBASE Plus or application .exe without using the BDE
   Startup optimizations for Web applications
execute()
   execute() [DDELink]
   execute() [Query, StoredProc]
executeMessages( ) method
executeSQL()
executing
   Controlling program execution
   Interacting with the Source editor
   Running a program at full speed from the Debugger
   Running a query from the SQL designer
   Typing and executing commands
   Using breakpoints
    commands
    programs in the Debugger
       Controlling program execution
       Running a program at full speed from the Debugger
       Using breakpoints
    queries
       Interacting with the Source editor
       Running a query from the SQL designer
execution
    functions and classes
exeName
Exists clause
   Adding selection criteria (SQL designer)
   Criteria page (SQL designer)
   Group criteria page (SQL designer)
exists()
EXIT (loop)
exit (program)
EXP()
expandable
expanded
Explorer
    Project
exponent
    logarithm
exporting table data
expression
expression codeblock symbol
expressions
   Basic expressions
   Complex expressions
   Expressions
   Operator precedence
    basic
    complex
    evaluating
expressions (key)
EXTENDED
   COPY STRUCTURE EXTENDED
   CREATE...STRUCTURE EXTENDED
    COPY STRUCTURE
    CREATE...STRUCTURE
extending dBASE Plus
EXTERN
EXTRACT()

FACCESSDATE()
FCLOSE()
FCOUNT()
FCREATE()
FCREATEDATE()
FCREATETIME()
FDATE()
FDECIMAL()
features
FEOF()
FERROR()
FFLUSH()
FGETS()
Field class
field components
field morphing
   beforeGetValue
   canChange [Field]
   picture [form components]
    and picture templates
    reversing
field names
   Handling character incompatibilities in field names
   Using variables and field names in expressions
    and character incompatibilities
    using in expressions
Field objects
    dataLink property
    value property
field order (queries)
Field palette
    and dataLink property
    displaying fields
    opening
    using
Field Properties dialog box
Field types
FIELD()
fieldName
fields
   Adding an OLE object to an OLE field
   Adding and inserting fields
   Adding columns (fields) to a report
   Binary fields
   Choose Field Dialog Box
   CLEAR FIELDS
   ComboBox component
   Creating custom field attributes
   Defining individual fields
   Deleting columns (fields) from a report
   Deleting fields
   Entryfield component
   Field types
   fields [Browse]
   fields [Rowset]
   Getting around in the Table designer
   Memo fields
   Moving fields
   Name/database delimiters
   OLE fields
   picture [form components]
   Referential integrity (overview)
   Removing an OLE object from an OLE field
   Selection page (SQL designer)
   SET FIELDS
   Specifying data-entry constraints
   User-interface elements in the Table designer
   Viewing and editing special field types
    adding
    adding to reports
    binary
    calculated and picture templates
    choosing type
    CLEAR
    custom attributes
    data entry creating in forms
       ComboBox component
       Entryfield component
    data entry constraints
    dBASE types
    default values
    defining
       Defining individual fields
       User-interface elements in the Table designer
    deleting (Table designer)
    deleting from reports
    image
    linking to controls
    memo
    moving (Table designer)
    naming
    naming with spaces in them
    OLE
       Adding an OLE object to an OLE field
       OLE fields
       Removing an OLE object from an OLE field
    parent/child values
    selecting (Table designer)
    selecting in queries
    SET
    setting defaults
    sound
    validity checks
    viewing special types
fields array
Fields Property Builder
fields()
FILE
   COPY FILE
   CREATE FILE
   DELETE FILE
    COPY
    CREATE
    DELETE
File class
File information functions
File Item Properties dialog box (Navigator)
File Properties dialog box (Project Explorer)
file types
File utility commands
FILE()
filename property
   class Exception
   filename [DataModRef]
   filename [Designer]
   filename [ReportViewer]
filename skeleton
files
   dBASE index concepts
   DISPLAY FILES
   Indexing versus sorting
   LIST FILES
   Putting your queries to work
   The Navigator [F1 context]
   To add files to a project
    adding .SQL to forms and reports
    adding to projects
    DISPLAY
    LIST
    locating
    multiple index
    multiple index (MDX)
fill()
FILTER
   filter
   SET FILTER
    SET
filter-data button
Filter mode
filterOptions
FINALLY
find and replace
Find Rows dialog box
Find Text dialog box
finding rows
   Replacing data in rows
   Searching tables
FINDINSTANCE()
findKey()
findKeyNearest()
first
first()
firstChild
firstColumn
firstKey
firstOnFrame
firstPageTemplate
firstRow( ) method
firstVisibleChild
fixed
fixes
fixing bugs
Flags parameter
FLDCOUNT()
FLDLIST()
FLENGTH()
Float
FLOCK()
FLOOR()
FLUSH
flush()
   flush() [File]
   flush() [Rowset]
FNAMEMAX()
focus
focusBitmap
Folder Properties dialog box
Font Property Builder
fontBold
fontItalic
fontName
fonts
   fontBold
   fontItalic
   fontName
   fontSize
   fontStrikeout
   fontUnderline
   GETFONT()
   headingColorNormal
   headingFontBold
   headingFontItalic
   headingFontName
   headingFontSize
   headingFontStrikeout
   headingFontUnderline
    Grid headings
       headingColorNormal
       headingFontBold
       headingFontItalic
       headingFontName
       headingFontSize
       headingFontStrikeout
       headingFontUnderline
    Grid text
       fontBold
       fontItalic
       fontName
       fontSize
       fontStrikeout
       fontUnderline
fontSize
fontStrikeout
fontUnderline
footerBand
FOPEN()
for
FOR()
FOR...ENDFOR
for...in
forExpression
form
   CREATE FORM
   form
    CREATE
Form class
Form class definition
Form designer
   Form designer
   The designer windows
   Using the Form and Report designers (overview)
Form Designer Properties dialog box
Form wizard
Format toolbar
formatting strings
forms
   Building the user interface (overview)
   Creating a custom form, report, or data module class
   Creating a form
   Creating master-detail relationships (overview)
   Form design guidelines
   Form designer
   Global page (forms)
   Linking master-detail in local tables
   Navigation buttons (form pages)
   Opening a form or report in Run mode
   Printing a form or report
   Putting your queries to work
   Saving, running, and printing forms and reports
   Setting a scheme (Form designer)
   To select an index for a rowset
   Using an SQL JOIN statement
   Using multi-page forms (overview)
   Using the Form designer
   Using the Form wizard
   Using the masterSource property
    creating
       Creating a form
       Using the Form wizard
    creating (basic steps)
    creating custom class
    design guidelines
    designing
    global page
    master-detail relationships
       Creating master-detail relationships (overview)
       Linking master-detail in local tables
       Using an SQL JOIN statement
       Using the masterSource property
    multi-page
    multi-page navigation
    opening in Run mode
    printing
    saving
    selecting indexes
    setting colors and fonts
    user interface
    using SQL files
forward slash (symbol)
FOUND()
FPUTS()
frameWin
FREAD()
FROM
   APPEND FROM
   CREATE...FROM
    APPEND
    CREATE...
FROM ARRAY
   APPEND FROM ARRAY
   REPLACE FROM ARRAY
    APPEND ARRAY APPEND FROM
    REPLACE
FROM clause
frozenColumn
FSEEK()
FSHORTNAME()
FSIZE()
FTIME()
FULLPATH
    SET
FUNCTION
   FUNCTION [core language]
   function property
   SET FUNCTION
    SET
function pointers
functions
   Command window [F1 context]
   Functions and classes
   INDEX
   The Command window
    allowed in DBF index
    and execution
    using in command window
       Command window [F1 context]
       The Command window
functions (local SQL)
   Aggregate functions [Local SQL]
   Date function [Local SQL]
   String functions [Local SQL]
    aggregate
    date
    string
functions and codeblocks
   Codeblocks
   Codeblocks vs. functions
   Function pointers
   Functions and codeblocks
FUNIQUE()
FV()
FWRITE()

>>