<<

background
   background
   Setting background color in reports
   Setting background image in reports
    reports
       Setting background color in reports
       Setting background image in reports
background (setting scheme)
Band class
base 10 logarithm
baseClassName property
Basic caching
    behavior
    pros and cons
basic expressions
basic language attributes
basic statements
BDE
   How to connect to an SQL database server
   Local SQL overview
   Procedure for using a Session object
    configuring
    default session
BDE Administrator
BDE alias
   Data objects diagram
   Data objects: Class hierarchy
BDE Limits
before
beforeCellPaint
beforeCloseUp
beforeDropDown
beforeEditPaint
beforeGetValue
beforeRelease
beginAppend()
   beginAppend() [Form]
   beginAppend() [Rowset]
beginEdit()
beginFilter()
beginLocate()
beginNewFrame
beginNewFrame()
BEGINTRANS()
   BEGINTRANS()
   beginTrans() method
beginTrans() method
BELL
    SET
bgColor
BINARY
   COPY BINARY
   REPLACE BINARY
    COPY
    REPLACE
binary and OLE data
binary fields
BINTYPE()
BITAND()
BITLSHIFT()
bitmapAlignment
BITNOT()
BITOR()
BITRSHIFT()
BITSET()
   BITSET()
   BITSET() example
    example
Bitwise
BITXOR()
BITZRSHIFT()
BLANK
block comment symbol
blocks
    selecting (results pane)
BLOCKSIZE
    SET
BOF()
bold
BOOKMARK()
   bookmark()
   BOOKMARK() [Xbase]
bookmark() method
bookmarking help topics
bookmarksEqual()
border
borders
   Creating report borders
   scroll()
    in reports
    scrolling a client area
borderStyle
Borland Database Engine (BDE)
Borland SQL Links
bottom
braces (symbol)
Breakpoint Condition dialog box
breakpoints
   Using breakpoints
   Working with breakpoints
Breakpoints dialog box
Brief Editor
   Brief Editor keyboard mappings
   dBASE Plus Classic keyboard mappings
   Text editing shortcuts
BROWSE
Browse class
Browse component
Browse mode
bugs
   Types of bugs
   Using the Debugger (introduction)
    types
BUILD
Build Array dialog box
Build Codeblock dialog box
button components
buttons
   buttons
   PushButton component

cacheUpdates
Caching
    basic
    dynamic
CALCULATE
Calculate Aggregates dialog box
Calculated Field dialog box
calculated fields
   class Field
   picture [form components]
    and picture templates
    creating
calculations (reports)
calculations on rows
call operator
call stack
canAbandon
canAppend
CANCEL
canChange
   canChange [Field]
   canChange [TreeView]
canClose
   canClose [Form]
   canClose [Query, StoredProc]
canDelete
canEdit
canEditLabel
canExpand
canGetRow
canNavigate
   canNavigate [Form]
   canNavigate [Rowset]
canOpen
canRender
canSave
canSelChange
capitalization guidelines
CASE
   CASE
   DO CASE
    DO
CATCH
categories
CD
CDOW()
CEILING()
cellHeight
CENTER()
centering strings
CENTURY
   SET CENTURY
   SET EPOCH
    SET
CERROR()
CGI
    report output
CHANGE()
changedTableName
changes
   dBASE Plus release 2.0
   dBASE Plus release 2.2
   dBASE Plus release 2.5
   dBASE Plus release 2.6
   dBASE Plus release 2.61
   dBASE Plus release 2.61.1
   dBASE Plus release 2.61.2
   dBASE Plus release 2.61.3
   dBASE Plus release 2.61.4
   dBASE Plus release 2.61.5
   dBASE Plus release 2.62
   dBASE Plus Release 2.7.0.2
   dBASE Plus Release 2.70.3
   Overview of changes since Visual dBASE 7
    Overview of changes since Visual dBASE 7
    Overview of dBASE Plus release 2.0
    Overview of dBASE Plus release 2.2
    Overview of dBASE Plus release 2.5
    Overview of dBASE Plus release 2.6
    Overview of dBASE Plus release 2.61
    Overview of dBASE Plus release 2.61.1
    Overview of dBASE Plus release 2.61.2
    Overview of dBASE Plus release 2.61.3
    Overview of dBASE Plus release 2.61.4
    Overview of dBASE Plus release 2.61.5
    Overview of dBASE Plus release 2.62
    Overview of dBASE Plus Release 2.70.1
    Overview of dBASE Plus Release 2.70.2
    Overview of dBASE Plus Release 2.70.3
