            PARADOX FOR WINDOWS 4.5 UPGRADE GUIDE
            -------------------------------------

This file summarizes new interactive features and
enhancements to Paradox for Windows 4.5, and describes
performance improvements. To learn about new ObjectPAL
methods, procedures, and properties -- including the SQL-
specific methods -- open the NEWPAL.DB table, which is
placed in your PDOXWIN directory when you install Paradox.
See "Using NEWPAL.DB" later in this document for information
on using this table.


TABLE OF CONTENTS
-----------------

1. SQL Connectivity
2. Using NEWPAL.DB
3. ODAPI Changes
4. Serial Numbers
5. Using the Network Configuration Utility
6. The Desktop Properties Dialog Box
7. The Auto-Append Property
8. Command-Line Options
9. Other Additions and Improvements


1. SQL CONNECTIVITY
-------------------

Paradox is now SQL-enabled. To use Paradox's SQL
connectivity, you must install Borland SQL Link. After you
install Borland SQL Link, a SQL button appears on the
Desktop's SpeedBar, and the commands File|New|SQL File and
File|Open|SQL File become available.

When you use Borland SQL Link, aliases become more powerful.
In addition to creating and using aliases for local or
network directories, you can create and use aliases for
remote databases.

When you install Borland SQL Link you'll be able to use the
Alias Manager dialog box to connect to and disconnect from
SQL servers, and the SQL Editor window to create an
interactive SQL session. See the Paradox Help system,
Borland SQL Link documentation, and Borland SQL Link README
for details.

- SQL Tools:

  When you install Paradox, you have the option of
  installing the SQL Tool SpeedBar, which provides easy
  ways of performing common tasks on SQL data. To install
  the SQL Tool SpeedBar when you're installing Paradox,
  check the Install ObjectPAL Examples checkbox.

  The SQL Tool SpeedBar is installed into the
  C:\PDOXWIN\EXAMPLES directory by default. Refer to the
  SQLTOOL.TXT file for information on using the SpeedBar.

  NOTE: If you are using Paradox from a network
        installation, be aware that only one user at a time
        can access the SQL Tool SpeedBar. If you copy the
        SQL Tool SpeedBar to your local machine, you must
        also edit the [PDOXWIN] section of your WIN.INI.
        Edit the "SQLTDir=" entry to point to the new
        location of of the SQL Tool SpeedBar. When you've
        done that, choosing File|Open|SQL Tools opens the
        local version of the SQL Tool SpeedBar.


2. USING NEWPAL.DB
------------------

The table NEWPAL.DB contains information about all changes
and enhancements to the ObjectPAL language. NEWPAL is
installed into your PDOXWIN directory by default.

NOTE:  Some of the records in this table contain
       information about ObjectPAL methods that apply only
       to users of Borland SQL link. These records are
       identified by a Y in the SQL-Specific field. If you
       are not a licensed user of Borland SQL Link, you can
       either use a query or a filter to remove these
       records from your view of the data.

A form, NEWPAL.FSL, has been provided as an alternate
viewing mode for NEWPAL.DB.

A report, NEWPAL.RSL, has been provided to produce printed
output closely resembling the "ObjectPAL Reference" format.

NOTE:  If you delivered forms in a previous version of
       Paradox for Windows, you must use this version of
       Paradox to open their corresponding .FSL file, then
       recompile and re-deliver them from this version of
       Paradox.


3. ODAPI CHANGES
----------------

- In order to ensure that all Borland products that use
  ODAPI work seamlessly together and require as little disk
  space as possible, the ODAPI files are now stored in a
  central location.

  All files related to ODAPI are now installed in the
  C:\ODAPI directory by default. Paradox creates the
  directory C:\ODAPI if one does not already exist. When
  you install a new ODAPI, your existing settings are
  merged into the new files.

- The ODAPI Configuration Utility has been upgraded. Refer
  to its online Help system for information on configuring
  your ODAPI settings.


