Adding rows to a table
Data Access page
FROM clause
GROUP BY clause
HAVING clause
ORDER BY clause
SAVE TO clause
SELECT [Local SQL]
UNION clause
UPDATE [Local SQL]
WHERE clause
FROM clause
GROUP BY clause
HAVING clause
ORDER BY clause
SELECT [Local SQL]
UNION clause
WHERE clause
Defining referential integrity
Entryfield component
Specifying data-entry constraints
Using indexes in data entry
Database objects
DataModRef objects
Field objects
Query objects
Rowset objects
Session objects
StoredProc objects
The dBASE data model (introduction)
Data Module designer
Using the Form and Report designers (overview)
Data Module designer
DataModRef objects
To create a dataModule
To use a dataModule
What is a dataModule?
Data objects diagram
Data objects overview
Data objects: Class hierarchy
Database component
Query component
Session component
StoredProc component
Binary and OLE data
Data types
Database-specific data types
Date data
Logical data
Memo data
Null values
Numeric data
Programming data types
Simple data types
String data
database property
OPEN DATABASE
SET DATABASE
Accessing and linking tables (overview)
Calling a stored procedure
class Database
CLOSE DATABASES
Data Access page
databases property
How to connect to an SQL database server
Linking a form or report to tables (overview)
Linking to a table automatically
Linking to a table manually
Procedure for using a Session object
Supported table types
Accessing and linking tables (overview)
Calling a stored procedure
class Database
Procedure for using a Session object
Field objects
Using the Field palette
dataSource [Image]
dataSource [options]
DataSource Property Builder
DataSource/Image Property Builder
Date and time overview
DATE( ) function
SET DATE
toGMTString()
toLocaleString()
toString()
date( ) [File]
DATE( ) function
DAY( )
getDate()
setDate()
DOW()
getDay()
dBASE Plus documentation
Introducing dBASE Plus!
Language definition overview
What is dBASE Plus?
Hard coding vs. visual programming
Programming in dBL (introduction)
DEBUG command
Docking the Debugger tool windows
Stepping in the Debugger
Using the Debugger (introduction)
Viewing and using the Call Stack
Controlling program execution
Debugging event handlers
Debugging runtime applications
Everything else (except Preprocessor) overview
General debugging procedure
Running a program at full speed from the Debugger
The Debugger tool windows
The Source window (debugger)
Types of bugs
Using breakpoints
Using the Debugger (introduction)
Watching expressions
Working with breakpoints
SET DECIMALS
User-interface elements in the Table designer
default [Field]
default [Form]
DELETE [Local SQL]
DELETE [Xbase]
delete() [Array]
delete() [File]
delete() [Rowset]
delete() [UpdateSet]
Deleting columns (fields) from a report
Deleting fields
Deleting rows
Removing an OLE object from an OLE field
To remove custom components from the palette
Creating a DEO Application
Dynamic External Objects (DEO)
Data Module designer
Design and Run modes
Form designer
Label designer
Menu/Popup designers
Report designer [F1 context]
Table designer
The designer windows
Undoing and redoing in the designers
Using the Form designer
Choosing index fields
Classifying information
Defining individual fields
Designing tables in dBASE Plus (introduction)
Determining relationships among tables
Field types
Form designer
Identifying the information to store
Menu/Popup designers
Minimizing redundancy
Table designer fields
Table names and types
Terms and concepts
Using the Form and Report designers (overview)
Using the Table designer
Using the Table wizard
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
Using the Table designer
Desktop Properties dialog box, Application page
Desktop Properties dialog box, Country page
Desktop Properties dialog box, Data Entry page
Desktop Properties dialog box, Files page
Desktop Properties dialog box, Programming page
Desktop Properties dialog box, Table page
Add Table dialog box
Administrator Password dialog box
Alias Property Builder
Associate component types dialog box
Breakpoint Condition dialog box
Breakpoints dialog box
Build Array dialog box
Build Codeblock dialog box
Calculate Aggregates dialog box
Calculated Field dialog box
Choose Class dialog box
Choose Resource Image dialog box
Class ID Property Builder
Color Property Builder
Columns Property Builder
Command window Properties dialog box [Results Pane]
Count Rows 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)
DataLink Property Builder
DataSource Property Builder
DataSource/Image Property Builder
dBASE Plus Login Dialog Box
Debugger Properties dialog box
Define Index dialog box
Define Primary Key dialog box
Define Referential Integrity Rule dialog box
Define ReportViewer Params dialog box
Define User Dialog Box
Delete Rows dialog box
Desktop Properties dialog box, Application page
Desktop Properties dialog box, Country page
Desktop Properties dialog box, Data Entry page
Desktop Properties dialog box, Files page
Desktop Properties dialog box, Programming page
Desktop Properties dialog box, Table page
Edit Event dialog box
Edit Table Privileges dialog box (DBF tables)
Editor Properties dialog box, Appearance Page
Editor Properties dialog box, Editor Page
Editor Properties dialog box, Font Page
Error dialog box
Field Properties dialog box
Fields Property Builder
File Item Properties dialog box (Navigator)
File Properties dialog box (Project Explorer)
Find Rows dialog box
Find Text dialog box
Folder Properties dialog box
Font Property Builder
Form Designer Properties dialog box
Go To Form Page dialog box
Go To Line dialog box
Icon Property Builder
Label Designer Properties dialog box
Label Designer Properties dialog box [F1 context]
Layout|Set Component Order dialog box
Link Event dialog box
Manage Indexes dialog box
Navigator Properties dialog box
New Folder dialog box
New Project dialog box
PaperSize Property Builder dialog box
PaperSource Property Builder dialog box
Print dialog box
Project Properties dialog box
Query Parameter Property Builder dialog box
Referential Integrity Rules dialog box
Replace Rows dialog box
Replace Text dialog box
Report Designer Properties dialog box
ReportViewer Params Property Builder
Save as Custom dialog box
Scheme Name dialog box
Security (DB) dialog box
Security dialog box, Enforcement page
Security dialog box, Tables page
Security dialog box, Users page
Set Custom Data Module Class dialog box
Set Custom Form Class dialog box
Set Custom Report Class dialog box
Set Label Type dialog box
Set Scheme dialog box
Set Up ActiveX Components dialog box
Set Up Custom Components dialog box
Sort Rows dialog box
SQL Property Builder dialog box
Stored Procedure Parameter Property Builder dialog box
String Builder dialog box
Template Property Builder, Character page
Template Property Builder, Date page
Template Property Builder, Numeric page
Unlink dialog box
UpBitmap Property Builder
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)
DataSource Property Builder
DataSource/Image Property Builder
Desktop Properties dialog box, Application page
Desktop Properties dialog box, Country page
Desktop Properties dialog box, Data Entry page
Desktop Properties dialog box, Files page
Desktop Properties dialog box, Programming page
Desktop Properties dialog box, Table page
Editor Properties dialog box, Appearance Page
Editor Properties dialog box, Editor Page
Editor Properties dialog box, Font Page
Label Designer Properties dialog box
Label Designer Properties dialog box [F1 context]
Security dialog box, Enforcement page
Security dialog box, Tables page
Security dialog box, Users page
Template Property Builder, Character page
Template Property Builder, Date page
Template Property Builder, Numeric page
Text component
TextLabel component
LOAD DLL
RELEASE DLL
Data manipulation
Parameter substitutions in DML statements
allowDrop
drag()
dragEffect
onDragBegin
onDragEnter
onDragLeave
onDragOver
onDrop
onDragEnter
onDragLeave
onDragOver
onDrop
About character sets
About language drivers
Converting between OEM and ANSI Text
Determining the language displayed by the User Interface
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
About character sets
About language drivers
Converting between OEM and ANSI Text
Determining the language displayed by the User Interface
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
class ActiveX
class Browse
class CheckBox
class ComboBox
class Container
class Editor
class Entryfield
class Grid
class Image
class Line
class ListBox
class NoteBook
class OLE
class PaintBox
class Progress
class PushButton
class RadioButton
class Rectangle
class ReportViewer
class ScrollBar
class Shape
class Slider
class SpinBox
class TabBox
class Text
class TextLabel
class TreeItem
class TreeView
class Browse
class Container
class Form
class Grid
class Image
class ListBox
class NoteBook
class PaintBox
class ReportViewer
class SubForm
class TreeView