changing
    table structure
Character
character sets
   About character sets
   About language drivers
   Converting between OEM and ANSI Text
   Handling character incompatibilities in field names
   Identifying a table language driver and code page
   Overview: Character sets and language drivers
   Performing exact and inexact matches
   Using global language drivers
   Using table language drivers
   Using table language drivers versus global language drivers
characteristics
    language
characters
    and fonts
charAt()
charSet property
CHARSET() function
CheckBox class
CheckBox component
checkBoxes
checked
   checked
   checked [Menu]
checkedBitmap
checkedImage
child tables
   Defining referential integrity
   Referential integrity (overview)
Choose Class dialog box
Choose Field dialog box
Choose Resource Image dialog box
choosePrinter( )
choosePrinter()
   CHOOSEPRINTER()
   printer object
CHR() function
chr() method
CLASS
class ActiveX
class Array
class AssocArray
class Band
class Browse
class CheckBox
class ColumnCheckBox
class ColumnComboBox
class ColumnEditor
class ColumnEntryfield
class ColumnHeadingControl
class ColumnSpinBox
class ComboBox
class Container
class Database
class DataModRef
class DataModule
class Date
class DbError
class DbException
class DbfField
class DBFIndex
class DDELink
class DDETopic
class definition
class Designer
class Editor
class Entryfield
class Exception
class Field
class File
class Form
class Grid
class GridColumn
class Group
class hierarchy
   Data objects diagram
   Data objects: Class hierarchy
    data access objects
       Data objects diagram
       Data objects: Class hierarchy
Class ID Property Builder
class Image
class Index
class Line
class ListBox
class LockField
class Menu
class MenuBar
class NoteBook
class Object
class OLE
class OleAutoClient
class PageTemplate
class PaintBox
class Parameter
class PdxField
class Popup
class Progress
class PushButton
class Query
class RadioButton
class Rectangle
class Report
class ReportViewer
class Rowset
class ScrollBar
class Session
   class Session
   session property
class Shape
class Slider
class SpinBox
class SqlField
class StoredProc
class StreamFrame
class StreamSource
class String
class SubForm
class TabBox
class TableDef
class Text
class TextLabel
class Timer
class ToolBar
class ToolButton
class TreeItem
class TreeView
class UpdateSet
classes
   A simple class
   Arrays
   Choose Class dialog box
   Dynamic subclassing
   Functions and classes
   Literal arrays
   Methods
   Objects and classes
   Programming in dBL (introduction)
    and execution
    and objects
       A simple class
       Dynamic subclassing
       Methods
       Objects and classes
    array
       Arrays
       Literal arrays
    choosing
    example
    programming with
Classic
classId
className
CLEAR
CLEAR ALL
CLEAR AUTOMEM
CLEAR FIELDS
CLEAR MEMORY
CLEAR PROGRAM
CLEAR TYPEAHEAD
clearFilter()
clearRange()
clearTics()
clientEdge
close
CLOSE ALL
CLOSE ALTERNATE
CLOSE DATABASES
close forms
CLOSE INDEXES
CLOSE PRINTER
CLOSE PROCEDURE
CLOSE TABLES
close()
   close() [Database]
   close() [File]
   close() [Form]
closing dBASE Plus
CMD
CMONTH()
code
code block builder
   Events page of the Inspector
   The Code Block Builder (overview)
   To create or edit a codeblock
code blocks
   The Code Block Builder (overview)
   To create or edit a codeblock
    editing
       The Code Block Builder (overview)
       To create or edit a codeblock
code editor
   Source Editor [F1 context]
   Using the Source editor
code pages
   About character sets
   About language drivers
   Converting between OEM and ANSI Text
   Handling character incompatibilities in field names
   Identifying a table language driver and code page
   Using global language drivers
   Using table language drivers
   Using table language drivers versus global language drivers
code point
code signing
codeblock symbol
codeblocks and functions
   Codeblocks
   Codeblocks vs. functions
   Function pointers
   Functions and codeblocks
codePage
colon (symbol)
color
   DEFINE COLOR
   printer object
   Setting background color in reports
    DEFINE
    in reports
Color Property Builder
   Color Property Builder
   colorColumnLines
   colorNormal
   colorRowHeader
   colorRowLines
   colorRowSelect
colorColumnLines
colorHighlight
colorNormal
colorRowHeader
colorRowLines
colorRowSelect
colors
   DEFINE COLOR
   GETCOLOR()
    custom
