• Introduction
• Requirements
  • BDE and Windows settings
    • BDE Driver settings
    • BDE System settings
    • BDE and Windows Registry
    • BDE DLL path
    • BDE and Windows 11
    • BDE Initialization Error
  • Where to get the BDE
  • Paradox max. path length
• Application window
  • Top panel and Status bar
  • Columns
• Database
  • Selecting a database
  • Default table format
  • Paradox NET-file directory
  • Sharing with other apps
• Tables
  • Table open
  • Data table formats
    • Paradox
      • Paradox table format
      • Paradox Locks
        • Paradox locks in depth
      • Paradox 5 > 7 upd.
    • dBASE
      • dBASE table format
      • dBASE/FoxPro numerics
        • dBASE NUMERIC vs FLOAT
      • dBASE detach Index Link
      • Revert a dBASE 7 table to dBase 5
      • SQL to dBASE to SQL
      • dBASE IV/5 to 7 issues
        • BDE Employee sample
      • dBASE IV/5 to 7 propagation
      • Paradox to dBASE transfer
        • Paradox to dBASE5
    • FoxPro
      • FoxPro table format
    • Numerics, NULLs
      • NULL values
      • Numerics/NULLs in dBASE apps
      • The BCD data type
    • 3. party import
      • Imports from Paradox
      • Imports from dBase
  • Table field types
    • Autoinc/Primary Key Fields
      • AutoInc INSERT test
      • dBASE7 Primary Key
    • Money/Currency
    • Binary data fields
      • Specifying BLOB fields
      • Binary import/exports
        • Memo/FmtMemo
          • Memo/RTF
        • Graphics
        • Other BLOB binaries
        • Bytes fields
      • Unicode Memo/FmtMemo
    • Field Types in other apps
      • Paradox Tables
      • dBASE Tables
  • File Restructuring
    • Restructure fields, Basic method
    • Required attribute
      • Restructure Extended, Paradox
      • Restructure Extended-Ref-int
      • Restructure Extended, dBase
    • Primary Key Set/Delete
      • Paradox compound Primary Key
      • Paradox KeyViolation table
      • dBASE adding UNIQUE index/Primary Key issue
      • dBASE INSERT INTO vs. key violation issue
      • INSERT INTO and Primary Keys and Autoinc
  • Table Relations
    • Referential Integrity
    • PdxEditor Referential Integrity
    • Referential Integrity KEYVIOL
    • Referential Integrity w. PdxEditor
    • Referential Integrity - Lifting
    • DBD7 Referential Integrity
    • DBDemos Access
      • Northwind database
  • Table Properties
    • View Table Properties
    • View Validity Checks
  • Table file management
    • Rename current table
    • Copy Table
    • Delete table
  • Generate SQL CREATE
    • Paradox: Reverse SQL CREATE
    • dBASE: Reverse SQL CREATE
      • dBASE: Reverse CREATE modes
      • Recreating dBASE tables
  • Redefining a Table
  • Changing field types
  • Analyse table for MAX length
  • Change language driver
  • Table packing, security issues
  • Register Table Files
  • Reordering column views
  • BDE Data Type Translations
  • Associated table files
• SQL
  • SQL dialog
    • SQL dialog
    • SQL dialog Builder popup
    • SQL Find string
    • SQL tab capacity
    • SQL '--Single line comments'
    • SQL Execution
    • SQL Editor Options
      • SQL storage location
      • Auto space after comma
  • SQL scripts
    • SQL script pre-processing
    • SQL script example
    • SQL script Insert, Delete
    • Mixed multi/single line comments
      • Comment Clean Up Preview
      • Complex comment sample
  • SQL Exec. Auto Conversion
    • Hard Space Auto Conversion
    • En-dash Auto Conversion
    • Single Curly Quotes Conversion
    • Double Curly Quotes Conversion
  • SQL - solving issues
    • Day of Year, Week Number
    • Rounding(Float)
    • Finding duplicates
  • Local SQL
  • SQL Date Format
  • SQL query Field Types
  • SQL data type translation BDE
  • dBASE 2019 SQL data type translation
  • Using Local SQL VIEW-files
  • CURRENT_DATE, CURRENT_TIMESTAMP, NOW()
  • Reverse SQL
  • SQL syntax error
  • SQL access errors
  • What's missing in Local SQL
• Options
  • DBGrid Auto Edit
  • Memo DBGrid Display
    • Memo String Display
    • Memo String Leading Marker
  • DBGrid mS (milli Sec) Display
  • Check Box Logicals
  • Use Form Custom Colours
  • Style DBGrid Drawing
  • Alternating Row Shading
  • Greyed Gridlines
  • DBGrid Font
  • Auto close timer
• Import
  • From BDE Database
    • Table Copy from Paradox database
    • SQL from other BDE Database
  • Import ClientDataSet MyBase
    • AutoInc in ClientDataSet imports
    • ClientDataSet and graphics
  • Delimited text import
    • Importing delimited text
    • CSV-import screen
    • Text data sample display
    • Import decimal separator
    • Import datetime format
    • Field trim
    • Character tags conversion
    • Bytes data
    • Re-Use Target Table
    • Import Error Detection
    • Import limitations
• Export
  • Text export
    • Grid to CSV or tabbed Text export
    • Schema File
      • Generate Schema File
    • ISO format for Date & Time
    • Export Booleans as Integers
    • < and > text conversion
    • Character set encoding
    • Text Export Inclusions
  • Excel export
    • Exporting to Excel
    • Line breaks in Memos to <br>
  • ClientDataSet export XML/CDS
    • ClientDataSet XML Files
    • ClientDataSet AutoInc export issue
    • Paradox to CDS translation
    • XML and MS Access
  • Export Specifications, general
  • Save query result as table
• Print
  • Printing the App window
• Admin
  • Register DB/DBF Files
  • Un-Register Table Files
• Help menu
  • App Help & Local SQL manual
  • Location
  • List of language drivers
• The Help systems
  • HTML Help vs. WebHelp
  • INI-file configuration
• Language drivers
  • Purpose and background
  • Language driver special issues
  • BDE language driver samples
• PdxEditor install & specs
  • PdxEditor specifications
    • Feature Matrix
    • Limitations
  • Installation & INI-file
    • INI-settings
    • INI-file explained
  • PdxEditor and Registry
  • Export specifications
• 3rd party links
  • Paradox table specifications
  • dBASE/xBase table specifications
  • FoxPro tables
  • Database connectivity
  • Repair tools
  • Character Codes
• Other database managers
  • Borland Paradox 7
  • Corel Paradox
  • Borland dBASE
  • dBASE LLC, the dBASE successor
  • Database Desktop
• About PdxEditor
  • Development
  • PdxEditor sources
  • PdxEditor version

Copyright © 2010-2026 Niels Knabe