4. SERIAL NUMBERS
-----------------

- Serial numbers and user counts are no longer used by
  Paradox. Because of this, Paradox no longer requires you
  to enter a serial number when installing the program, and
  the Serial Number utility is no longer included with
  Paradox.

  If you are not a user of the Paradox for Windows
  Workgroup Edition and want to install Paradox on a
  network, follow the installation instructions in Chapter
  15 of "Getting Started," but disregard any references to
  serial numbers or user counts. If you are a user of the
  Workgroup Edition, see the following section of this
  file.


5. USING THE NETWORK CONFIGURATION UTILITY
----------------------------------------------

If you are a user of the Paradox for Windows Workgroup
Edition, the Network Configuration Utility is available to
you. After Paradox has been installed and properly
configured on a server, the network administrator can run
the Network Configuration Utility on individual workstations
to access the correct configuration.

NOTE:  Some options available in the Network Configuration
       Utility apply to the Workgroup Desktop. If you have
       not installed the Workgroup Desktop, ignore these
       options.

To use the Network Configuration Utility,

1) Install Paradox to the network location of your choice.
   The Paradox Install program creates the NCONFIG.INI file
   in your system directory.

2) Use Notepad or another editor to open NCONFIG.INI. You'll
   see a five-section file. Edit this file to establish the
   default settings you want to use for each workstation you
   configure.

   - [PDOXWIN] contains the following entries:
     - USERNAME: The default user name.
     - COMPANY: The default company name.
     - WORKDIR: The default location for the working
       directory.
     - PRIVDIR: The default location for the private
       directory.
     - WGDir: The default location for Workgroup Desktop
       files.
     - AddrDir: The default location for the Workgroup
       Desktop Address files.

   - [ODAPI] contains one entry that identifies the default
     location for the ODAPI.CFG file.
  
   - [OBEX] contains one entry that identifies the default
     location for the Object Exchange component of the
     Workgroup Desktop.
  
   - [ICONS] lists each program component and a value of 1
     or 0. When you set a program component to 1, the
     component's icon is added to the Paradox for Windows
     group.
  
   - [INSTALL] contains entries that identify where you've
     installed Paradox program components on the network.
  
3) At each workstation you want to configure, make sure that
   all network drives are mapped correctly and that the
   ODAPI directory is on the search path.

4) From each workstation, start Windows, choose File|Run and
   run the Network Configuration Utility from its network
   location. For example, if you installed Paradox to
   T:\PDOXWIN, run T:\PDOXWIN\NCONFIG.EXE. You'll see the
   Paradox for Windows Network Configuration dialog box. The
   entries in this dialog box reflect the contents of the
   NCONFIG.INI file.

5) Make any changes necessary (for example, change the User
   Name) and choose OK. The workstation is configured.
  

6. THE DESKTOP PROPERTIES DIALOG BOX
------------------------------------

- A bitmap, PDOXWIN.BMP, is included when you install
  Paradox. This is a suggested Desktop background bitmap.
  You can change the background bitmap using the Desktop
  Properties dialog box.

- Tile Bitmap and Center Bitmap radio buttons have been
  added to the Desktop Properties dialog box. Use these to
  change the display of the background bitmap.

- The Designer Style drop-down list has been added to the
  Desktop Properties dialog box. Use this list if you want
  to replace the existing prototype object styles for form
  and report design objects. The default style file is
  PXTOOLS.FT.

  NOTE: You can also choose a different style file from the
        Designer Properties dialog box, available from open
        Form Design or Report Design windows.
  
  Prototype object files are now listed in the PDOXWIN.INI
  file, and are accessable from any directory.


7. THE AUTO-APPEND PROPERTY
---------------------------

The Auto-Append property has been added. Auto-Append
controls whether moving beyond the last record in a table
that you edit from a form automatically appends a new blank
record to the end of the table.