colors (setting scheme)
ColumnCheckBox class
ColumnComboBox class
columnCount
columnEditor
ColumnEditor class
ColumnEntryfield class
ColumnHeadingControl class
columnNo
columns
   columns
   fontBold
   fontItalic
   fontName
   fontSize
   fontStrikeout
   fontUnderline
   headingColorNormal
   headingFontBold
   headingFontItalic
   headingFontName
   headingFontSize
   headingFontStrikeout
   headingFontUnderline
   Naming conventions
   Resizing columns
    Grid heading fonts and color
       headingColorNormal
       headingFontBold
       headingFontItalic
       headingFontName
       headingFontSize
       headingFontStrikeout
       headingFontUnderline
    Grid text fonts
       fontBold
       fontItalic
       fontName
       fontSize
       fontStrikeout
       fontUnderline
    moving and resizing (Table designer)
    naming (local SQL)
Columns Property Builder
ColumnSpinBox class
combining group criteria
ComboBox class
ComboBox component
COMMAND
   Command Line Switches
   CREATE COMMAND
    CREATE
Command Line Switches
Command window
   Command window [F1 context]
   Editing in the Command window
   The Command window
    clearing the panes
    copying to
    editing
    loading functions
    opening
Command Window Properties dialog box
commands
   Editing in the Command window
   The Command window
   Typing and executing commands
    copying
    executing
    executing blocks
    history
    issuing
    multiline
    printing
    reusing
    saving to programs
comment symbols
comments
COMMIT()
   commit()
   COMMIT() [Xbase]
common component properties
common control properties
compare numbers
   MAX()
   MIN()
    maximum
    minimum
comparison operators
COMPILE
complex expressions
Component palette
   Component palette overview
   To add custom components to the palette
   To remove custom components from the palette
    adding components
    removing components
component properties
    common
components
   ActiveX component
   Adding standard components to a report
   Administration
   Aligning components
   Browse component
   CheckBox component
   ComboBox component
   Component palette overview
   Configuring the dQuery/Web Server-Side Components
   Configuring your Web Server
   Container component
   Custom components (overview)
   Customizing the dQuery/Web Server-Side Components
   Cutting, copying, pasting, deleting components
   Data Access page
   Database component
   dQuery/Web Query (dataModule)
   dQuery/Web Server-Side Components (Overview)
   Editor component
   Entryfield component
   Grid component
   Group component
   HScrollBar component
   Image component
   Installation requirements
   Installing the dBASE Plus Runtime
   Line component
   ListBox component
   Moving components
   OLE component
   PaintBox component
   Placing components on a form or report
   Progress component
   PushButton component
   Query component
   RadioButton component
   Rectangle component
   Report page
   ReportViewer component
   Resizing components
   Run Data-Entry Application
   Run Report
   Selecting components
   Shape component
   Slider component
   Spacing components
   SpinBox component
   Standard page
   StoredProc component
   StreamFrame component
   TabBox component
   Text component
   TextLabel component
   To add custom components to the palette
   To create custom components
   To remove custom components from the palette
   TreeView component
   Using the dQuery/Web Server-Side Components
   Using the Field palette
   VScrollBar component
    aligning
    container components
    copying
    custom (adding to palette)
    custom (creating)
    custom (overview)
    custom (removing frompalette)
    cutting
    data access
    deleting
    field
    layout
       Aligning components
       Spacing components
    moving
    pasting
    placing
    placing in containers
    reports
    reports (table)
    resizing
    selecting
    selecting multiple
    spacing
    table access
    user interface standard components (table)
    Web
       Administration
       Configuring the dQuery/Web Server-Side Components
       Configuring your Web Server
       Customizing the dQuery/Web Server-Side Components
       dQuery/Web Query (dataModule)
       dQuery/Web Server-Side Components (Overview)
       Installation requirements
       Installing the dBASE Plus Runtime
       Run Data-Entry Application
       Run Report
       Using the dQuery/Web Server-Side Components
    working with TextLabel
    working with ActiveX
    working with Browse
    working with CheckBox
    working with ComboBox
    working with Container
    working with Database
    working with Editor
    working with Entryfield
    working with Grid
    working with Group
    working with HScrollBar
    working with Image
    working with Line
    working with ListBox
    working with OLE
    working with PaintBox
    working with Progress
    working with PushButton
    working with Query
    working with RadioButton
    working with Rectangle
    working with ReportViewer
    working with Shape
    working with Slider
    working with SpinBox
    working with StoredProc
    working with StreamFrame
    working with TabBox
    working with Text
    working with TreeView
    working with VScrollBar
