PC Pro 1998 October/DPPCPRO1098.ISO/Help/PDOX.CNT

Microsoft Windows Help File Content | 1995-12-04 | 102.4 KB | 1,975 lines

:Base pdox.hlp>main
1 What's new
2 What's new in Paradox 7=nwhatnew_intro
2 Expert enhancements=nwhatnew_expert
2 Property and preference enhancements=nwhatnew_property_preference
2 Toolbar enhancements=nwhatnew_toolbar
2 Menu enhancements=nwhatnew_menu
2 File-handling enhancements=nwhatnew_file_handling
2 Tool enhancements=nwhatnew_tool
2 MAPI mail support=nwhatnew_mail
2 Online Help enhancements=nwhatnew_help
2 Developer environment enhancements=nwhatnew_developer
2 SQL enhancements=nwhatnew_sql
1 Essentials
2 Understanding database concepts
3 Introduction to Paradox=bunder_introduction
3 What is a relational database?=bunder_what_is_relational
3 Example of a relational database=bunder_example_relational
3 Understanding keys and indexes
4 About keys and indexes=bunder_about_keys_indexes
4 Keys=bunder_keys
4 Composite keys=bunder_composite_keys
4 Indexes=bunder_indexes
3 Understanding links
4 About links=bunder_about_links
3 The MAST company: a case study
4 About the MAST company example=bunder_about_mast
4 Stage one: a single table=bunder_mast_single_table
4 Stage two: the need for a key=bunder_mast_need_key
4 Stage three: organizing smaller tables
5 Stage three: organizing smaller tables=bunder_mast_organizing_smaller_tables
5 The Customer table=bunder_mast_customer_table
5 The Orders table=bunder_mast_orders_table
5 The Lineitem table=bunder_mast_lineitem_table
5 The Stock table=bunder_mast_stock_table
5 The Vendors table=bunder_mast_vendors_table
5 The Contacts table=bunder_mast_contacts_table
4 Stage four: creating multi-table documents
5 Stage four: creating multi-table documents=bunder_mast_multi_table
4 Stage five: creating and saving queries
5 Stage five: creating and saving queries=bunder_mast_queries
4 Stage six: creating a report from a query
5 Stage six: creating a report from a query=bunder_mast_report
2 Paradox basics
3 Paradox objects
4 About Paradox objects=bbasics_about_paradox_objects
4 Tables=bbasics_tables
4 Temporary tables=bbasics_temporary_tables
4 Forms=bbasics_forms
4 Reports=bbasics_reports
4 Queries=bbasics_queries
4 Scripts=bbasics_scripts
4 Libraries=bbasics_libraries
4 SQL Files=bbasics_sql_files
4 File extensions for Paradox objects=bbasics_file_extensions
3 The Paradox Desktop and Project Viewer
4 About the Paradox Desktop=bbasics_about_desktop
4 Desktop and child windows=bbasics_desktop_and_child
4 Object icons=bbasics_object_icons
4 Toolbars
5 About Toolbars=bbasics_about_toolbars
5 To move and dock Toolbars=bbasics_to_move_toolbar>taskwin
5 To display additional Toolbars=bbasics_to_display_additional_toolbar>taskwin
5 Dialog boxes
6 Toolbars page (Preferences dialog box)=idh_dial_preftoolbars
4 The Desktop status bar
5 About the Desktop status bar=bbasics_desktop_status_bar
4 The Project Viewer
5 About the Project Viewer=bbasics_about_project_viewer
5 To use the Project Viewer=bbasics_to_use_project_viewer>taskwin
5 To set Project Viewer preferences=bbasics_to_set_project_viewer_preferences>taskwin
5 To display a menu for Project Viewer items=bbasics_to_display_project_viewer_menu>taskwin
5 To change your working directory from the Project Viewer=bbasics_to_change_working_directory_project_viewer>taskwin
5 To add and remove Project Viewer items
6 About adding and removing Project Viewer items=bbasics_adding_removing_project_viewer_items
6 To add references=bbasics_to_add_references>taskwin
6 To remove references=bbasics_to_remove_references>taskwin
5 Dialog boxes
6 The Project Viewer=idh_dial_projview
6 Select File dialog box=idh_dial_selfile
4 System and ObjectPAL preference settings
5 About Paradox preferences=bbasics_about_preferences
5 Desktop and system preferences
6 To set Desktop and system preferences=bbasics_to_set_system_preferences>taskwin
6 Dialog boxes
7 General page (Preferences dialog box)=idh_dial_prefgeneral
7 Forms/Reports page (Preferences dialog box)=idh_dial_formrep_pref
7 Designer page (Preferences dialog box)=idh_dial_prefdesign
7 Query page (Preferences dialog box)=idh_dial_prefquery
7 Toolbars page (Preferences dialog box)=idh_dial_preftoolbars
7 Experts page (Preferences dialog box)=idh_dial_prefexperts
7 Advanced page (Preferences dialog box)=idh_dial_advprop
7 Database page (Preferences dialog box)=idh_dial_prefdatabase
7 BDE page (Preferences dialog box)=idh_dial_sysinf
5 ObjectPAL preferences
6 To set ObjectPAL preferences=bbasics_to_set_opal_preferences>taskwin
6 Dialog boxes
7 General page (Developer Preferences dialog box)=idh_dial_devprefgeneral
7 Explorer page (Developer Preferences dialog box)=idh_dial_devprefexplorer
7 Editor page (Developer Preferences dialog box)=idh_dial_devprefeditor
7 Display page (Developer Preferences dialog box)=idh_dial_devprefdisplay
7 Colors page (Developer Preferences dialog box)=idh_dial_devprefcolors
4 Exiting Paradox
5 To exit Paradox=bbasics_to_exit_paradox>taskwin
3 Directories and aliases
4 About directories and aliases=bbasics_about_directories_aliases
4 Working directories
5 To change your working directory=bbasics_to_change_working_directory>taskwin
5 To change your working directory from the Project Viewer=bbasics_to_change_working_directory_project_viewer>taskwin
4 Private directories
5 To specify a private directory=bbasics_to_specify_private>taskwin
4 Aliases
5 About aliases=bbasics_about_aliases
5 Public and project aliases=bbasics_public_project_aliases
5 To create a new alias=bbasics_to_create_new_alias>taskwin
5 To modify an alias=bbasics_to_modify_alias>taskwin
5 To remove an alias=bbasics_to_remove_alias>taskwin
4 Dialog boxes
5 Set Working Directory dialog box=idh_dial_setwork
5 Alias Manager dialog box=idh_desk_dbdbx
3 Manipulating objects
4 About manipulating objects=bbasics_about_manipulating_objects
4 Manipulating and selecting with the mouse
5 To manipulate objects directly with the mouse=bbasics_to_manipulate_mouse>taskwin
5 To select objects with the mouse=bbasics_to_select_mouse>taskwin
5 To select from lists=bbasics_to_select_lists>taskwin
4 Opening and browsing objects
5 About using common dialog boxes=bbasics_about_common
5 About the Directory Browser=bbasics_common_directory_browser
5 About browsing files=bbasics_common_file_browsing
4 Navigating within objects
5 About navigating and editing=bbasics_about_navigating_editing
5 Table and form navigation buttons=tview_table_navigation_buttons
4 Saving objects
5 About saving Paradox objects=bbasics_about_saving_objects
5 To save table data and properties=bbasics_to_save_data_properties>taskwin
5 To save forms, reports, and other files=bbasics_to_save_forms_reports_other>taskwin
5 To save a file under a different name=bbasics_to_save_different_name>taskwin
5 Dialog boxes
6 Save File As dialog box=idh_dial_seldir
4 Copying objects
5 About copying objects=bbasics_about_copying
5 Copying on a network=bbasics_copying_on_network
5 Copying referential integrity=bbasics_copying_referential_integrity
5 To copy objects=bbasics_to_copy>taskwin
5 Copying to a different table type
6 Copying to a different table type=bbasics_copying_different_type
6 Copying from Paradox to dBASE tables=bbasics_copying_Paradox_to_dBASE
6 Copying from dBASE to Paradox tables=bbasics_copying_dBASE_to_Paradox
5 Examples
6 Example of copying a form=bbasics_copying_example_form
5 Dialog boxes
6 Copy dialog box=idh_dial_tcopy
6 Copy <file name> To dialog box=idh_dial_copy_table_to
4 Renaming objects
5 About renaming objects=bbasics_about_renaming_objects
5 Rules for renaming objects=bbasics_rules_renaming
5 Renaming tables on a network=bbasics_rename_on_network
5 To rename objects=bbasics_to_rename>taskwin
5 Dialog boxes
6 Rename dialog box (tables)=idh_dial_trename
6 Rename dialog box (objects)=idh_dial_trena
6 Rename <file name> To dialog box=idh_dial_rename_object_to
4 Deleting objects
5 About deleting objects=bbasics_about_deleting
5 Deleting tables on a network=bbasics_delete_on_network
5 To delete an object=bbasics_to_delete>taskwin
5 Dialog boxes
6 Delete dialog box
4 Changing object properties
5 To change an object's properties=bbasics_to_change_properties>taskwin
5 To change penetrating properties=fobjects_change_penetrating_properties>taskwin
3 Paradox Help and Experts
4 About the Help system=bbasics_about_help
4 About Paradox Experts=bbasics_about_experts
3 Other important features
4 Data models=fdatamod_about_data_models
4 Printing=bbasics_printing
4 Paradox sample directory=bbasics_paradox_sample_directory
4 ObjectPAL scripting language=bbasics_opal_scripting
4 OLE and DDE=eole_about_ole_dde
4 SQL access=idh_sql_intr
1 Tables
2 Creating tables
3 Designing tables
4 About creating tables=tcreate_about_create
4 Guidelines for creating tables=tcreate_guidelines_create
4 To create a simple table=tcreate_to_create_table>taskwin
4 Creating an SQL table=idh_tsql_create
4 Dialog boxes
5 Create Table dialog box=idh_dial_type
5 Create Paradox Table dialog box=idh_dial_crea
5 Create dBASE Table dialog box=idh_dial_dcrea
5 Create INTRBASE Table dialog box=idh_dial_ibcrea
5 Create INFORMIX Table dialog box=idh_dial_ixcrea
5 Create ORACLE Table dialog box=idh_dial_orcrea
5 Create SYBASE Table dialog box=idh_dial_sycrea
5 Create Table dialog box (other SQL)=idh_dial_sqlcrea
5 Save Table As dialog box=idh_dial_savtablas
3 Defining fields
4 Rules for Paradox field names=tcreate_paradox_field_name_rules
4 Rules for dBASE field names=tcreate_dbase_field_name_rules
4 To create a field=tcreate_to_create_field>taskwin
4 Field types and sizes
5 Paradox
6 Paradox field types and sizes=tcreate_paradox_field_types
6 Paradox alpha fields=tcreate_paradox_alpha
6 Paradox number field=tcreate_paradox_number
6 Paradox money fields=tcreate_paradox_money
6 Paradox short fields=tcreate_paradox_short
6 Paradox long Integer fields=tcreate_paradox_long
6 Paradox BCD fields=tcreate_paradox_bcd
6 Paradox date fields=tcreate_paradox_date
6 Paradox time fields=tcreate_paradox_time
6 Paradox timestamp fields=tcreate_paradox_timestamp
6 Paradox memo fields=tcreate_paradox_memo
6 Paradox formatted memo fields=tcreate_paradox_formatted_memo
6 Paradox graphic fields=tcreate_paradox_graphic
6 Paradox OLE fields=tcreate_paradox_ole
6 Paradox logical  fields=tcreate_paradox_logical
6 Paradox autoincrement fields=tcreate_paradox_autoincrement
6 Paradox binary fields=tcreate_paradox_binary
6 Paradox bytes fields=tcreate_paradox_bytes
5 dBASE
6 dBASE field types and sizes=tcreate_dbase_field_types
6 dBASE character fields=tcreate_dbase_character
6 dBASE float fields=tcreate_dbase_float
6 dBASE number fields=tcreate_dbase_number
6 dBASE date fields=tcreate_dbase_date
6 dBASE logical fields=tcreate_dbase_logical
6 dBASE memo fields=tcreate_dbase_memo
6 dBASE OLE fields=tcreate_dbase_ole
6 dBASE binary fields=tcreate_dbase_binary
6 dBASE record lock fields=tcreate_dbase_record_lock
3 Indexes
4 About keys and indexes in tables=tcreate_about_indexes
4 Paradox tables
5 Primary indexes
6 About primary indexes (key fields)=tcreate_about_primary
6 Rules for defining key fields=tcreate_rules_key
6 The effect of restructuring tables on key fields=tcreate_effect_restructuring
6 Composite key fields=tcreate_composite
6 To create a key=tcreate_to_create_key>taskwin
6 To remove a key=tcreate_to_remove_key>taskwin
5 Secondary indexes
6 About secondary indexes=tcreate_about_secondary
6 Types of secondary indexes=tcreate_types_secondary
6 To create secondary indexes=tcreate_to_create_secondary>taskwin
6 To modify a secondary index=tcreate_to_modify_secondary>taskwin
6 To delete a secondary index=tcreate_to_delete_secondary>taskwin
6 Composite indexes
7 About composite secondary indexes=tcreate_about_composite_secondary
7 To create a composite secondary index=tcreate_to_create_composite_secondary>taskwin
7 To add a field to a composite secondary index=tcreate_to_add_field_composite_secondary>taskwin
7 To remove a field from a composite secondary index=tcreate_to_remove_field_composite_secondary>taskwin
7 To rearrange fields in a composite secondary index=tcreate_to_rearrange_fields_composite_secondary>taskwin
6 Dialog boxes
7 Define Secondary Index dialog box (Paradox tables)=idh_dial_defpdndx
7 Save Index As dialog box (Paradox tables)=idh_dial_savndxas
4 dBASE tables
5 About dBASE indexes=tcreate_about_dbase_indexes
5 Maintained dBASE indexes=tcreate_maintained_dbase_indexes
5 Creating a dBASE expression index=tcreate_creating_dbase_expression_index
5 Creating a subset condition expression=tcreate_creating_subset_condition
5 To create an index on a dBASE table=tcreate_to_create_dbase_index>taskwin
5 Dialog boxes
6 Define Index dialog box (dBASE tables)=idh_dial_defdbndx
6 Save Index As dialog box (dBASE tables)=idh_dial_savdbndx
4 SQL tables
5 Creating indexes on SQL tables=idh_tsql_createindex
5 Dialog boxes
6 Define Index dialog box (SQL tables)=idh_dial_defsqlndx
6 Save Index As dialog box (SQL tables)=idh_dial_savsqlnx
3 Borrowing an existing table structure
4 About borrowing structures=tcreate_about_borrowing
4 To borrow a table structure=tcreate_to_borrow>taskwin
4 Dialog boxes
5 Select Borrow Table dialog box=idh_tablt_borr
3 Validity checks
4 About validity checks=tcreate_about_validity_checks
4 To create validity checks=tcreate_to_create_validity_checks>taskwin
4 To view validity checks=tcreate_to_view_validity_checks>taskwin
4 To remove a validity check=tcreate_to_remove_validity_checks>taskwin
4 Example of creating validity checks=tcreate_example_validity_checks>codewin
4 Types of validity checks
5 Required fields
6 About required fields=tcreate_about_required_fields
6 To create required fields=tcreate_to_create_required_fields>taskwin
5 Minimum and maximum values
6 About minimum and maximum values=tcreate_about_minimum_maximum
6 To create minimum and maximum values=tcreate_to_create_minimum_maximum>taskwin
5 Default values
6 About default values=tcreate_about_default_values
6 To create default values=tcreate_to_create_default_values>taskwin
5 Picture patterns
6 About pictures=tcreate_about_pictures
6 Picture string characters=tcreate_picture_characters
6 Examples of pictures=tcreate_examples_pictures
6 To use standard pictures=tcreate_to_use_standard_pictures>taskwin
6 To create custom pictures=tcreate_to_use_custom_pictures>taskwin
6 Dialog boxes
7 Picture Assistance dialog box=idh_dial_assist
3 Table lookups
4 About table lookups=tcreate_about_lookups
4 Rules for table lookups=tcreate_lookup_rules
4 To create table lookups=tcreate_to_create_lookups>taskwin
4 Dialog boxes
5 Table Lookup dialog box=idh_tablt_look
3 Referential integrity
4 About referential integrity=tcreate_about_referential_integrity
4 Referential integrity and indexes=tcreate_referential_integrity_indexes
4 Self-referential integrity=tcreate_self_referential_integrity
4 Referential integrity guidelines=tcreate_referential_integrity_guidelines
4 To create referential integrity=tcreate_to_create_referential_integrity>taskwin
4 To change referential integrity=tcreate_to_change_referential_integrity>taskwin
4 To delete referential integrity=tcreate_to_delete_referential_integrity>taskwin
4 Dialog boxes
5 Referential Integrity dialog box=idh_dial_refe
5 Save Referential Integrity As dialog box=idh_dial_savrefas
3 Password security
4 About password security=tcreate_about_passwords
4 Using passwords=tcreate_using_passwords
4 Master passwords
5 To create a master password=tcreate_to_create_master_password>taskwin
5 To change a master password=tcreate_to_change_master_password>taskwin
5 To delete a master password=tcreate_to_delete_master_password>taskwin
4 Auxiliary passwords
5 About auxiliary passwords=tcreate_about_auxiliary_passwords
5 To create an auxiliary password=tcreate_to_create_auxiliary_password>taskwin
5 To change an auxiliary password=tcreate_to_change_auxiliary_password>taskwin
5 To delete an auxiliary password=tcreate_to_delete_auxiliary_password>taskwin
4 Dialog boxes
5 Password Security dialog box=idh_tablt_passwddbx
5 Auxiliary Passwords dialog box=idh_tablt_auxpass
5 Enter Password(s) dialog box=idh_desk_enterpass
3 Table language drivers
4 About table language drivers=tcreate_about_table_languages
4 To choose a table language driver=tcreate_to_choose_table_language>taskwin
4 Dialog boxes
5 Table Language dialog box=idh_dial_tabllang
2 Restructuring tables
3 About restructuring tables=trestruc_about_restructuring
3 Restructuring on a network=trestruc_restructuring_network
3 Restructure warnings=trestruc_restructure_warnings
3 Temporary tables created when restructuring=trestruc_temporary_tables
3 Rules for restructuring=trestruc_restructure_rules
3 The effect of restructuring tables on key fields=tcreate_effect_restructuring
3 To restructure a table=trestruc_to_restructure_table>taskwin
3 Restructuring an SQL table=idh_tsql_restructure
3 Types of restructuring
4 Shortening fields=trestruc_shortening_fields
4 Deleting fields=trestruc_deleting_fields
4 Rearranging fields=trestruc_rearranging_fields
4 Converting a non-keyed field to a keyed field=trestruc_converting_non_keyed
4 Packing a table=trestruc_packing_table
4 To add fields=trestruc_to_add_fields>taskwin
4 To delete fields=trestruc_to_delete_fields>taskwin
4 To rename fields=trestruc_to_rename_fields>taskwin
4 To change validity checks=trestruc_to_change_validity_checks>taskwin
4 To change table lookup=trestruc_to_change_table_lookup>taskwin
4 To change secondary indexes=trestruc_to_change_secondary_indexes>taskwin
4 To change password security=trestruc_to_change_password_security>taskwin
4 To change table languages=trestruc_to_change_table_languages>taskwin
4 Changing field types
5 To change field types=trestruc_to_change_field_types>taskwin
5 Paradox tables
6 Compatible Paradox field types=trestruc_compatible_paradox_field_types
6 Alpha field conversions=trestruc_alpha_conversions
6 Number, money, short, and long integer field conversions=trestruc_number_conversions
6 Autoincrement field conversions=trestruc_autoincrement_conversions
6 Date field conversions=trestruc_date_conversions
5 dBASE tables
6 Compatible dBASE field types=trestruc_compatible_dbase_field_types
3 Restructuring tables in referential integrity relationships
4 About restructuring and referential integrity=trestruc_about_restructuring_referential_integrity
4 Guidelines for restructuring tables in referential integrity relationships=trestruc_restructuring_referential_integrity_guidelines
3 Dialog boxes
4 Restructure Paradox Table dialog box=idh_dial_restr
4 Restructure dBASE Table dialog box=idh_dial_drestr
4 Restructure INTRBASE Table dialog box=idh_dial_ibrestr
4 Restructure INFORMIX Table dialog box=idh_dial_ixrestr
4 Restructure ORACLE Table dialog box=idh_dial_orrestr
4 Restructure SYBASE Table dialog box=idh_dial_syrestr
4 Restructure Table dialog box (other SQL)=idh_dial_sqlrestr
4 Restructure Warning dialog box=idh_tablt_conf
2 Viewing tables
3 Windows on your data=tview_windows_on_data
3 Viewing a table
4 Opening a table=tview_opening_table
4 Table window Toolbar=tview_table_window_toolbar
4 Moving around a table
5 Table and form navigation buttons=tview_table_navigation_buttons
5 Table scroll bars=tview_table_scroll_bars
5 Scroll lock=tview_scroll_lock
5 Keyboard actions in Table windows=tview_keyboard_actions
4 Quick objects
5 About quick objects=tview_about_quick_objects
5 Preferred objects=tview_preferred_objects
2 Changing the look of tables
3 Changing the table view
4 About table views=tlook_about_table_views
4 Changing the view by dragging
5 About dragging with the mouse=tlook_dragging_mouse
5 To move, resize, or rotate columns=tlook_move_resize_rotate>taskwin
5 To resize rows=tlook_resize_rows>taskwin
4 Changing the view with properties
5 Using table properties
6 To view or change table properties=tlook_to_view_change_properties>taskwin
6 To view or change table properties in the data model=fdatamod_table_properties>taskwin
6 To save table properties=tlook_to_save_table_properties>taskwin
6 To restore table properties=tlook_to_restore_table_properties>taskwin
6 To delete table properties=tlook_to_delete_table_properties>taskwin
6 To create default table properties
7 About creating default table properties=tlook_about_default_table_properties
7 To create default table properties in a new table=tlook_to_create_default_table_properties_new>taskwin
7 To create default table properties by copying=tlook_to_create_default_table_properties_copy>taskwin
5 Aligning heading text and data
6 About aligning heading text and data=tlook_aligning_heading
6 To align text in a formatted memo field=tlook_align_formatted_memo>taskwin
5 Setting colors and fonts
6 About colors=tlook_about_colors
6 About fonts=tlook_about_fonts
5 Setting grid and marker properties
6 About the grid=tlook_about_grid
6 To change the grid's background color=tlook_change_grid_background>taskwin
6 To change the grid lines=tlook_change_grid_lines>taskwin
6 To display a marker for the current record=tlook_current_record_marker>taskwin
5 Setting properties based on data values
6 About properties based on data values=tlook_properties_based_data
6 To define a range of values=tlook_define_range>taskwin
6 Example of properties based on data values=tlook_properties_based_data_example>codewin
5 Dialog boxes
6 Data Dependent Properties dialog box=idh_dial_ddcol
3 Data formats
4 Specifying data formats
5 About data formats=tlook_about_data_formats
5 To specify the format for numeric data=tlook_specify_numeric_format>taskwin
4 Predefined data formats
5 Predefined number and money formats=tlook_predefined_number
5 Predefined date formats=tlook_predefined_date
5 Predefined time formats=tlook_predefined_time
5 Predefined timestamp formats=tlook_predefined_timestamp
5 Predefined logical formats=tlook_predefined_logical
4 Custom data formats
5 To create a custom data format=tlook_create_custom_data_format>taskwin
5 To change a custom data format=tlook_change_custom_data_format>taskwin
5 To delete a custom data format=tlook_delete_custom_data_format>taskwin
4 Dialog boxes
5 Select/Create/Change Number Format dialog box=idh_tablt_ftattrib
5 Select/Create/Change Date Format dialog box=idh_tablt_ftseldat
5 Select/Create/Change Time Format dialog box=idh_tablt_ftseltim
5 Select/Create/Change Timestamp Format dialog box=idh_tablt_ftseltimstamp
5 Select/Create/Change Logical Format dialog box=idh_tablt_ftseltlog
3 Changing the display of BLOB fields
4 About displaying memo and formatted memo fields=tlook_about_displaying_memo
4 To display or hide BLOB data in tables=tlook_display_hide_blob>taskwin
4 To magnify the display of a graphic or OLE field=tlook_magnify_graphic_ole>taskwin
2 Sorting a table
3 About sorting tables=tsort_about_sorting_tables
3 Sorting keyed tables=tsort_sorting_keyed_tables
3 Sorting unkeyed tables=tsort_sorting_unkeyed_tables
3 Sorting on a network=tsort_sorting_network
3 To sort a table=tsort_sort_table>taskwin
3 To sort an Answer table=tsort_sort_answer_table>taskwin
3 Specifying the sort order
4 To specify the sort order=tsort_specify_sort_order>taskwin
4 To add fields to the Sort Order list=tsort_add_fields_sort_order>taskwin
4 To add fields to the top of the Sort Order list=tsort_add_fields_top>taskwin
4 To remove fields from the Sort Order list=tsort_remove_fields>taskwin
4 To rearrange the sort order=tsort_rearrange_sort>taskwin
4 To specify ascending or descending sort order=tsort_ascending_descending>taskwin
3 Dialog boxes
4 Sort Table dialog box=idh_dial_sort
2 Filtering your view of table data
3 Filters
4 About filters=tfilter_about_filters
4 Filters and queries compared=tfilter_filters_vs_queries
4 Operator precedence in filters=tfilter_operator_precedence
4 Either/or conditions=tfilter_either_or_conditions
4 To filter a field=tfilter_filter_field>taskwin
4 To filter a table=tfilter_filter_table>taskwin
4 To filter more than one field=tfilter_filter_multiple_fields>taskwin
4 To remove a filter=tfilter_remove_filter>taskwin
4 To view keyed Paradox tables in a different order=tfilter_keyed_paradox>taskwin
4 To view indexed dBASE tables in a different order=tfilter_indexed_dbase>taskwin
4 To view indexed SQL tables in a different order=tfilter_indexed_sql>taskwin
3 Ranges of data
4 Ranges on a composite index=tfilter_ranges_on_composite
4 Ranges or filters on a quick form=tfilter_ranges_quick_form
4 To view a range of data=tfilter_view_range>taskwin
4 To specify an exact match in a range=tfilter_exact_match_range>taskwin
4 To match partial strings in a range=tfilter_partial_string_range>taskwin
3 Dialog boxes
4 Filter Tables dialog box=IDH_DIAL_FILTER_TABLE
4 Set Range for Index dialog box=idh_dial_sindex
4 Field Filter dialog box=IDH_DIAL_FIELD_FILTER
2 Adding, moving, subtracting, and emptying table records
3 Adding records from other tables
4 About adding records=tutils_about_adding_records
4 Rules for adding records=tutils_rules_for_adding_records
4 Adding compatible field types=tutils_adding_compatible_fields
4 Merging Paradox and dBASE tables=tutils_merge_paradox_dbase
4 Merging tables on a network=tutils_merge_on_network
4 To add records from another table=tutils_to_add_records_from_another_table>taskwin
3 Moving records from other tables
4 About moving records=tutils_about_moving_records
4 To move dependent records with Move Help=tutils_to_move_dependent_records>taskwin
3 Subtracting records that exist in another table
4 About subtracting records that exist in another table=tutils_about_subtracting_records
4 Subtracting records on a network=tutils_subtract_records_on_network
4 To subtract records that exist in another table=tutils_to_subtract_records>taskwin
3 Emptying tables
4 About emptying tables=tutils_about_emptying
4 To empty tables=tutils_to_empty_tables>taskwin
3 Dialog boxes
4 Add dialog box=idh_dial_tadd
4 Add Records In <table> To dialog box=idh_dial_tadd_to
4 Move Help dialog box=idh_tablt_movehlpdbx
4 Subtract dialog box=idh_dial_tsub
4 Subtract Records In <table> From dialog box=idh_dial_tsub_from
4 Table Empty dialog box=idh_dial_tempt
2 Getting table structure information
3 About table structure information=tgetinfo_about_table_structure
3 To get table structure information=tgetinfo_to_get_table_structure>taskwin
3 Dialog boxes
4 Structure Information dialog box=idh_tablt_info
4 Index Info dialog box (dBASE tables)=idh_dial_defdbndx
4 Index Info dialog box (SQL tables)=idh_dial_defsqlndx
2 Locking tables
3 About locking tables=tlock_about_locking_tables
3 About displaying table locks=tlock_about_display
3 Effects of locking from the Desktop=tlock_effects_of_locking
3 To lock a table=tlock_to_lock_table>taskwin
3 To display table locks=tlock_to_display_locks>taskwin
3 Dialog boxes
4 Table Locks dialog box=idh_dial_tlock
4 Select File dialog box=idh_dial_selfile
1 Entering and editing data
2 About entering and editing data=denter_about_entering_editing
2 Guidelines for entering and editing data=denter_guidelines_entering_editing
2 Editing modes and navigation shortcuts
3 About Edit mode=dmodenav_about_edit_mode
3 About Field View=dmodenav_about_field_view
3 About Persistent Field View=dmodenav_about_persistent_field_view
3 Data entry shortcuts=dmodenav_data_entry_shortcuts
3 Table and form navigation buttons=tview_table_navigation_buttons
3 Why can't I leave a field?=dmodenav_cant_leave_field
2 Entering and editing basic data
3 To enter or edit data in a Table window=dbasic_to_edit_table_window>taskwin
3 To enter or edit data in a Form window=dbasic_to_edit_form_window>taskwin
2 Inserting and deleting records
3 About inserting, posting, and deleting records=dinsdel_about_inserting_deleting_records
3 To insert records=dinsdel_to_insert_records>taskwin
3 To delete records=dinsdel_to_delete_records>taskwin
2 Cutting, copying, and pasting data
3 About cutting, copying, and pasting data=dcutcopy_about_cut_copy_paste
3 To cut, copy, and paste with the Clipboard
4 About using the Clipboard=dcutcopy_about_using_clipboard
4 To copy data=dcutcopy_to_copy>taskwin
4 To delete data=dcutcopy_to_delete>taskwin
4 To paste data=dcutcopy_to_paste>taskwin
3 Copying data to and pasting from external files
4 About copying to a file=dcutcopy_about_copying_to_file
4 About pasting from a file=dcutcopy_about_pasting_from_file
4 To copy to a file=dcutcopy_to_copy_to_file>taskwin
4 To copy text to a file=dcutcopy_to_copy_text_to_file>taskwin
4 To paste from a file=dcutcopy_to_paste_from_file>taskwin
4 Dialog boxes
5 Copy to File dialog box=idh_dial_copy
5 Copy to Graphic File dialog box=idh_dial_ctgraf
5 Save File As dialog box=idh_dial_seldir
5 Paste From File dialog box=idh_dial_paste
5 Paste From Graphic File dialog box=idh_dial_pfgraf
5 Select File dialog box=idh_dial_selfile
2 Finding and replacing data
3 About finding and replacing data=dfind_about_finding_replacing
3 Searching for text in memo fields
4 Finding and replacing text in memo fields and text objects=dfind_to_search_replace>taskwin
4 Wildcards=dfind_wildcards
4 Extended list of wildcards=dfind_extended_wildcards
4 Sample search strings with wildcards=dfind_sample_search_wildcards
4 Dialog boxes
5 Find and Replace dialog box=idh_dial_sandr
3 To locate records, fields, or values
4 About locating records or values=dfind_about_locating_records
4 To locate a record number=dfind_to_locate_record_number>taskwin
4 To locate a table field=dfind_to_locate_field>taskwin
4 To locate a value in a field=dfind_to_locate_field_value>taskwin
4 To locate and replace values in a field=dfind_to_locate_replace_field_values>taskwin
4 To locate the next record with the defined value=dfind_to_locate_next>taskwin
4 Dialog boxes
5 Locate Field dialog box=idh_formt_locfie
5 Locate Record Number dialog box=idh_formt_locrec
5 Locate Value dialog box=idh_formt_locval
5 Locate and Replace dialog box=idh_formt_locrep
5 Found A Match dialog box=idh_formt_found
2 Entering and editing special data types
3 About editing special data types=dspecial_about_editing_special_data_types
3 Memo data
4 About editing memos and formatted memos=dspecial_about_editing_memos
4 About Memo View=dspecial_about_memo_view
4 To enter Memo View from a table=dspecial_to_enter_memo_view_table>taskwin
4 To enter Memo View from a form=dspecial_to_enter_memo_view_form>taskwin
4 To enter memo data=dspecial_to_enter_memo_data>taskwin
4 To wrap memo field text in a Form window=dspecial_to_wrap_memo_in_form>taskwin
4 To exit Memo View and end a memo field edit=dspecial_to_exit_memo_view>taskwin
4 To enter formatted memo data=dspecial_to_enter_formatted_memo_data>taskwin
3 Graphic Data
4 About entering graphic data=dspecial_about_entering_graphic_data
4 To place a graphic using Cut and Paste=dspecial_to_place_graphic_cut_paste>taskwin
4 To place a graphic using Paste From=dspecial_dspecial_to_place_graphic_paste_from>taskwin
4 To view graphic data=dspecial_to_view_graphic>taskwin
3 OLE objects
4 About inserting and using OLE objects=dspecial_about_ole
4 About updating linked OLE objects=eole_about_updating_linked_ole_objects
4 About manipulating OLE objects=eole_about_manipulating_ole_objects
4 To embed a new OLE object=eole_to_embed_new_ole>taskwin
4 To embed a copy of a file as an OLE object=eole_to_embed_copy_as_ole>taskwin
4 To embed part of a file as an OLE object=eole_to_embed_part_as_ole>taskwin
4 To insert an OLE object linked to a file=eole_to_insert_ole_linked_to_file>taskwin
4 To insert an OLE object linked to part of a file=eole_to_insert_ole_linked_to_part>taskwin
4 To manipulate the contents of an OLE field=eole_to_manipulate_contents_of_ole_field>taskwin
4 To manipulate the contents of an OLE design object=eole_to_manipulate_contents_of_ole_design_object>taskwin
3 Fields with validity checks
4 About editing fields with validity checks=dspecial_about_editing_with_validity_checks
2 Locking records
3 About locking records=dadvance_about_locking_records
3 To lock a record=dadvance_to_lock_record>taskwin
3 To unlock a record=dadvance_to_unlock_record>taskwin
3 To post a record without unlocking it=dadvance_to_post_without_unlocking>taskwin
2 Using table lookup
3 About table lookups=tcreate_about_lookups
3 Types of table lookup=dadvance_types_of_table_lookup
3 To use table lookup=dadvance_to_use_table_lookup>taskwin
3 Examples
4 Examples of table lookup=dadvance_examples_of_table_lookup>codewin
4 Example of using Just Current Field with Fill No Help=dadvance_using_just_current_field_with_private
4 Example of using Just Current Field with Help And Fill=dadvance_using_just_current_field_with_help_fill
4 Example of using All Corresponding Fields with Fill No Help=dadvance_using_all_corresponding_fields_fill_no_help
4 Example of using All Corresponding Fields with Help And Fill=dadvance_using_all_corresponding_fields_help_fill
3 Dialog boxes
4 Table Lookup dialog box=idh_tablt_lookdb
4 Lookup Help dialog box=idh_tablt_uselook
1 Exchanging data
2 About exchanging data=eabout_about_exchanging_data
2 Importing data
3 About importing data=eimport_about_importing
3 Importing spreadsheet data=eimport_importing_spreadsheet
3 Importing delimited text=eimport_importing_delimited
3 Importing fixed length text=eimport_importing_fixed_length
3 Determining field names=eimport_determining_field_names
3 Determining spreadsheet field types=eimport_spreadsheet_field_types
3 To import data=eimport_to_import_data>taskwin
3 Dialog boxes
4 Import dialog box=idh_tablt_import
4 File Import dialog box=idh_dial_impo
4 Select File dialog box=idh_dial_selfile
4 Save Import Specification As dialog box=idh_dial_savimpspecas
4 Import Data dialog box
5 Import Data dialog box=idh_tablt_impframe
5 From Text page (Import Data dialog box)=idh_tablt_imptext
5 From Fields page (Import Data dialog box)=idh_tablt_impfields
5 From Spreadsheet page (Import Data dialog box)=idh_tablt_impspread
5 To Table page (Import Data dialog box)=idh_tablt_imptable
2 Exporting data
3 About exporting data=eexport_about_exporting
3 Exporting to a spreadsheet=eexport_exporting_to_spreadsheet
3 Exporting to delimited text=eexport_exporting_to_delimited
3 Exporting to fixed length text=eexport_exporting_to_fixed
3 To export data=eexport_to_export>taskwin
3 Dialog boxes
4 Export Table dialog box=idh_tablt_exporttable
4 Export <table> As dialog box=idh_tablt_export
4 Save Export Specification As dialog box=idh_tablt_savexpspec
4 Export Data dialog box
5 Export Data dialog box=idh_tablt_expframe
5 To Text page (Export Data dialog box)=idh_tablt_exptext
5 To Fields page (Export Data dialog box)=idh_tablt_expfields
5 To Spreadsheet page (Export Data dialog box)=idh_tablt_expspread
5 To Table page (Export Data dialog box)=idh_tablt_exptable
2 Using OLE and DDE
3 About OLE and DDE=eole_about_ole_dde
3 Using OLE
4 About OLE=eole_about_ole
4 About embedded OLE objects=eole_about_embedded_objects
4 About linked OLE objects=eole_about_linked_objects
4 Embedding objects in OLE fields and design objects
5 To embed a new OLE object=eole_to_embed_new_ole>taskwin
5 To embed a copy of a file as an OLE object=eole_to_embed_copy_as_ole>taskwin
5 To embed part of a file as an OLE object=eole_to_embed_part_as_ole>taskwin
4 Inserting linked OLE objects
5 To insert an OLE object linked to a file=eole_to_insert_ole_linked_to_file>taskwin
5 To insert an OLE object linked to part of a file=eole_to_insert_ole_linked_to_part>taskwin
4 Updating linked OLE objects
5 About updating linked OLE objects=eole_about_updating_linked_ole_objects
5 To change the way Paradox updates linked objects=eole_to_change_the_way_paradox_updates_linked_objects>taskwin
5 To manually update a linked object=eole_to_manually_update_linked_object>taskwin
4 Manipulating objects in OLE fields and design objects
5 About manipulating OLE objects=eole_about_manipulating_ole_objects
5 About OLE 1.0 versus OLE 2.0=eole_about_ole_1_versus_2
5 To manipulate the contents of an OLE field=eole_to_manipulate_contents_of_ole_field>taskwin
5 To manipulate the contents of an OLE design object=eole_to_manipulate_contents_of_ole_design_object>taskwin
4 Using Paradox as an OLE 2.0 server
5 About using Paradox as an OLE 2.0 server=eole_about_using_paradox_as_ole
5 To embed a Paradox table using the Clipboard=eole_to_embed_paradox_table_using_clipboard>taskwin
5 To embed a Paradox table using Insert Object=eole_to_embed_paradox_table_using_insert_object>taskwin
4 Dialog boxes
5 Insert Object dialog box=idh_dial_insert_object
5 Change Source dialog box=idh_dial_ole_chgsource
5 Change Icon dialog box=idh_dial_ole_chgicon
5 Links dialog box=idh_dial_edit_links
3 Using DDE
4 About DDE=eole_about_dde
4 To use Paradox as a DDE server=eole_to_use_paradox_as_dde_server>taskwin
4 To use Paradox as a DDE client (tables)=eole_to_use_paradox_as_dde_client_tables>taskwin
4 To use Paradox as a DDE client (queries)=eole_to_use_paradox_as_dde_client_queries>taskwin
4 To disconnect a DDE link=eole_to_disconnect_dde_link>taskwin
4 Examples
5 Example of Paradox as a DDE server=eole_example_paradox_as_dde_server>codewin
5 Example of Paradox as a DDE client and server (queries)=eole_example_paradox_as_dde_client_server_queries>codewin
2 Sending mail
3 About sending mail=email_about_sending_mail
1 Queries
2 Overview: creating and using queries
3 About queries=qabout_about
3 To open a query=qabout_open>taskwin
3 To run a query=qabout_run>taskwin
3 To save a query=qabout_save>taskwin
3 Creating queries
4 Guidelines for creating queries=qabout_guidelines
4 To create a query from a table=qabout_create_from_table>taskwin
4 To create a query based on a data model=qabout_based_on_data_model>taskwin
4 To create a query based on another query=qabout_based_on_query>taskwin
4 Example of creating a simple query=qabout_create_example>codewin
2 The Query window and image
3 The Query window
4 Using the Query window=qwindow_using
4 The Query window Toolbar=idh_qbet_tool
4 To add tables to a query=qwindow_add_tables>taskwin
4 To remove tables from a query=qwindow_remove_tables>taskwin
3 The query image
4 Working with query images=qwindow_image_working_with
4 Query image check boxes=qwindow_checkboxes
4 Query image fields=qwindow_fields
4 To place a checkmark in a query image=qwindow_place_checkmark>taskwin
4 To rotate columns in a query image=qwindow_rotate_columns>taskwin
2 Performing basic queries
3 Selecting fields to display
4 About selecting fields to display=qbasic_fields_about
4 To place a checkmark in a query image=qwindow_place_checkmark>taskwin
4 To specify field names in the Answer table=qbasic_fields_specify>taskwin
3 Selecting records with queries
4 Using selection conditions
5 About selection conditions=qbasic_selection_about
5 Selection condition operators
6 Query operators=qbasic_selection_operators
6 Operator precedence in queries=qbasic_selection_operator_precedence
6 Arithmetic operators
7 Using arithmetic operators=qbasic_selection_arithmetic
7 Paradox field types allowing arithmetic operators=qbasic_selection_arithmetic_paradox
7 dBASE field types allowing arithmetic operators=qbasic_selection_arithmetic_dbase
5 Rules for typing selection conditions
6 Entering numbers in queries=qbasic_selection_typing_numbers
6 Using reserved words or symbols in selection conditions=qbasic_selection_reserved_words
5 Specifying matches in selection conditions
6 Exact matches=qbasic_selection_exact
6 Matching a range of values: comparison operators=qbasic_selection_range
6 Inexact matches: the LIKE operator=qbasic_selection_like
6 Non-matches: the NOT operator=qbasic_selection_not
6 Blank values: the BLANK operator=qbasic_selection_blank
6 Today's date: the TODAY operator=qbasic_selection_today
6 Matching patterns: wildcard operators
7 Using wildcards to match a pattern=qbasic_selection_wildcards
7 The .. wildcard operator=qbasic_selection_series
7 The @ operator=qbasic_selection_pattern
7 Using wildcards with numbers=qbasic_selection_wildcards_numbers
7 Using wildcards with dates=qbasic_selection_wildcards_dates
7 Example of using wildcards to match a pattern=qbasic_selection_wildcards_pattern>codewin
5 Using AND and OR in selection conditions
6 AND conditions
7 About AND conditions=qbasic_selection_and_about
7 AND conditions in the same field=qbasic_selection_and_same_field
7 AND conditions in different fields=qbasic_selection_and_different_field
7 AND conditions with linked tables=qbasic_selection_and_linked_tables
6 OR conditions
7 About OR conditions=qbasic_selection_or_about
7 OR conditions in the same field=qbasic_selection_or_same_field
7 OR conditions in different fields=qbasic_selection_or_different_field
7 OR conditions with linked tables (multi-table queries)=qbasic_selection_or_linked_tables
5 Combining conditions
6 Combining AND and OR conditions=qbasic_selection_combine_and_or
6 Combining two conditions in one field=qbasic_selection_combine_two_conditions
4 Using example elements
5 About example elements=qbasic_example_about
5 Creating example elements=qbasic_example_creating
5 Using an example element in a selection condition=qbasic_example_selection
5 Using an example element to represent a value=qbasic_example_represent_value
5 Using an example element in a range=qbasic_example_range
5 Using an example element in a date condition=qbasic_example_date
5 Using LIKE or NOT with an example element=qbasic_example_like_not
5 To create an example element by typing=qbasic_example_create_typing>taskwin
5 To place example elements with the Toolbar=qbasic_example_create_toolbar>taskwin
3 Performing calculations with queries
4 Calculating values with queries: the CALC operator=qbasic_calc_about
4 Using CALC with arithmetic operators=qbasic_calc_arithmetic
4 Using CALC with alphanumeric values=qbasic_calc_alphanumeric
4 Creating a new answer field with a constant value=qbasic_calc_new_answer
4 Calculating with numeric values from different tables=qbasic_calc_different_tables
4 Examples of calculating values with queries=qbasic_calc_example>codewin
3 Querying more than one table
4 Querying more than one table=qbasic_multiple_about
4 Using example elements to link tables=qbasic_multiple_example_elements
4 Linking more than two tables=qbasic_multiple_more_than_two
4 Using a multi-table design to link tables=qbasic_multiple_design
4 Example of multi-table queries=qbasic_multiple_example>codewin
2 Query results
3 About query results=qresults_about
3 The Answer table
4 About the Answer table=qresults_answer_about
4 Modifying and renaming the Answer table=qresults_answer_modify
4 To specify field names in the Answer table=qbasic_fields_specify>taskwin
4 To rename Answer table fields=qresults_answer_rename_fields>taskwin
4 To sort the Answer table=qresults_answer_sort>taskwin
4 To sort Answer table values in descending order=qresults_answer_sort_descending>taskwin
3 Live query views
4 About live query views=qresults_live_about
4 Rules for live query views=qresults_live_rules
4 To create a live query view=qresults_live_create>taskwin
4 To edit a live query view=qresults_live_edit>taskwin
4 To save a live query view=qresults_live_save>taskwin
2 Query properties
3 About query properties=qprop_about
3 Handling table updates=qprop_table_updates
3 Setting Answer table properties=qprop_answer
3 Setting auxiliary table properties=qprop_auxiliary
3 Setting remote query properties=qprop_set_remote
3 Setting query sort properties=qprop_set_sort
3 Setting query structure properties=qprop_set_structure
3 To save query settings=qprop_save>taskwin
3 Query properties dialog box
4 Answer page=idh_qbe_answ
4 QBE page=idh_qbe_qbe
4 Sort page=idh_qbe_sortans
4 Structure page=idh_qbe_structure
2 Advanced queries: groups, sets, and inclusive links
3 About advanced queries=qadvance_about
3 Querying groups of records
4 About querying groups of records=qadvance_groups_about
4 Using summary operators
5 About summary operators=qadvance_group_summary_about
5 Paradox field types allowing summary operators=qadvance_group_summary_paradox
5 dBASE field types allowing summary operators=qadvance_group_summary_dbase
5 Using summary operator modifiers=qadvance_group_summary_modifiers
5 Selecting records based on group definitions=qadvance_group_summary_based_on_group
5 Examples
6 Example of using COUNT: selecting records based on a group count=qadvance_group_summary_count>codewin
6 Example of using SUM: selecting records based on a group sum=qadvance_group_summary_sum>codewin
6 Example of using AVERAGE: selecting records based on a group average=qadvance_group_summary_average>codewin
6 Example of using MAX and MIN: selecting records based on a group maximum or minimum=qadvance_group_summary_maxmin>codewin
4 Calculations on groups
5 About calculations on groups=qadvance_group_calc_about
5 Examples
6 Example of a basic calculation on a group=qadvance_group_calc_example>codewin
6 Example of grouping by more than one field=qadvance_group_calc_multiple_fields>codewin
6 Example of performing a group calculation on the entire table=qadvance_group_calc_entire_table>codewin
6 Example of displaying summary values without grouping by them=qadvance_group_calc_display_only>codewin
6 Example of counting unique values=qadvance_group_calc_count_unique>codewin
6 Example of counting all values=qadvance_group_calc_count_all>codewin
4 Using the ONLY operator
5 Example of using ONLY: selecting records containing only one value=qadvance_group_only>codewin
3 Querying sets of records
4 About querying sets of records (SET queries)=qadvance_set_about_sets
4 Defining a set=qadvance_set_define
4 Example of defining a set=qadvance_set_define_example>codewin
4 Set comparisons
5 Performing set comparisons=qadvance_set_comparison_perform
5 Example of performing a set comparison=qadvance_set_comparison_example>codewin
5 Example of the ONLY set comparison operator=qadvance_set_comparison_only>codewin
5 Example of the NO set comparison operator=qadvance_set_comparison_no>codewin
5 Example of the EVERY set comparison operator=qadvance_set_comparison_every>codewin
5 Example of the EXACTLY set comparison operator=qadvance_set_comparison_exactly>codewin
5 Example of a SET query involving more than one set=qadvance_set_comparison_multiple_sets>codewin
4 Set summaries
5 Example of summary operators in a SET query=qadvance_set_summary>codewin
3 Querying with inclusive links
4 About inclusive links (! operator)=qadvance_link_about
4 Linking to all records in a table=qadvance_link_all_records
4 Rules for linking tables=qadvance_link_rules
4 Selection conditions with inclusive links=qadvance_link_selection
4 Examples
5 Example of linking to all records in a table=qadvance_link_all_records_example>codewin
5 Example of using the Inclusion operator in a query that performs a calculation=qadvance_link_inclusion_example>codewin
5 Example of retrieving records from one table that are not in another table=qadvance_link_retrieve_not_in_table_example>codewin
5 Example of using both inclusive and exclusive links in a query=qadvance_link_inclusive_exclusive_example>codewin
2 Changing tables with queries
3 About queries that change data=qchange_about
3 Operation order in a query involving multiple operations=qchange_operation_order
3 Inserting records with queries
4 About INSERT queries=qchange_insert_about
4 INSERT query temporary tables=qchange_insert_temporary_tables
4 To perform an INSERT query=qchange_insert_perform>taskwin
4 Example of inserting a record with an INSERT query=qchange_insert_record_example>codewin
4 Example of inserting new values with an INSERT query=qchange_insert_new_values_example>codewin
3 Deleting records with queries
4 About DELETE queries=qchange_delete_about
4 DELETE query temporary tables=qchange_delete_temporary_tables
4 To perform a DELETE query=qchange_delete_perform>taskwin
4 Example of removing a record with a DELETE query=qchange_delete_record_example>codewin
4 Example of undoing a DELETE query=qchange_delete_undo_example>codewin
3 Changing values with queries
4 About CHANGETO queries=qchange_changeto_about
4 CHANGETO query temporary tables=qchange_changeto_temporary_tables
4 To perform a CHANGETO query=qchange_changeto_perform>taskwin
4 To undo changes using the Changed table=qchange_changeto_undo>taskwin
4 To perform a multi-table CHANGETO query=qchange_changeto_multi_perform>taskwin
4 Example of changing data with a CHANGETO query=qchange_changeto_example>codewin
4 Example of using CHANGETO with example elements=qchange_changeto_example_elements_example>codewin
1 Forms and reports
2 About forms and reports=fabout_about_forms_reports
2 Creating a simple form or report
3 About creating forms and reports=fabout_about_creating
3 Step 1: Create the design document=fabout_create_design_document>taskwin
3 Step 2: Create a data model=fabout_create_data_model>taskwin
3 Step 3: Create a layout=fabout_create_layout>taskwin
3 Step 4: Place design objects on the document=fabout_place_objects>taskwin
3 Step 5: Save the design=fabout_save_design>taskwin
3 To create a form or report using the experts=fabout_create_with_expert>taskwin
2 Data models
3 About data models=fdatamod_about_data_models
3 Multi-table data models=fdatamod_multi_table_data_model
3 Data Models for reports with groups=fdatamod_data_model_report_groups
3 Example single-value relationship data model=fdatamod_single_value_example>codewin
3 Example of a multi-value relationship data model=fdatamod_multi_value_example>codewin
3 Example of a data model for reports with groups=fdatamod_data_model_report_groups_example>codewin
3 Using the Data Model dialog box
4 To open the Data Model dialog box=fdatamod_open_data_model_dialog>taskwin
4 To add tables to the data model panel=fdatamod_add_tables>taskwin
4 To choose a query for a data model=fdatamod_choose_query>taskwin
4 To choose an existing data model for a data model=fdatamod_choose_data_model>taskwin
4 To remove tables from the data model panel=fdatamod_remove_tables>taskwin
4 To view or change table properties in a data model=fdatamod_table_properties>taskwin
3 Linking tables in a data model
4 About links and indexes=fdatamod_about_links_indexes
4 Types of links
5 Single-value relationships=fdatamod_single_value
5 Multi-value relationships=fdatamod_multi_value
4 Linking Paradox tables
5 To create a link=fdatamod_create_link>taskwin
5 To define a link=fdatamod_define_link>taskwin
5 To preview links=fdatamod_preview_links>taskwin
5 To modify links=fdatamod_modify_links>taskwin
5 To remove links=fdatamod_remove_links>taskwin
5 Example of creating a link=fdatamod_create_link_example>codewin
5 Example of a complex data model=fdatamod_complex_data_model_example>codewin
5 Example of a linked multi-table form=fdatamod_about_links_indexes_example>codewin
4 Linking dBASE tables
5 dBASE linking combinations=fdatamod_dbase_linking
5 Limitations on reports containing dBASE tables=fdatamod_dbase_report_limitations
4 Dialog boxes
5 Define Link dialog box (Paradox)=idh_mult_deflink
5 Define Link dialog box (dBASE)=idh_mult_deflinkdb
3 Using table aliases
4 About table aliases=fdatamod_about_table_aliases
4 To create a table alias=fdatamod_create_table_alias>taskwin
4 To remove a table alias=fdatamod_remove_table_alias>taskwin
4 Dialog boxes
5 Table Name dialog box=idh_dial_table_name
3 Saving a data model
4 To save a data model in the Data Model dialog box=fdatamod_save_data_model>taskwin
3 The Data Model Designer
4 About the Data Model Designer=fdatamod_about_designer
4 To open the Data Model Designer=fdatamod_open_designer>taskwin
4 Data Model Designer Toolbar=idh_dmd_speed
4 Choosing a view
5 To view the current data model=fdatamod_view_current_data_model>taskwin
5 To view a reference data model=fdatamod_view_reference_data_model>taskwin
5 To view two data models at one time=fdatamod_view_split>taskwin
4 Creating and opening a data model
5 To create a data model in the Data Model Designer=fdatamod_create_data_model>taskwin
5 To load a data model=fdatamod_load_data_model>taskwin
4 Modifying a data model
5 To add a table to a data model=fdatamod_add_table>taskwin
5 To create, break, or modify links=fdatamod_modify_links_designer>taskwin
5 To remove a table from the data model=fdatamod_remove_table>taskwin
5 To copy items from the reference data model=fdatamod_copy_from_reference>taskwin
5 To view table properties in the Data Model Designer=fdatamod_view_table_properties>taskwin
4 Saving and printing a data model
5 About saving a data model in the Data Model Designer=fdatamod_save_data_model_designer
5 To apply changes to the data model for the active form or report=fdatamod_apply_changes>taskwin
5 To save changes to the reference data model=fdatamod_save_changes_reference_model>taskwin
5 To give a data model a new name=fdatamod_give_new_name>taskwin
5 To cancel changes to the data model for the active form or report=fdatamod_cancel_changes>taskwin
5 To save or restore a default data model=fdatamod_default_data_model>taskwin
5 To print a data model=fdatamod_print_data_model>taskwin
3 Dialog boxes
4 Data Model dialog box=idh_dial_fmast
2 Layouts
3 About form and report layouts=flayout_about_layouts
3 How form and report layouts differ=flayout_form_vs_report_layouts
3 Specifying an initial layout
4 To open the Design Layout dialog box=flayout_open_design_layout_dialog>taskwin
4 To return to the Design Layout dialog box=flayout_return_to_design_layout_dialog>taskwin
4 To choose a layout style=flayout_choose_layout_style>taskwin
4 To select fields to display=flayout_select_fields>taskwin
4 To display fields in columns or rows=flayout_single_table_columns_rows>taskwin
4 To hide or show field labels=flayout_hide_show_field_labels>taskwin
4 To choose a style sheet=flayout_choose_style_sheet>taskwin
4 Example of selecting fields for a layout=flayout_selecting_fields_example>codewin
3 Single-table layouts
4 Example of a single-record layout=flayout_single_table_single_record_example>codewin
4 Example of a tabular layout=flayout_single_table_tabular_example>codewin
4 Example of a multi-record layout=flayout_single_table_multi_record_example>codewin
3 Multi-table layouts
4 To display objects in columns or rows=flayout_multi_table_columns_rows>taskwin
4 To show detail tables=flayout_show_detail_tables>taskwin
4 To place master records before detail tables=flayout_master_before_detail>taskwin
4 To display several master records at the same time=flayout_display_several_masters>taskwin
4 To nest detail records in a form=flayout_nest_detail_form>taskwin
4 To nest detail records in a report=flayout_nest_detail_report>taskwin
4 Examples
5 Example of displaying one master record at a time=flayout_display_one_master_example>codewin
5 Example of displaying detail records in a multi-record object=flayout_display_details_mro_example>codewin
5 Example of displaying both master and detail records in table frames=flayout_display_both_table_frames_example>codewin
5 Example of nesting detail records in a form=flayout_nest_detail_form_example>codewin
5 Example of a design using three tables=flayout_three_tables_example>codewin
3 Dialog boxes
4 Design Layout dialog box (single table and single-value relationship)=idh_formt_layo
4 Design Layout dialog box (multi-value relationship)=idh_formt_mlayo
2 The design window
3 About the design window=fdeswin_about_design_window
3 To open a design document=fdeswin_open_design_document>taskwin
3 Toolbars
4 About design window Toolbars=fdeswin_about_design_toolbars
4 Form Design Toolbar=idh_formt_tool
4 Report Design Toolbar=idh_reptt_tool
4 To change a tool's properties=fdeswin_change_tool_properties>taskwin
4 To copy a design object's properties to the Toolbar=fdeswin_copy_properties_to_toolbar>taskwin
4 To copy a composite design object's properties to the Toolbar=fdeswin_copy_composite_properties_to_toolbar>taskwin
4 To copy page properties to the Toolbar=fdeswin_copy_page_properties_to_toolbar>taskwin
3 Rulers
4 About rulers=fdeswin_about_rulers
4 About the expanded ruler=fdeswin_about_expanded_ruler
4 To display the expanded ruler=fdeswin_display_expanded_ruler>taskwin
4 To place tabs=fdeswin_place_tabs>taskwin
4 To move or delete tabs=fdeswin_move_delete_tabs>taskwin
4 To add indentations=fdeswin_add_indentations>taskwin
4 To change margins=fdeswin_change_margins>taskwin
4 To change text alignment=fdeswin_change_text_alignment>taskwin
4 To change vertical line spacing=fdeswin_change_vertical_line_spacing>taskwin
3 Grid
4 About the grid=fdeswin_about_grid
4 To view (show) the grid=fdeswin_show_grid>taskwin
4 To align design objects at the grid line (snap to grid)=fdeswin_snap_to_grid>taskwin
4 To change grid settings=fdeswin_change_grid_settings>taskwin
3 Zooming
4 To zoom forms and reports=fdeswin_zoom>taskwin
3 Setting designer preferences
4 About designer preferences=fdeswin_about_design_preferences
4 Select From Inside=fdeswin_select_from_inside
4 Frame Objects=fdeswin_frame_objects
4 Flicker-Free Draw=fdeswin_flicker_free_draw
4 Outlined Move/Resize=fdeswin_outlined_move_resize
4 To set designer preferences=fdeswin_set_design_preferences>taskwin
4 Dialog boxes
5 Designer page (Preferences dialog box)=idh_dial_prefdesign
3 Style sheets
4 About style sheets=fdeswin_about_style_sheets
4 To create or save a style sheet=fdeswin_create_style_sheet>taskwin
4 To apply a style sheet=fdeswin_apply_style_sheet>taskwin
4 To change to a different style sheet=fdeswin_change_style_sheet>taskwin
4 To specify a default style sheet=fdeswin_default_style_sheet>taskwin
4 To access a style sheet from any working directory=fdeswin_style_sheet_any_directory>taskwin
4 Dialog boxes
5 Style Sheet dialog box=idh_dial_style_sheet
3 Saving a design
4 To save a form or report design=fdeswin_save_design>taskwin
3 Setting default design window preferences
4 To set form and report default preferences=fdeswin_set_desktop_properties>taskwin
2 Using design objects in forms and reports
3 About design objects=fobjects_about_design_objects
3 Selecting design objects
4 To select a design object=fobjects_select_object>taskwin
4 To make a design object selectable or unselectable=fobjects_make_selectable>taskwin
3 Placing, grouping, and stacking design objects
4 About using the Clipboard=dcutcopy_about_using_clipboard
4 To manipulate objects directly with the mouse=bbasics_to_manipulate_mouse>taskwin
4 To place a design object on a form or report=fobjects_place_object>taskwin
4 To duplicate a design object=fobjects_duplicate_object>taskwin
4 To group design objects=fobjects_group_objects>taskwin
4 To stack design objects=fobjects_stack_objects>taskwin
3 Specifying how to view design objects
4 To display frames for design objects=fobjects_display_object_frames>taskwin
4 To display outlines for design objects while moving or resizing=fobjects_display_object_outlines>taskwin
4 To display design object size and position on the status bar=fobjects_display_object_size_position>taskwin
3 Moving and aligning design objects
4 To move design objects=fobjects_move_objects>taskwin
4 To align design objects=fobjects_align_objects>taskwin
4 To align design objects at the grid line (snap to grid)=fdeswin_snap_to_grid>taskwin
4 To adjust the spacing of design objects=fobjects_adjust_spacing>taskwin
4 To pin design objects in place on a form or report=fobjects_pin_objects>taskwin
3 Sizing design objects
4 To change the size and shape of a design object=fobjects_adjust_object_size>taskwin
4 To adjust the size and spacing of multiple design objects=fobjects_adjust_object_size_multiple>taskwin
4 Sizing design objects to fit their contents
5 To magnify the display of a graphic or OLE field=tlook_magnify_graphic_ole>taskwin
5 To size a field object=fobjects_size_field_object>taskwin
3 Containing design objects
4 About contained design objects=fobjects_about_contained
4 To create a contained design object=fobjects_create_contained>taskwin
4 To select a contained design object=fobjects_select_contained>taskwin
4 To break a container relationship=fobjects_break_container>taskwin
4 To delete a contained design object=fobjects_delete_contained_object>taskwin
4 To delete a container but not its contained objects=fobjects_delete_container_only>taskwin
3 Naming design objects
4 Object Name property=ps_mod_name
4 To change the name of a design object=fobjects_change_object_name>taskwin
3 Placing scroll bars on design objects
4 About scroll bars in forms=fobjects_about_scrollbars_forms
4 About scroll bars in reports=fobjects_about_scrollbars_reports
4 To place a scroll bar=fobjects_place_scrollbar>taskwin
4 To change the width of a scroll bar=fobjects_scrollbar_width>taskwin
3 Changing properties
4 About manipulating objects=bbasics_about_manipulating_objects
4 To manipulate objects directly with the mouse=bbasics_to_manipulate_mouse>taskwin
4 Changing properties
5 To change a tool's properties=fdeswin_change_tool_properties>taskwin
5 To change an object's properties=bbasics_to_change_properties>taskwin
5 To change properties from the Object Explorer=fobjects_properties_object_tree>taskwin
4 Changing properties of multiple design objects
5 To change penetrating properties=fobjects_change_penetrating_properties>taskwin
5 To change penetrating properties of all objects=fobjects_change_penetrating_properties_all>taskwin
3 Attaching methods to design objects
4 To add a method to an object with the Object Explorer=fobjects_attach_method>taskwin
2 Design objects and their properties
3 Drawing objects
4 About boxes, ellipses, and lines=fobjprop_drawing_objects_about
4 Using boxes and ellipses to keep design objects together=fobjprop_drawing_objects_keep_together
4 Box
5 About boxes=fobjprop_box_about
5 To place a box on a form or report=fobjprop_box_place>taskwin
5 Box properties
6 General page=idh_prop_general_1
6 Pattern page=idh_prop_pattern_1
6 Frame page=idh_prop_frame_1
6 Design page=idh_prop_design_1
6 Run Time page (forms)=idh_prop_runtimef_2
6 Run Time page (reports)=idh_prop_runtimer_1
4 Ellipse
5 About ellipses=fobjprop_ellipse_about
5 To place an ellipse on a form or report=fobjprop_ellipse_place>taskwin
5 Ellipse properties
6 General page=idh_prop_general_1
6 Line style page=idh_prop_style_2
6 Pattern page=idh_prop_pattern_1
6 Design page=idh_prop_design_1
6 Run Time page (forms)=idh_prop_runtimef_2
6 Run Time page (reports)=idh_prop_runtimer_1
4 Line
5 About lines=fobjprop_line_about
5 Controlling pushed objects with lines=fobjprop_line_pushed_objects
5 To place a line on a form or report=fobjprop_line_place>taskwin
5 To create a curved line=fobjprop_line_curved>taskwin
5 To add arrows to straight lines=fobjprop_line_arrows>taskwin
5 Line properties
6 General page=idh_prop_general_1
6 Style page=idh_prop_style_1
6 Design page=idh_prop_design_1
6 Run Time page (forms)=idh_prop_runtimef_2
6 Run Time page (reports)=idh_prop_runtimer_1
3 Graphic
4 About graphics=fobjprop_graphic_about
4 About raster operations=fobjprop_graphic_about_raster_operations
4 To place a graphic on a form or report=fobjprop_graphic_place>taskwin
4 To move a graphic=fobjprop_graphic_move>taskwin
4 To place a graphic on a button=fobjprop_button_graphic>taskwin
4 To copy a graphic to a file without using Export=fobjprop_graphic_copy_to_file>taskwin
4 Changing the appearance of a graphic object
5 To crop a graphic=fobjprop_graphic_crop>taskwin
5 To magnify the display of a graphic or OLE field=tlook_magnify_graphic_ole>taskwin
5 To resize a graphic or OLE object on a report=fobjprop_graphic_OLE_resize_report>taskwin
5 Example of creating a mask for a graphic=fobjprop_graphic_create_mask>codewin
4 Scroll bars on graphic objects
5 About scroll bars in forms=fobjects_about_scrollbars_forms
5 About scroll bars in reports=fobjects_about_scrollbars_reports
5 To place a scroll bar=fobjects_place_scrollbar>taskwin
5 To change the width of a scroll bar=fobjects_scrollbar_width>taskwin
4 Graphic properties
5 General page=idh_prop_general_2
5 Magnification page=idh_prop_magnify_1
5 Raster Operation page=idh_prop_raster_1
5 Frame page=idh_prop_frame_1
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_2
5 Run Time page (reports)=idh_prop_runtimer_1
3 Text
4 About text=fobjprop_text_about
4 To place a text object on a form or report=fobjprop_text_place>taskwin
4 To change text in a text object=fobjprop_text_change>taskwin
4 To insert fields in text=fobjprop_text_insert_fields>taskwin
4 Example of inserting fields in a text object=fobjprop_text_insert_fields_example>codewin
4 Changing the appearance of text
5 To select text to change properties=fobjprop_text_select>taskwin
5 To specify a font and typestyle for text=fobjprop_text_font_typestyle>taskwin
5 To align text=fobjprop_text_align>taskwin
5 To specify the line spacing for text=fobjprop_text_line_spacing>taskwin
5 To use word wrap=fobjprop_text_word_wrap>taskwin
5 To specify how a text object grows=fobjprop_text_how_grows>taskwin
4 Scroll bars on text objects
5 About scroll bars in forms=fobjects_about_scrollbars_forms
5 About scroll bars in reports=fobjects_about_scrollbars_reports
5 To place a scroll bar=fobjects_place_scrollbar>taskwin
5 To change the width of a scroll bar=fobjects_scrollbar_width>taskwin
4 Dialog boxes
5 Find And Replace dialog box=idh_dial_sandr
4 Text properties
5 General page=idh_prop_general_5
5 Pattern page=idh_prop_pattern_1
5 Frame page=idh_prop_frame_1
5 Font page=idh_prop_font_1
5 Text page=idh_prop_text_1
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_2
5 Run Time page (reports)=idh_prop_runtimer_2
3 OLE
4 About OLE=eole_about_ole
4 About embedded OLE objects=eole_about_embedded_objects
4 About linked OLE objects=eole_about_linked_objects
4 To place an OLE object on a form or report=eole_place_ole_object>taskwin
4 Embedding objects in OLE fields and design objects
5 To embed a new OLE object=eole_to_embed_new_ole>taskwin
5 To embed a copy of a file as an OLE object=eole_to_embed_copy_as_ole>taskwin
5 To embed part of a file as an OLE object=eole_to_embed_part_as_ole>taskwin
4 Inserting linked OLE objects
5 To insert an OLE object linked to a file=eole_to_insert_ole_linked_to_file>taskwin
5 To insert an OLE object linked to part of a file=eole_to_insert_ole_linked_to_part>taskwin
4 Updating linked OLE objects
5 About updating linked OLE objects=eole_about_updating_linked_ole_objects
5 To change the way Paradox updates linked objects=eole_to_change_the_way_paradox_updates_linked_objects>taskwin
5 To manually update a linked object=eole_to_manually_update_linked_object>taskwin
4 Manipulating objects in OLE fields and design objects
5 About manipulating OLE objects=eole_about_manipulating_ole_objects
5 About OLE 1.0 versus OLE 2.0=eole_about_ole_1_versus_2
5 To manipulate the contents of an OLE field=eole_to_manipulate_contents_of_ole_field>taskwin
5 To manipulate the contents of an OLE design object=eole_to_manipulate_contents_of_ole_design_object>taskwin
4 Using Paradox as an OLE 2.0 server
5 About using Paradox as an OLE 2.0 server=eole_about_using_paradox_as_ole
5 To embed a Paradox table using the Clipboard=eole_to_embed_paradox_table_using_clipboard>taskwin
5 To embed a Paradox table using Insert Object=eole_to_embed_paradox_table_using_insert_object>taskwin
4 Scroll bars on OLE objects
5 About scroll bars in forms=fobjects_about_scrollbars_forms
5 About scroll bars in reports=fobjects_about_scrollbars_reports
5 To place a scroll bar=fobjects_place_scrollbar>taskwin
5 To change the width of a scroll bar=fobjects_scrollbar_width>taskwin
4 Dialog boxes
5 Insert Object dialog box=idh_dial_insert_object
5 Change Source dialog box=idh_dial_ole_chgsource
5 Change Icon dialog box=idh_dial_ole_chgicon
5 Links dialog box=idh_dial_edit_links
4 OLE properties
5 General page=idh_prop_general_3
5 Magnification page=idh_prop_magnify_1
5 Frame page=idh_prop_frame_1
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_2
5 Run Time page (reports)=idh_prop_runtimer_1
3 OLE and native Windows controls
4 About OLE and native Windows controls=fobjprop_ocx_about
4 About OLE control event types=fobjprop_oxc_about_event_types
4 About ambient properties=fobjprop_ocx_about_ambient
4 To display the Object Toolbar=fobjprop_ocx_access_toolbar>taskwin
4 To place a control on a form=fobjprop_ocx_place>taskwin
4 To register an OLE control=fobjprop_ocx_register>taskwin
4 To add a control to the Toolbar=fobjprop_ocx_add_toolbar_control>taskwin
4 To remove a control from the Toolbar=fobjprop_ocx_remove_toolbar_control>taskwin
4 To add a page to the Object Toolbar=fobjprop_ocx_add_toolbar_page>taskwin
4 To edit events on an OLE control=fobjprop_ocx_associate_method>taskwin
4 OCX properties
5 General page=idh_prop_general_4
5 Frame page=idh_prop_frame_1
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_2
3 Button
4 About buttons=fobjprop_button_about
4 To place a button on a form=fobjprop_button_place>taskwin
4 To select a button type=fobjprop_button_type>taskwin
4 To select a button style=fobjprop_button_style>taskwin
4 To place a label on a button=fobjprop_button_label>taskwin
4 To place a graphic on a button=fobjprop_button_graphic>taskwin
4 To edit button events and methods=fobjprop_button_attach_method>taskwin
4 Button properties
5 General page=idh_prop_general_7
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_4
3 Field
4 About field objects=fobjprop_field_about
4 To place a field on a form or report=fobjprop_field_place>taskwin
4 Specifying the functionality of a field object
5 Labeled and Unlabeled field objects=fobjprop_field_labeled
5 Drop-Down Edit field objects=fobjprop_field_dropdown
5 List field objects=fobjprop_field_list
5 Radio Button field objects=fobjprop_field_radio
5 Check Box field objects=fobjprop_field_checkbox
5 To specify a field object's display type=fobjprop_field_specify_display_type>taskwin
5 To change the values for a drop-down edit, list, radio button, or check box field object=fobjprop_field_change_values>taskwin
5 To change a label without changing the field value=fobjprop_field_change_label>taskwin
4 Special fields
5 About special fields=fobjprop_field_about_special
5 To place a special field on a form or report=fobjprop_field_place_special>taskwin
4 Formatting data
5 About pictures=tcreate_about_pictures
5 To align text=fobjprop_text_align>taskwin
5 To specify the line spacing for text=fobjprop_text_line_spacing>taskwin
5 To use word wrap=fobjprop_text_word_wrap>taskwin
5 To specify the format for numeric data=tlook_specify_numeric_format>taskwin
4 Scroll bars on field objects
5 About scroll bars in forms=fobjects_about_scrollbars_forms
5 About scroll bars in reports=fobjects_about_scrollbars_reports
5 To place a scroll bar=fobjects_place_scrollbar>taskwin
5 To change the width of a scroll bar=fobjects_scrollbar_width>taskwin
4 Calculated fields
5 About calculated fields=fobjprop_field_calc_about
5 Referring to fields and field objects=fobjprop_field_calc_field_references
5 Calculated fields and summary fields=fobjprop_field_calc_vs_summary
5 What calculated fields can include=fobjprop_field_calc_include
5 Creating calculated fields
6 To create a calculated field=fobjprop_field_calc_create>taskwin
6 To use a field name in a calculation=fobjprop_field_calc_field_name>taskwin
6 To calculate on a field that has a punctuated name=fobjprop_field_calc_field_name_punctuation>taskwin
6 To reference another calculated field on the same form or report=fobjprop_field_calc_reference_same>taskwin
6 To update calculated fields when opening a form or report with a different table=fobjprop_open_form_different_table>taskwin
6 Examples
7 Example of calculating with a summary operator=fobjprop_field_calc_summary_example>codewin
7 Example of calculating with a field and a constant=fobjprop_field_calc_constant_example>codewin
7 Example of calculating with an alpha string=fobjprop_field_calc_alpha_example>codewin
7 Example of using conditional logic and ObjectPAL methods=fobjprop_field_calc_conditional>codewin
6 Dialog boxes
7 Define Field Object dialog box=idh_dial_deffield
5 Aligning a calculated field
6 To align a calculated field with data in a column of a table frame in a report=fobjprop_field_calc_align>taskwin
5 Calculated fields and printing
6 To control page numbering with a calculated field=fobjprop_field_calc_page_numbering>taskwin
6 To use a calculated field to print only fields containing data=fobjprop_field_calc_print_data>taskwin
6 To use a calculated field to capitalize fields when printing=fobjprop_field_calc_capitalize>taskwin
6 To print in the page footer only on the last page=fobjprop_field_calc_last_footer>taskwin
6 To print a calculation formula=fobjprop_field_calc_print_formula>taskwin
5 Number methods in calculated fields
6 About using number methods in calculated fields=fobjprop_field_calc_about_numeric_procedures
6 To round a value to a specific number of decimal places=fobjprop_field_calc_round_decimal>taskwin
6 To round a value to the nearest whole number=fobjprop_field_calc_round_whole>taskwin
6 To format a decimal value as a whole number=fobjprop_field_calc_format_whole>taskwin
6 To derive a fractional part of a numeric value=fobjprop_field_calc_fractional>taskwin
6 To find the higher of two values=fobjprop_field_calc_higher_of_two>taskwin
6 To ensure numeric answers from calculations on numeric values=fobjprop_field_calc_ensure_integers>taskwin
5 Date and time calculations
6 To find the difference, in days, between two dates=fobjprop_field_calc_subtract_dates>taskwin
6 To find the difference, in hours and minutes, between two times=fobjprop_field_calc_subtract_times>taskwin
6 To calculate a date based on the current date=fobjprop_field_calc_current_date>taskwin
4 Summary fields
5 About summary fields=fobjprop_field_summaries_about
5 About summary scope=fobjprop_field_summaries_scope
5 About summary scope on single-table reports=fobjprop_field_summaries_scope_reports_single
5 About summary scope on multi-table reports=fobjprop_field_summaries_scope_reports_multi
5 To define a summary=fobjprop_field_summaries_define>taskwin
5 To return a summary value relative to a particular page=fobjprop_field_summaries_return_page>taskwin
5 Examples
6 Example of creating an Avg summary on a single-table form=fobjprop_field_summaries_creating_avg_example>codewin
6 Example of defining the summary scope of a multi-table form=fobjprop_field_summaries_multi_table_scope_example>codewin
6 Example of creating a count summary in a report=fobjprop_field_summaries_count_example>codewin
5 Dialog boxes
6 Define Field Object dialog box=idh_dial_deffield
4 Memo fields
5 To display complete contents of a memo field=fobjprop_field_complete_memo>taskwin
4 Filtering a field
5 About filters=tfilter_about_filters
5 To filter a field=tfilter_filter_field>taskwin
5 To filter more than one field=tfilter_filter_multiple_fields>taskwin
5 To remove a filter=tfilter_remove_filter>taskwin
4 Printing options
5 To delete an empty field or record when printing a report=fobjprop_field_delete_empty>taskwin
5 To set printing preferences for group headers=frdesign_band_group_printing>taskwin
5 To set printing preferences for objects in group headers=frdesign_band_group_printing_objects>taskwin
4 Protecting and hiding data in a field
5 To make a field read only=fobjprop_field_read_only>taskwin
5 To hide a field's contents=fobjprop_field_hide_contents>taskwin
4 Field properties
5 General page=idh_prop_general_6
5 Pattern page=idh_prop_pattern_1
5 Frame page=idh_prop_frame_1
5 Font page=idh_prop_font_1
5 Text page=idh_prop_text_1
5 Format page=idh_prop_format_1
5 Picture page=idh_prop_picture_1
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_4
5 Run Time page (reports)=idh_prop_runtimer_1
3 Table/Table frame
4 About table frames=fobjprop_table_about
4 To place a table frame on a form or report=fobjprop_table_place>taskwin
4 To define a table frame=fobjprop_table_define>taskwin
4 To delete an empty field or record when printing a report=fobjprop_field_delete_empty>taskwin
4 To set printing preferences for group headers=frdesign_band_group_printing>taskwin
4 To set printing preferences for objects in group headers=frdesign_band_group_printing_objects>taskwin
4 To repeat a table header in a report=fobjprop_table_repeat_header>taskwin
4 To show all records and columns=fobjprop_table_show_all>taskwin
4 To modify a table frame
5 About modifying table frames=fobjprop_table_modify_about
5 To change the appearance of items in a table frame=fobjprop_table_modify_appearance>taskwin
5 To specify grid style for a table frame=fobjprop_table_change_grid>taskwin
5 To rearrange the parts of a table frame=fobjprop_table_modify_rearrange>taskwin
5 To add data and design objects to a table frame=fobjprop_table_modify_add_objects>taskwin
5 To combine (stack) fields in a column=fobjprop_field_stack>taskwin
5 Example of combining fields in a column of a table frame=fobjprop_field_stack_example>codewin
5 Example of placing design objects in a table frame=fobjprop_table_place_objects>codewin
4 Scroll bars on table frames
5 About scroll bars in forms=fobjects_about_scrollbars_forms
5 About scroll bars in reports=fobjects_about_scrollbars_reports
5 To place a scroll bar=fobjects_place_scrollbar>taskwin
5 To change the width of a scroll bar=fobjects_scrollbar_width>taskwin
4 Dialog boxes
5 Define Table Object dialog box=idh_dial_deftable
4 Table properties
5 General page=idh_prop_general_8
5 General page (multiple objects in a table)=idh_prop_general_17
5 Pattern page=idh_prop_pattern_1
5 Grid page=idh_prop_grid_2
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_2
5 Run Time page (reports)=idh_prop_runtimer_3
3 Multi-record object
4 About multi-record objects=fobjprop_mro_about
4 To place a multi-record object on a form or report=fobjprop_mro_place>taskwin
4 To define a multi-record object=fobjprop_mro_define>taskwin
4 To specify the record layout of a multi-record object=fobjprop_mro_record_layout>taskwin
4 To specify the field layout of a multi-record object=fobjprop_mro_field_layout>taskwin
4 Resizing records in a multi-record object
5 To resize records in a multi-record object=fobjprop_mro_resize_records>taskwin
5 To expand or contract records in a multi-record object=fobjprop_mro_expand_records>taskwin
5 To show all records and columns=fobjprop_table_show_all>taskwin
5 Example of expanding or contracting records in a multi-record object=fobjprop_mro_expand_records_example>codewin
4 Scroll bars on multi-record objects
5 About scroll bars in forms=fobjects_about_scrollbars_forms
5 About scroll bars in reports=fobjects_about_scrollbars_reports
5 To place a scroll bar=fobjects_place_scrollbar>taskwin
5 To change the width of a scroll bar=fobjects_scrollbar_width>taskwin
4 Printing options
5 To delete an empty field or record when printing a report=fobjprop_field_delete_empty>taskwin
5 To set printing preferences for group headers=frdesign_band_group_printing>taskwin
5 To set printing preferences for objects in group headers=frdesign_band_group_printing_objects>taskwin
4 Multi-record object properties
5 Multi-record object
6 General page=idh_prop_general_2
5 General page (multiple objects in an MRO)=idh_prop_general_17
6 Record layout page (forms)=idh_prop_layout_1
6 Record layout page (reports)=idh_prop_layout_2
6 Pattern page=idh_prop_pattern_1
6 Frame page=idh_prop_frame_1
6 Design page=idh_prop_design_1
6 Run Time page (forms)=idh_prop_runtimef_2
6 Run Time (reports)=idh_prop_runtimer_3
5 Record (in MRO)
6 General page=idh_prop_general_1
6 Pattern page=idh_prop_pattern_1
6 Frame page=idh_prop_frame_1
6 Design page=idh_prop_design_1
6 Run Time page (forms)=idh_prop_runtimef_2
6 Run Time page (reports)=idh_prop_runtimer_1
3 Notebook
4 About notebooks=fobjprop_notebook_about
4 To place a notebook on a form=fobjprop_notebook_place>taskwin
4 To select a notebook or a notebook page=fobjprop_notebook_select>taskwin
4 To place an object on a notebook page=fobjprop_notebook_place_object>taskwin
4 To navigate notebook pages=fobjprop_notebook_navigate>taskwin
4 Example of a form that uses a notebook object=fobjprop_notebook_about_example>codewin
4 Adding and removing notebook pages
5 To add a page to a notebook=fobjprop_notebook_add_pages>taskwin
4 To rotate notebook pages=fobjprop_notebook_rotate_pages>taskwin
5 To delete a notebook page=fobjprop_notebook_delete_page>taskwin
4 Changing the appearance of a notebook
5 To move or resize a notebook=fobjprop_notebook_move>taskwin
5 To change the tab height on a notebook=fobjprop_notebook_tab_height>taskwin
5 To place a scroll bar on a notebook=fobjprop_notebook_scroll>taskwin
5 To copy and paste a notebook page=fobjprop_notebook_copy_page>taskwin
4 Notebook properties
5 Notebook
6 General page=idh_prop_general_9
6 Design page=idh_prop_design_1
6 Run Time page=idh_prop_runtimef_2
5 Notebook page
6 General page=idh_prop_general_1
6 Inactive Color page=idh_prop_inactive_1
6 Design page=idh_prop_design_1
6 Run Time page=idh_prop_runtimef_2
3 Chart
4 About charts=fchart_about
4 To place a chart on a form or report=fchart_place>taskwin
4 Chart properties
5 About chart properties=fchart_about_chart_properties
5 About chart area properties=fchart_about_chart_area_properties
5 To change chart properties=fchart_properties>taskwin
5 General page=idh_prop_general_1
5 Frame page=idh_prop_frame_1
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_2
5 Run Time page (reports)=idh_prop_runtimer_1
3 Crosstab
4 About crosstabs=fcrosstb_crosstab_about
4 To place a crosstab on a form or report=fcrosstb_place>taskwin
4 Crosstab properties
5 To change crosstab properties=fcrosstb_properties>taskwin
5 General page=idh_prop_general_2
5 Grid page=idh_prop_grid_2
5 Design page=idh_prop_design_1
5 Run Time page (forms)=idh_prop_runtimef_2
5 Run Time page (reports)=idh_prop_runtimer_1
2 Designing forms
3 About designing forms=ffdesign_about
3 Form Design Toolbar=idh_formt_tool
3 Creating a form
4 About creating forms=fabout_about_creating
4 To create a form using the experts=fabout_create_with_expert>taskwin
4 To use a quick form=ffuse_quick>taskwin
4 To use a default form=ffuse_default>taskwin
4 To create a blank form=ffdesign_blank>taskwin
4 To create a form using a data model=fabout_create_data_model>taskwin
4 To modify an existing form=ffdesign_modify_existing>taskwin
4 Dialog boxes
5 Choose Preferred Form dialog box=idh_dial_prefform
5 Preferences dialog box=idh_dial_formrep_pref
3 Page size and layout
4 About page layout for forms=ffdesign_page_layout_form_about
4 To change the page layout for a form=ffdesign_page_layout_change>taskwin
4 To specify a default on-screen size=ffdesign_page_layout_default_screen_size>taskwin
4 Dialog boxes
5 Page Layout dialog box=idh_formt_playo
3 Multi-page forms
4 About multi-page forms=ffdesign_multi_page_about
4 To add a form page=ffdesign_multi_page_add>taskwin
4 To cut, copy, or paste a form page=ffdesign_multi_page_copy>taskwin
4 To delete a form page=ffdesign_multi_page_delete>taskwin
4 To rotate form pages=ffdesign_multi_page_rotate>taskwin
4 To tile form pages=ffdesign_multi_page_tile>taskwin
4 To move among form pages=ffdesign_multi_page_navigate>taskwin
3 Specifying the form window style
4 About forms as windows=ffdesign_windows
4 About forms as dialog boxes=ffdesign_dialog_boxes
4 To specify form window style=ffdesign_window_style>taskwin
4 Dialog boxes
5 Window Style dialog box=idh_dial_winstyle
3 Tab order
4 About tab order of design objects on a form=ffdesign_tab_about
4 To change the design window tab order=ffdesign_tab_design>taskwin
4 To change run-time tab order=ffdesign_tab_runtime>taskwin
3 Viewing (running) a form
4 To run a form=ffdesign_run>taskwin
4 To view a form with a different table=ffdesign_view_different_table>taskwin
4 Example of opening a form with a different table=ffdesign_view_different_table_example>codewin
3 Designing a form from a report
4 About forms based on reports=ffdesign_from_report_about
4 To design a form from a report=ffdesign_from_report>taskwin
3 Delivering a form
4 About delivering forms=ffdesign_deliver_about
4 To deliver a form=ffdesign_deliver>taskwin
3 Printing a form
4 To print a form's design=ffdesign_print_design>taskwin
4 To print a form's records=ffdesign_print_records>taskwin
4 Dialog boxes
5 Print File dialog box=idh_dial_prform
3 Form and page properties
4 To change a form's properties=ffdesign_properties>taskwin
4 To change a form page's properties=ffdesign_properties_page>taskwin
4 Form properties
5 General page=idh_prop_general_13
5 Pattern page=idh_prop_pattern_1
4 Page properties
5 General page=idh_prop_general_1
5 Pattern page=idh_prop_pattern_1
5 Design page=idh_prop_design_1
5 Run Time page=idh_prop_runtimef_2
2 Using forms
3 About running forms=ffuse_about
3 Form Toolbar=idh_formt_spbar
3 Opening a form
4 To use a quick form=ffuse_quick>taskwin
4 To use a default form=ffuse_default>taskwin
4 To run an existing form=ffuse_existing>taskwin
3 Moving around a form
4 Table and form navigation buttons=tview_table_navigation_buttons
4 To move among fields on a form=ffuse_navigate_fields>taskwin
4 To move among records on a form=ffuse_navigate_records>taskwin
4 To move among table objects in a multi-table form=ffuse_navigate_table_objects>taskwin
4 To move among form pages=ffdesign_multi_page_navigate>taskwin
3 Locating records, fields, or values
4 About locating records or values=dfind_about_locating_records
4 To locate a record number=dfind_to_locate_record_number>taskwin
4 To locate a value in a field=dfind_to_locate_field_value>taskwin
4 To locate and replace values in a field=dfind_to_locate_replace_field_values>taskwin
4 To locate the next record with the defined value=dfind_to_locate_next>taskwin
4 Dialog boxes
5 Locate Field dialog box=idh_formt_locfie
5 Locate Record Number dialog box=idh_formt_locrec
5 Locate Value dialog box=idh_formt_locval
5 Locate and Replace dialog box=idh_formt_locrep
5 Found A Match dialog box=idh_formt_found
3 Entering and editing data
4 About entering and editing data=denter_about_entering_editing
4 About Field View=dmodenav_about_field_view
4 About Persistent Field View=dmodenav_about_persistent_field_view
4 To enter or edit data in a Form window=dbasic_to_edit_form_window>taskwin
4 Memo data
5 About editing memos and formatted memos=dspecial_about_editing_memos
5 About Memo View=dspecial_about_memo_view
5 To enter Memo View from a form=dspecial_to_enter_memo_view_form>taskwin
5 To enter memo data=dspecial_to_enter_memo_data>taskwin
5 To wrap memo field text in a Form window=dspecial_to_wrap_memo_in_form>taskwin
3 Filtering data
4 About filters=tfilter_about_filters
4 Ranges or filters on a quick form=tfilter_ranges_quick_form
4 To filter a field=tfilter_filter_field>taskwin
3 Changing the appearance of the Form window
4 To zoom forms=fdeswin_zoom>taskwin
4 To prevent screen flashing=ffuse_flicker>taskwin
4 To save Form window settings=ffuse_save_settings>taskwin
3 The source table
4 To view a form's source table=ffuse_source_table>taskwin
2 Designing reports and mailing labels
3 About designing reports=ffdesign_about
3 Report Design Toolbar=idh_reptt_tool
3 Creating a report
4 About creating reports=fabout_about_creating
4 To create a report using the experts=fabout_create_with_expert>taskwin
4 To use a quick report=ffuse_quick>taskwin
4 To use a default report=ffuse_default>taskwin
4 To create a blank report=ffdesign_blank>taskwin
4 To create a report using a data model=fabout_create_data_model>taskwin
4 To modify an existing report=ffdesign_modify_existing>taskwin
4 Dialog boxes
5 Choose Preferred Report dialog box=idh_dial_prefrept
5 Preferences dialog box=idh_dial_formrep_pref
3 Page size and layout
4 About page layout for reports=ffdesign_page_layout_form_about
4 To change the page layout for a report=ffdesign_page_layout_change>taskwin
4 Dialog boxes
5 Page Layout dialog box=idh_reptt_playo
3 Bands
4 About bands=frdesign_band_about
4 To show band labels=frdesign_band_show_labels>taskwin
4 To select a band=frdesign_band_select>taskwin
4 To resize a band=frdesign_band_resize>taskwin
4 To delete a band=frdesign_band_delete>taskwin
4 Report bands
5 About report bands=frdesign_band_report_about
5 To change the header order=frdesign_band_report_order>taskwin
4 Page bands
5 About page bands=frdesign_band_page_about
5 To suppress the header or footer on the first page=frdesign_band_page_suppress_first>taskwin
5 To print in the page footer only on the last page=fobjprop_field_calc_last_footer>taskwin
4 Record bands
5 About record bands=frdesign_band_record_about
5 To start page numbers at one when a band is reached=frdesign_band_record_start_at_one>taskwin
5 To sort records in a record band=frdesign_band_record_sort>taskwin
5 Dialog boxes
6 Sort Record Band dialog box=idh_mod_dial_sortrecband
4 Group bands
5 About group bands=frdesign_band_group_about
5 To add a group band=frdesign_band_group_add>taskwin
5 To define a group band=frdesign_band_group_define>taskwin
5 To rearrange group bands=frdesign_band_group_rearrange>taskwin
5 To group by a field value=frdesign_band_group_field>taskwin
5 To group by a number of records=frdesign_band_group_number>taskwin
5 Grouping by a range
6 About grouping by a range=frdesign_band_group_range_about
6 To group by a range=frdesign_band_group_range>taskwin
6 Example of grouping by a range on a numeric field=frdesign_band_group_range_numeric>codewin
6 Example of grouping by a range on an alpha field=frdesign_band_group_range_alpha>codewin
5 Layout preferences
6 To start page numbers at one when a band is reached=frdesign_band_record_start_at_one>taskwin
6 To set printing preferences for group headers=frdesign_band_group_printing>taskwin
6 To set printing preferences for objects in group headers=frdesign_band_group_printing_objects>taskwin
6 To specify the sort order for a group=frdesign_band_group_sort>taskwin
6 To suppress repeated group values=frdesign_band_group_repeats>taskwin
5 Dialog boxes
6 Define Group dialog box=idh_dial_defgrp
6 Sort Record Band dialog box=idh_mod_dial_sortrecband
3 Page breaks
4 About the sidebar=frdesign_sidebar_about
4 To insert or remove a page break in a report=frdesign_page_insert>taskwin
3 Expanded and pushed objects
4 About expanding, contracting, pushing, and pulling of objects in reports=frdesign_expand_about
4 Controlling pushed objects with lines=fobjprop_line_pushed_objects
4 To prevent expanding and contracting when running a report=frdesign_expand_fit>taskwin
4 To pin design objects at run time=frdesign_expand_pin>taskwin
4 Examples
5 Example of preventing pushing and pulling=frdesign_expand_pin_example>codewin
5 Example of invisible lines aligning pushed objects=frdesign_expand_line_example>codewin
5 Example of a horizontal line pushing objects down=frdesign_expand_horizontal_line_example>codewin
5 Example of a box pushing or pulling contained objects=frdesign_expand_box_example>codewin
5 Example of an expanded box and a fixed line pushing or pulling contained objects=frdesign_expand_box_and_line_example>codewin
5 Example of a container keeping objects together=frdesign_expand_container_example>codewin
3 Filtering data
4 About filters=tfilter_about_filters
4 To filter a field=tfilter_filter_field>taskwin
3 Mailing labels
4 About multi-record objects=fobjprop_mro_about
4 To create a mailing label report using the experts=fabout_create_with_expert>taskwin
4 To create mailing labels using the Report Design window=frdesign_labels_create>taskwin
3 Merging data into a form letter
4 To merge data using the Merge Expert=frdesign_merge_expert>taskwin
3 Designing a form from a report
4 About reports based on forms=frdesign_from_form_about
4 To design a report from a form=frdesign_from_form>taskwin
3 Delivering a report
4 About delivering reports=ffdesign_deliver_about
4 To deliver a report=ffdesign_deliver>taskwin
3 Report and band properties
4 To change a report's properties=frdesign_properties>taskwin
4 To change a band's properties=frdesign_properties_band>taskwin
4 Report properties
5 General page=idh_prop_general_14
5 Pattern page=idh_prop_pattern_1
4 Band properties
5 Report Band
6 General page=idh_prop_general_11
6 Run Time page=idh_prop_runtimer_1
5 Page Band
6 General page=idh_prop_general_11
5 Record Band
6 General page=idh_prop_general_11
6 Run Time page=idh_prop_runtimer_1
5 Group Band
6 General page=idh_prop_general_12
6 Run Time page=idh_prop_runtimer_1
2 Printing and previewing reports
3 Previewing a report
4 Report Toolbar=idh_reptt_spbar
4 Report navigation buttons=frprint_navigation_buttons
4 To preview a report=frprint_preview>taskwin
4 To size the Report window to the fit the report's design=frprint_window_size>taskwin
4 To display a custom menu when previewing a report=frprint_custom_menu>taskwin
4 Dialog boxes
5 Go To Page dialog box=idh_dial_gotopage
3 Printing a report to a printer
4 To print a report=frprint_print>taskwin
4 To print a report's design=frprint_print_design>taskwin
4 To print a report when another user is changing the data=frprint_restart_options>taskwin
3 Printing or previewing a report with a different table
4 About using a report with a different table=frprint_about_using_different_table
4 To print or preview a report with a different table=frprint_different_table>taskwin
3 Printing a report to a file
4 About printing a report to a file=frprint_to_file_about
4 To print to a file=frprint_to_file>taskwin
3 Dialog boxes
4 Print File dialog box=idh_dial_exprfile
4 Restart Options dialog box=idh_dial_rrestart
1 Charts and crosstabs
2 About charts and crosstabs=fcrosstb_about
2 Queries behind charts and crosstabs=fcrosstb_queries_behind
2 Charts
3 About charts=fchart_about
3 Chart data types=fchart_datatype
3 Multi-table charts=fchart_multi_table
3 Charts of detail tables=fchart_detail_tables
3 Creating a chart
4 To use a quick chart=fchart_quick>taskwin
4 To place a chart on a form or report=fchart_place>taskwin
3 Defining a chart
4 About y-axis values=fchart_y_axis_about
4 To define a chart=fchart_define>taskwin
4 To define a series=fchart_series>taskwin
4 To specify an additional group field in a 2-D summary chart=fchart_additional_group>taskwin
4 Dialog boxes
5 Define Chart dialog box=idh_dial_defgraph
3 Modifying a chart
4 To change a chart's type=fchart_type>taskwin
4 To change a chart's data type=fchart_datatype_change>taskwin
4 To change a chart's x-axis=fchart_x_axis_change>taskwin
4 To change a chart's y-axis=fchart_y_axis_change>taskwin
4 To change a chart's z-axis=fchart_z_axis_change>taskwin
4 To change a chart's title=fchart_title>taskwin
4 To change a chart's background=fchart_background>taskwin
4 To remove fields from a chart=fchart_remove_fields>taskwin
4 To control the number of groups (series) a 2-D summary chart displays=fchart_number_of_groups>taskwin
4 To change the order of y-value fields on a chart=fchart_change_field_order>taskwin
3 Changing the appearance of a chart
4 To change a chart's fonts=fchart_font_palette>taskwin
4 To change a chart's color and transparency=fchart_color_palette>taskwin
4 To create custom colors for a chart=fchart_custom_color>taskwin
3 Chart properties
4 About chart properties=fchart_about_chart_properties
4 About chart area properties=fchart_about_chart_area_properties
4 To change chart properties=fchart_properties>taskwin
4 Example of chart areas=fchart_about_chart_properties_example>codewin
4 General page=idh_prop_general_1
4 Frame page=idh_prop_frame_1
4 Design page=idh_prop_design_1
4 Run Time page (forms)=idh_prop_runtimef_2
4 Run Time page (reports)=idh_prop_runtimer_1
2 Crosstabs
3 About crosstabs=fcrosstb_crosstab_about
3 Types of crosstabs
4 One-dimensional crosstabs=fcrosstb_1d
4 Two-dimensional crosstabs=fcrosstb_2d
4 Multi-table crosstabs=fcrosstb_multi_table
4 Crosstabs of detail tables=fcrosstb_detail_tables
3 Creating a crosstab
4 To use a quick crosstab=fcrosstb_quick>taskwin
4 To place a crosstab on a form or report=fcrosstb_place>taskwin
3 Defining a crosstab
4 To define a crosstab=fcrosstb_define>taskwin
4 To define the fields of a crosstab=fcrosstb_define_fields>taskwin
4 To specify column headings for a crosstab=fcrosstb_column_headings>taskwin
4 To specify row headings (categories) for a crosstab=fcrosstb_row_headings>taskwin
4 To specify summary fields for a crosstab=fcrosstb_summary_data>taskwin
4 To specify a summary operation for a crosstab=fcrosstb_summary_operation>taskwin
4 Dialog boxes
5 Define Crosstab dialog box=idh_dial_defcross
3 Running a crosstab
4 To run a crosstab=fcrosstb_run>taskwin
3 Modifying a crosstab
4 To change the appearance of a crosstab=fcrosstb_appearance>taskwin
4 To change the size of a crosstab=fcrosstb_size>taskwin
4 To rearrange category and summary fields on a crosstab=fcrosstb_rearrange>taskwin
4 To remove a field from a crosstab=fcrosstb_remove_field>taskwin
3 Saving a crosstab to a table
4 To save a crosstab to a table=fcrosstb_save_to_table>taskwin
3 Crosstab properties
4 To change crosstab properties=fcrosstb_properties>taskwin
4 General page=idh_prop_general_2
4 Grid page=idh_prop_grid_2
4 Design page=idh_prop_design_1
4 Run Time page (forms)=idh_prop_runtimef_2
4 Run Time page (reports)=idh_prop_runtimer_1
1 SQL
2 About SQL=idh_sql_intr
2 SQL terminology=idh_tsql_term
2 Accessing SQL data
3 Preparing to connect to an SQL database=idh_tsql_prep
3 Connecting to the SQL server=idh_tsql_connect
3 SQL-enabled Paradox
4 Changes in the Desktop=idh_SQL_changes
4 Using Table windows=idh_SQL_tables
4 Using Form windows=idh_SQL_forms
4 Changes in QBE=idh_SQL_QBE
3 Querying SQL data
4 About querying SQL data=idh_tsql_querying_data
4 Using QBE to Query SQL Data=idh_SQL_queryQBE
4 Using pass-through SQL=idh_SQL_queryPASSTHRU
2 Creating and restructuring SQL tables
3 Creating an SQL table=idh_tsql_create
3 Creating indexes on SQL tables=idh_tsql_createindex
3 Restructuring an SQL table=idh_tsql_restructure
2 Using the SQL Editor
3 About the SQL Editor=tsql_editor_about_editor
3 To open the SQL Editor=idh_sql_editor_opening>taskwin
3 To move around the SQL Editor with the keyboard=tsql_editor_move_around_editor_keyboard>taskwin
3 To select text in the SQL Editor=tsql_editor_select_text>taskwin
3 To search for text in the SQL Editor=tsql_editor_search_for_text>taskwin
3 To exit the SQL Editor=tsql_editor_leave_editor>taskwin
2 Creating and using SQL statements
3 About SQL statements=tsql_sql_statements_about
3 To specify an alias in the SQL Editor=idh_sql_editor_specifyingalias>taskwin
3 To enter an SQL statement=idh_sql_editor_enteringsql>taskwin
3 To run an SQL statement=idh_sql_editor_runningsql>taskwin
3 To save an SQL statement=idh_sql_editor_savingsql>taskwin
3 To view the SQL translation of a QBE query=idh_sql_editor_qbetrans>taskwin
2 Using Local SQL
3 About Local SQL=idh_tsql_local_intro
3 Naming conventions=tsql_namingconventions
3 Data Manipulation Language (DML)
4 About Data Manipulation Language (DML) statements=tsql_datamanipulation
4 Live query views=tsql_updateablequeries
4 Heterogeneous joins=tsql_heterogeneousjoins
4 DML statements
5 INSERT=tsql_insert
5 UPDATE=tsql_update
5 DELETE=tsql_delete
5 SELECT=tsql_select
5 SELECT clauses
6 FROM clause=tsql_fromclause
6 WHERE clause=tsql_whereclause
6 ORDER BY clause=tsql_orderbyclause
6 GROUP BY clause=tsql_groupbyclause
6 HAVING clause=tsql_havingclause
6 UNION clause=tsql_unionclause
4 Functions and operators
5 Aggregate functions=tsql_aggregatefunctions
5 String functions=tsql_stringfunctions
5 Date functions=tsql_datefunction
5 Operators=tsql_operators
4 DML examples
5 DML examples=tsql_dmlexamples
3 Data Definition Language (DDL)
4 About Data Definition Language (DDL) statements=tsql_datadefinition
4 DDL statements
5 CREATE TABLE=tsql_createtable
5 ALTER TABLE=tsql_altertable
5 DROP TABLE=tsql_droptable
5 CREATE INDEX=tsql_createindex
5 DROP INDEX=tsql_dropindex
5 CREATE VIEW=tsql_createview
4 DDL examples
5 DDL examples=tsql_ddlexamples
2 Order forms
3 Ordering a SQL Links disk set=sql_orderform
1 General reference
2 Glossary=idh_glossary
2 Keyboard shortcuts
3 About keyboard commands=idh_keyb_intr
3 General shortcuts
4 Menu command keys=idh_keyb_menu
4 Application access keys=idh_keyb_appl
4 Control menu keys=idh_keyb_cont
4 Help system keys=idh_keyb_help
4 Dialog box keys=idh_keyb_dial
3 Shortcuts in tables and forms
4 Navigation and selection keys=idh_keyb_padcombo
4 Table operation shortcuts=idh_keyb_tablop
4 Form window shortcuts=idh_keyb_desnop
4 Edit mode keys=idh_keyb_edit
4 Memo View keys=idh_keyb_memo
3 Function key actions
4 Function keys in tables=idh_keyb_funckeytb
4 Function keys in forms=idh_keyb_funckeyfm
4 Function keys in queries=idh_keyb_funckeyqu
4 Function keys in the Editor and Debugger windows=idh_keyb_funckeyob
3 Special procedures
4 Rotating columns in a table=idh_keyb_rota
4 Selecting multiple fields=idh_keyb_multsel
4 Super Tab operations=idh_keyb_supertab
2 Toolbars
3 About Toolbars=bbasics_about_toolbars
3 To display additional Toolbars=bbasics_to_display_additional_toolbar>taskwin
3 To move and dock Toolbars=bbasics_to_move_toolbar>taskwin
3 Standard Toolbars
4 Empty Desktop/Project Viewer Toolbar=idh_speed_desktop
4 Form Toolbar=idh_formt_spbar
4 Form Design Toolbar=idh_formt_tool
4 Library Toolbar=idh_librt_tool
4 ObjectPAL Editor Toolbar=idh_speed_pal_editor
4 Query Toolbar=idh_qbet_tool
4 Report Toolbar=idh_reptt_spbar
4 Report Design Toolbar=idh_reptt_tool
4 SQL Editor Toolbar=idh_sql_edbar
4 Table Toolbar=tview_table_window_toolbar
3 Global Toolbar
4 Global Toolbar=idh_global_tool
3 Object Toolbar
4 Object Toolbar=idh_formt_ole_tool
3 Align Toolbar
4 Align Toolbar=idh_align_tool
3 Text Formatting Toolbar
4 Text Formatting Toolbar=idh_textformatting_tool
3 ObjectPAL Debugger Toolbar
4 ObjectPAL Debugger Toolbar=idh_pals_debar
3 Data Model Designer Toolbar
4 Data Model Designer Toolbar=idh_dmd_speed
2 Product support information
3 Product support information=bsupport_product_support
2 Answers to common questions
3 What comparison operators are allowed in expression indexes on dBASE tables?=banswers_compatibility_with_dbase
3 What functions are allowed in expression indexes on dBASE tables?=banswers_compatibility_with_dbase_functions
3 Can I use Paradox to create a maintained index for a dBASE table that is a dBASE III Plus level?=banswers_compatibility_with_dbase_indexes
2 International topics
3 International issues=bconfig_international_issues
3 Preparation and assumptions=bconfig_preparation_assumptions
3 Sorting conventions=bconfig_sorting_conventions
3 Character set issues=bconfig_character_set_issues
3 Working with tables using different language drivers=bconfig_different_language_drivers
3 Data formats=bconfig_data_formats
3 Internal data conversion=bconfig_internal_data_conversion
3 To prevent character conversion=bconfig_prevent_character_conversion>taskwin
3 To change the default language drivers=bconfig_to_change_default_language_driver>taskwin
3 To change a table's language driver=bconfig_to_change_table_language_driver>taskwin
1 ObjectPAL Reference
2 ObjectPAL Reference=!EF("opal.hlp")