Auto-Append is checked by default. If you turn the Auto-
Append property off, you must specifically insert a new
record when you want to append one to the table. This
prevents you from unintentionally adding records.

To check or uncheck the Auto-Append property, inspect the
table in the data model panel of the Data Model dialog box.


8. COMMAND-LINE OPTIONS
-----------------------

The following command-line options have been added to
Paradox:

-n Do not write changes to WIN.INI. When you exit Paradox,
   the names of the working directory and the private
   directory are written to WIN.INI. Use -n to prevent this.
   You can place -n in the FLAGS= line of the [PDOXWIN]
   section of WIN.INI. If you do this and need to save
   changes to WIN.INI, you can override the -n option by
   starting Paradox with the -y option. For more information
   about starting Paradox with command-line options, see
   Chapter 14 in "Getting Started."

-y Do write changes to WIN.INI

-e Prevents Paradox from writing changes to PDOXWIN.INI and
   PDOXWORK.INI. This option is useful for developers who
   require specific settings in these files.

-f Lets Paradox write changes to PDOXWIN.INI and
   PDOXWORK.INI. This option overrides -e if it is placed in
   the FLAGS= line in the [PDOXWIN] section of WIN.INI.

-s Prevents users from resizing the Desktop. This option
   starts Paradox without a resizeable window border. It
   does not prevent the window from being resized by
   ObjectPAL applications.
  
-t Lets users resize the Desktop. This option can be used to
   override -s if it is placed in the FLAGS= line in the
   [PDOXWIN] section of WIN.INI.

When starting a second instance of Paradox from a second
Paradox icon, use the -n command-line option (which
prohibits Paradox from saving private and working directory
settings in the WIN.INI file) and the -p option (which lets
you choose a different private directory).


9. OTHER ADDITIONS AND IMPROVEMENTS
-----------------------------------

This section contains information about a variety of new
features available in Paradox.

- Icons now appear in file lists to indicate whether the
  file is located on a local drive (a drive icon) or a
  remote server (a bin icon).

- Press CTRL+F3 to force a data refresh on the active
  table.

- When you use the Locate|and Replace command, you'll now
  be able to use the Found a Match dialog box to skip or
  change each occurrence of a value, or to change all
  values in one step.

  Additionally, performance time has been improved for
  Locate operations, both when performed interactively and
  when using ObjectPAL.

- When you open a table that was created using dBASE IV
  2.0, Paradox uses the language driver that the table was
  created with, rather than the language driver specified
  in your ODAPI configuration.

- Paradox child windows open sized to fit their contents.
  This means that when you open a Table window, Paradox
  will not include blank space to the right of a narrow
  table or beneath a short table. A large table will fill
  the whole Desktop.

- When you use the Add utility to add records to an unkeyed
  target table you might create a Keyviol table. This
  happens if the target table has validity checks, and you
  use the Append option. Appended records that violate the
  validity checks are written to Keyviol.

- The Selectable property has been added to all objects in
  forms and reports. When you inspect an object and uncheck
  Selectable, you can no longer select it. You can still
  select any objects it may contain, and you can still
  inspect it.

- The Columnar property has been added to multi-record
  objects in reports. When you inspect a multi-record
  object and check Columnar, each individual record expands
  or contracts individually when you print or preview the
  report. This means that the multi-record object does not
  display the records in a fixed-size grid. Using the
  Columnar property, you can usually fit more records on a
  single page than you can without the Columnar property.

  NOTE: When you check Columnar, the Record Layout
        dialog box must use the Top-Down, Then Left-Right
        setting.

- A message line has been added to the Print File dialog
  box. This message informs you when your page and printer
  orientation don't match.

- Warning messages are now displayed on the Desktop's
  status line.

- When using field names in calculated expressions, you
  must enclose in quotation marks any field name that
  contains a period.

- The maximum length of a custom format name is 14
  characters.


     -----------------------END-------------------------