configuring BDE
CONFIRM
    SET
connecting
    connecting to databases
CONSOLE
    SET
constrained
constraints
    local SQL
Container class
Container component
container components
context
   class DbError
   context
contextHelp
continuation symbol
CONTINUE
control statements
control types (field components)
controls
   Choose Field Dialog Box
   Common visual component properties
   Component palette overview
   RadioButton component
   Standard page
    common properties
    grouping
    linking to fields
    user interface standard controls (table)
conventions
   Names
   Naming conventions
   Syntax conventions
    names
    naming
    syntax
CONVERT
converting
   + operator
   ABS()
   ASC() function
   asc() method
   Automatic type conversion
   CEILING()
   CHR() function
   chr() method
   class Date
   Converting between OEM and ANSI Text
   Converting Project Files from earlier versions
   CTOD()
   CTODT()
   CTOT()
   DTOC()
   DTOR()
   DTOS()
   DTTOC()
   DTTOD()
   DTTOT()
   Explicit type conversion
   FLOOR()
   INT()
   LOWER()
   PROPER()
   ROUND()
   RTOD()
   SOUNDEX()
   STR()
   toGMTString()
   toLocaleString()
   toLowerCase()
   toProperCase()
   toString()
   toUpperCase()
   TTOC( )
   Type conversion
   UPPER()
   VAL()
    all types to string
    ASCII value to character
       CHR() function
       chr() method
    automatic type conversion
    character to ASCII value
       ASC() function
       asc() method
    date to string
       DTOC()
       DTOS()
       toGMTString()
       toLocaleString()
       toString()
    datetime to date
    datetime to string
    datetime to time
    degrees to radians
    earlier version project files
    explicit type conversion
    number to absolute value
    number to integer
       CEILING()
       FLOOR()
       INT()
       ROUND()
    number to string
    OEM and ANSI text
    radians to degrees
    string to date
       class Date
       CTOD()
    string to datetime
    string to lowercase
       LOWER()
       toLowerCase()
    string to number
    string to proper case
       PROPER()
       toProperCase()
    string to sound-alike
    string to time
    string to uppercase
       toUpperCase()
       UPPER()
    time to string
    type conversion
Converting dBASE 5.0 for DOS Screens/Menus to dBASE Plus
   Conversion considerations
   Converting reports and labels
   Converting screens and menus
   Setting up for Conversion
    considerations
    reports and labels
    screens and menus
    set up
Converting dBASE III+/IV applications to Visual Basic 5.7
   Converting .VUE files
   Converting a dBASE III+/IV Application to Visual dBASE 5.7 (overview)
   Converting Forms
   Fine tuning the Form
   Notes about Memo and Logical fields
   Recreating menus
   Reports and Labels
   Using ACCEPT or INPUT
    .VUE files
    Fine tuning the Form
    forms
    memo and logical fields
    overview
    recreating menus
    reports and labels
    using ACCEPT or INPUT
Converting prior version applications to dBASE Plus
   Conversion considerations
   Converting .QBE files to dataModules
   Converting .VUE files
   Converting a dBASE III+/IV Application to Visual dBASE 5.7 (overview)
   Converting applications (overview)
   Converting Forms
   Converting reports and labels
   Converting screens and menus
   Converting Visual dBASE 5.7 Applications to dBASE Plus (Overview)
   Converting Visual dBASE 5.7 Forms to dBASE Plus
   Converting Visual dBASE 5.7 Reports and Labels to dBASE Plus
   Fine tuning the Form
   Installing dBASE 5.7
   Notes about Memo and Logical fields
   Recreating menus
   Reports and Labels
   Setting up for Conversion
   Updating forms to use dataModules
   Using ACCEPT or INPUT
    Converting dBASE III+/IV applications to Visual dBASE 5.7
       Converting .VUE files
       Converting a dBASE III+/IV Application to Visual dBASE 5.7 (overview)
       Converting Forms
       Fine tuning the Form
       Notes about Memo and Logical fields
       Recreating menus
       Reports and Labels
       Using ACCEPT or INPUT
    dBASE 5.0 for DOS Screens/Menus
       Conversion considerations
       Converting reports and labels
       Converting screens and menus
       Setting up for Conversion
    Installing dBASE 5.7
    Overview
    Recreating menus (dBASE III+/IV)
    Visual dBASE 5.7 applications
       Converting .QBE files to dataModules
       Converting Visual dBASE 5.7 Applications to dBASE Plus (Overview)
       Converting Visual dBASE 5.7 Forms to dBASE Plus
       Converting Visual dBASE 5.7 Reports and Labels to dBASE Plus
       Updating forms to use dataModules
Converting Visual dBASE 5.7 applications to dBASE Plus
   Converting .QBE files to dataModules
   Converting Visual dBASE 5.7 Applications to dBASE Plus (Overview)
   Converting Visual dBASE 5.7 Forms to dBASE Plus
   Converting Visual dBASE 5.7 Reports and Labels to dBASE Plus
   Updating forms to use dataModules
    .QBE files to dataModules
    forms
    overview
    reports
    updating forms to use dataModules
copies
COPY
COPY BINARY
COPY FILE
COPY MEMO
COPY STRUCTURE
COPY STRUCTURE EXTENDED
COPY TABLE
COPY TO ARRAY
copy()
   copy() [File]
   copy() [Form]
   copy() [UpdateSet]
copying data
    local SQL
copying records
    local SQL
copyTable()
copyToFile()
COS()
cosine
count
   COUNT [Xbase]
   Performing aggregate (summary) calculations
    finding in reports
Count Rows dialog box
count()
   Aggregate functions [Local SQL]
   count() [AssocArray]
   count() [Listbox, TreeView]
   count() [Rowset]
counting rows
COVERAGE
   DISPLAY COVERAGE
   SET COVERAGE
    DISPLAY
    SET
CREATE
   CREATE
   Making an Application UAC compatible
CREATE COMMAND
CREATE DATAMODULE
CREATE FILE
CREATE FORM
CREATE INDEX
CREATE LABEL
CREATE MENU
CREATE POPUP
CREATE PROJECT
CREATE QUERY
CREATE REPORT
CREATE SESSION
CREATE TABLE
   CREATE TABLE
   Data type mappings for CREATE TABLE
create()
CREATE...FROM
CREATE...STRUCTURE EXTENDED
createDate()
createIndex()
createTime()
creating
   Creating a custom form, report, or data module class
   Creating a DEO Application
   Creating a form
   Creating a new method
   Creating a simple index
   Creating an application (basic steps)
   Creating an application (introduction)
   Creating an Application (Project Explorer)
   Creating complex indexes for dBASE tables
   Creating joins (SQL designer)
   Creating primary indexes
   Creating secondary indexes
   Creating the dBASE complex index
   Custom components (overview)
   Data Module designer
   dBASE index concepts
   Inno (overview)
   Label designer
   Project files (overview)
   Report designer [F1 context]
   Report designer elements (overview)
   Report wizard (overview and use)
   Rules for dBASE complex indexes
   Setting up your DBF table security system
   Table designer
   To create a dataModule
   To create a project file
   To create custom components
   Using the Form designer
   Using the Form wizard
   Using the Table designer
   Using the Table wizard
    applications (basic steps)
    applications (introduction)
    applications in Project Explorer
    custom classes
    custom components
    custom components (overview)
    data modules
       Data Module designer
       To create a dataModule
    DEO application
    forms
       Creating a form
       Using the Form designer
       Using the Form wizard
    indexes
       Creating a simple index
       Creating complex indexes for dBASE tables
       Creating primary indexes
       Creating secondary indexes
       Creating the dBASE complex index
       dBASE index concepts
       Rules for dBASE complex indexes
    installer
    joins (queries)
    labels
    methods
    projects
       Project files (overview)
       To create a project file
    reports
       Report designer [F1 context]
       Report designer elements (overview)
       Report wizard (overview and use)
    security schemes
    tables
    tables (in designer)
    tables (with wizard)
criteria page (SQL designer)
CTOD()
CTODT()
CTODT() example
CTOT()
CUAENTER
    SET
cuaTab
CURRENCY
    SET
current directory
currentColumn
currentUserPath
curSel
cursor position
    debugging to
CUSTOM
custom class designers
custom classes
   Creating a custom form, report, or data module class
   Using a custom class
    creating
    using
custom colors
custom components
   Custom components (overview)
   To add custom components to the palette
   To create custom components
   To remove custom components from the palette
    adding to palette
    creating
    creating (overview)
    removing from palette
custom components (Component palette)
Customize Tool Windows dialog box
   Customize Tool Windows dialog box
   Customize Tool Windows dialog box (Component Palettes)
   Customize Tool Windows dialog box (Field palettes)
   Customize Tool Windows dialog box (Inspector page)
customizing development environment
cut()

>>