home *** CD-ROM | disk | FTP | other *** search
-
- Welcome to Visual dBASE
- -----------------------
-
- This file contains important, late-breaking information about Visual
- dBASE, including updates to the printed documentation.
-
- TABLE OF CONTENTS
- -----------------
- 1. Configuration and System Requirements
- 2. Distributing Visual dBASE Applications
- 3. Accessing Database Servers with Visual dBASE
- 4. dBASE SpeedFilter Optimization
- 5. Documentation Updates
- 6. Borland Database Engine Configuration Notes
- 7. Using the ODBC Socket
- 8. Windows 95 Issues
- 9. Automated Registration Notes
- 10. dBASE for Windows 5.0 Compatibility Issues
- 11. dBASE DOS Compatibility Tips
- 12. Windows Colors Settings
- 13. Running the dBClock Sample Program with Dashboard
- 14. Common Questions & Answers
- 15. Working with FoxPro Tables
- 16. Installing Adobe(R) Acrobat(TM)
- 17. dBASE Magazines and Supporting Products
- 18. Acknowledgments
-
- Additional Help and text files contain valuable information about working
- with Visual dBASE:
-
- CUSTOM.TXT in \VISUALDB\CUSTOM contains information about the Visual
- dBASE Custom Controls.
-
- dBASESQL.HLP in \VISUALDB\BIN contains information about using Borland
- SQL Links with Visual dBASE.
-
- EXTERN.TXT in \VISUALDB\SAMPLES\EXTERN describes the samples that
- illustrate using the Extern System.
-
- SAMPLES.TXT in \VISUALDB\SAMPLES describes the sample program files.
-
- UTILS.TXT in \VISUALDB\UTILS contains information on using the Visual
- dBASE utility programs.
-
-
- 1. CONFIGURATION AND SYSTEM REQUIREMENTS
- -----------------------------------------
- System requirements:
- - Intel 386-based PC or higher
- - Windows 3.1, Windows 95, or 100% compatible
- - 6 MB RAM required, 8 MB recommended
- - 29 MB free disk space for a complete installation
- - 11.5 MB free disk space for minimum installation
-
- Visual dBASE is compatible with Win-OS/2 and Windows 3.1 running
- under OS/2 Warp.
-
- Supported network operating systems:
- Netware 3.11, 3.12, 4.1
- Personal Netware
- Banyan Vines 5.5
- IBM OS/2 LAN Server 4.0 *
- Lantastic 6.0
- Microsoft LAN Manager 2.2
- Windows for Workgroups 3.11 **
- Windows NT Server 3.5 **
-
- * For proper operation of Visual dBASE with LanServer 4.0, change
- the following parameters in the DOSLAN.INI file on the workstation:
- NBS: 4K
- BBS: 5K
-
- ** If the server is also used as a workstation, the LOCALSHARE setting in
- the System page of the BDE Configuration Utility must be set to True.
- Without this setting, record and file locking will not be performed at
- the server.
-
- To open Crystal Reports Personal Trainer from within Crystal Reports
- Help, you must have the \VISUALDB\CRYSTAL directory in your DOS path.
-
- On a single machine, to access the same table concurrently using Sessions
- or multiple instances of Visual dBASE, the DOS SHARE.EXE utility must be
- loaded before starting Windows with the command:
- SHARE /F:4096 /L:40
-
- Also see section 6 of this README file, "BDE Configuration Notes."
-
-
- 2. DISTRIBUTING VISUAL DBASE APPLICATIONS
- -----------------------------------------
- The Visual dBASE Compiler is an optional, separately purchased, add-on
- product for Visual dBASE. It compiles and links Visual dBASE programs,
- forms, reports, bitmaps, and other code and resources into a Windows
- executable which can be distributed royalty-free and run on systems
- which do not have Visual dBASE installed.
-
- To learn how to build and distribute Windows executables with the Visual
- dBASE Compiler, see the Programmer's Guide and the online Help.
-
-
- 3. ACCESSING DATABASE SERVERS WITH VISUAL DBASE
- -----------------------------------------------
- Visual dBASE can be used to create powerful client/server applications
- using a variety of popular database servers. Visual dBASE Client/Server
- includes all the software required to do client/server development. Visual
- dBASE Client/Server includes:
-
- * Borland SQL Links for:
- - Borland Interbase
- - Informix
- - Microsoft/Sybase SQL Server
- - Oracle
- * Borland's Local Interbase Server for developing and testing
- client/server applications.
- * The Data Pump Expert to easily move tables between platforms.
- * The Visual dBASE Compiler for compiling applications to Windows
- executables and royalty-free distribution.
- * Resource Workshop for easily creating Windows resources using visual
- tools.
-
- For information on upgrading to Visual dBASE Client/Server contact
- Borland or your local reseller.
-
-
- 4. dBASE SPEEDFILTER OPTIMIZATION
- ---------------------------------
- dBASE SpeedFilters provide the fastest access to your dBASE tables. See
- the "About SpeedFilters" topic under "Visual dBASE Basics" in the dBASE
- online Help file for more information.
-
-
- 5. DOCUMENTATION UPDATES
- -------------------------
- User's Guide updates
-
- - See section 1 of this README file for an updated list of supported
- networks.
-
- - When installing Visual dBASE under Windows 95 or Windows NT, Visual
- dBASE may not automatically register with the operating system. To
- insure this process is completed, double-click on the VISUALDB.REG file
- in the \VISUALDB\BIN directory immediately after the installation
- completes.
-
- - Navigator and Command Window changes: Double-clicking the Control menu
- box or choosing File|Close minimizes these windows.
-
- - The number of tables in a query is limited by the number of
- work areas (225).
-
- - The section called "OEM and ANSI conversions" on pages 316-317 is
- incorrect. This material is discussed in the help correctly. To find
- this information, search for OEM in the help, then choose the topic
- "Converting between OEM and ANSI text".
-
- - To get context-sensitive help from the command line or while editing
- programs, select the command, function, or another language element
- name and press F1. If the language element selected is fully spelled
- out, the corresponding help topic appears.
-
- - Note on creating a form in the Form Designer based on a Custom Form
- Class: When an object on the form is selected, the handles (the small
- squares surrounding the selected object) appear in black if the object
- is defined on the current form, and appear in white if the object was
- inherited from the parent form class. Changes made to inherited objects
- (those with white handles) will be reflected only in the current form.
- The parent form and its objects will be unaffected. To change the
- custom form class, the custom form must be modified directly.
-
- Language Reference/Programmer's Guide updates
-
- - Online Help is your most up-to-date source of information on the dBASE
- language.
-
- - The following properties are not documented in the Language Reference,
- but are documented in the online Help: DesignView, CanNavigate,
- RefreshAlways, and OnDesignOpen.
-
- - The following commands and functions are not documented in the
- Language Reference, but are documented in the online Help: ADIREXT()
- and EXTERN SQL.
-
- - Using LOCAL or STATIC variables, or properties of LOCAL or STATIC
- objects, in a <condition> of the LOCATE or SET FILTER commands is not
- allowed. Use a PUBLIC or PRIVATE variable, or a PUBLIC or PRIVATE
- object, instead. This restriction also applies to the use of properties
- of the objects THIS or FORM in the <condition>, since THIS and FORM
- have LOCAL scope.
-
- - PaintBox objects have an OnClose event. This is not documented in the
- Language Reference.
-
- - Note on the CanNavigate() event: When the CanNavigate event handler
- is used, the event handler must return .T. for the user to be allowed
- to navigate between records. If the CanNavigate event handler returns
- .F., the user cannot leave the current record.
-
- - The syntax for expression codeblocks in the Language Reference and
- on-line Help is incorrect. The correct syntax is:
- {|[<parameters>]| <expression>}
- The pipes ( || ) are required even if no parameters are passed. The
- syntax is documented correctly in the Programmer's Guide.
-
- - The Language Reference incorrectly says that the default setting of
- SET LDCHECK is ON. The default setting is actually OFF.
-
- - Correction to the Local SQL INSERT INTO command: The <column list> is
- not optional for local tables.
-
- - Correction to the SET KEY TO command: Replace the beginning of the
- syntax discussion with the following:
- <exp list 1> | RANGE <exp 2> [,] | ,<exp 3> | <exp2>, <exp3>
- Specifies a condition that filters records. For Paradox and SQL
- tables, <exp list 1> can contain values (separated by commas) that
- match composite index key fields.
-
- - Replace the syntax statement in the Local SQL CREATE TABLE command with
- the following:
- CREATE TABLE <table name> (<column name> <data type>
- [ , <column name> <data type>...]
- [ , PRIMARY KEY ( <column list> ) ]
- )
-
- - When the structure of a database server table is changed, the database
- should be closed and re-opened before continuing to use the table;
- otherwise, dBASE may behave as if the table structure is unchanged. A
- workaround is to go into the BDE Configuration Utility, and on the
- Drivers page, change the schema cache size from its default of 8 to 0.
- However, this workaround should only be used during development and
- testing of applications because it will have a negative impact on
- performance.
-
- - When forms containing Visual dBASE custom controls are generated via
- the Form Designer, the full path to the location of the custom-control
- files on that machine is stored in the .WFM file. To distribute an
- application with custom-control files, edit the .WFM file to remove the
- full path. Then copy the custom-control files to the directory where
- the .WFM is stored.
-
- - On database servers where a unique row identification method is not
- available (such as a primary key or unique index), issuing a REFRESH
- command will clear any SET FILTERs and SET RELATIONs that were active.
-
- - Do not issue a REFRESH command against Views or read-only SQL result
- tables. Reissue the SELECT command instead.
-
- Upgrade Guide updates (applies only to the upgrade product)
-
- - The MarkCustom() method described in Chapter 6 does not exist. Its
- functionality is built into the Form Designer.
-
-
- 6. BORLAND DATABASE ENGINE (BDE) CONFIGURATION NOTES
- -----------------------------------------------------
- Your DBASEWIN.INI file lets you specify a default BDE configuration file to
- use whenever Visual dBASE is started. However, if another, non-dBASE,
- BDE-based product is already running with a different BDE configuration
- file when you try to start Visual dBASE, Visual dBASE will issue an error
- and will not start.
-
- Choose the BDE Configuration Utility icon from Windows Program Manager
- to edit the configuration file. When you open the utility it will display
- the IDAPI.CFG specified in the BDE section of the WIN.INI file.
-
- You might need to change some or all of the following IDAPI.CFG settings:
-
- - DBASE FILE TYPE -- During installation, if a BDE configuration file
- exists on your machine, its settings are read into the new BDE
- configuration file. This may cause the dBASE FILE TYPE level to be set
- to 4 (the dBASE IV level). To use Visual dBASE specific field types
- (i.e. Binary and OLE), set DBASE FILE TYPE to 5.
-
- - LOCAL SHARE -- If you are not on a network, and it is possible to have
- Visual dBASE and other non-BDE software products accessing the same
- tables at the same time, you need to set LOCAL SHARE (System Page) to
- TRUE and have the DOS SHARE.EXE program loaded in memory.
-
- - NET DIR -- If you are using Paradox tables, or are executing SQL
- commands through Local or Remote SQL or SQLEXEC() on a shared drive
- (network), you must enter a valid path into the IDAPI.CFG's Paradox
- driver NET DIR setting. See the instructions above on how to use the
- BDE Configuration Utility.
-
- Placement of the Borland Database Engine (BDE) files:
-
- If you are installing Visual dBASE on a workstation that already
- contains a copy of the Borland Database Engine, install the Visual dBASE
- BDE files to the same directory. Typically, this directory is called
- \IDAPI.
-
- If you have an existing installation of the BDE, the installation program
- copies your default BDE configuration file to whatever location you
- specified for your Visual dBASE BDE files. (Your default BDE
- configuration file is specified in the BDE section of your WIN.INI file
- as CONFIGFILE01.)
-
- If the CONFIGFILE01 setting does not exist in your WIN.INI and you do not
- have an IDAPI.CFG file, a new IDAPI.CFG file is created in the same
- directory where you installed your Visual dBASE BDE files. The
- installation program changes the CONFIGFILE01 setting to point to
- IDAPI.CFG at this new location.
-
-
- 7. USING THE ODBC SOCKET
- -------------------------
- Visual dBASE includes support in the Borland Database Engine for an ODBC
- Socket. It has been certified with Microsoft's 2.0 ODBC Driver Manager. If
- you have a different version of the ODBC Driver Manager, back up your
- existing ODBC.DLL and ODBCINST.DLL and copy the version 2.0 files ODBC.NEW
- and ODBCINST.NEW files from your BDE directory to your \WINDOWS\SYSTEM
- directory, renaming them to ODBC.DLL and ODBCINST.DLL.
-
- The driver description in the ODBC.INI file must match the driver name
- exactly as found in the ODBCINST.INI file in order for the BDE
- Configuration Utility to add drivers to the BDE configuration file.
-
- When using ODBC data sources with the Auto ODBC option set to True and
- a driver name greater than 32 characters, the BDE truncates the name to
- 32 characters. These truncated drivers do not appear in the driver list
- within BDECFG.EXE. Therefore they cannot be deleted from the
- configuration file. Every time that the Auto ODBC option is set to True
- these drivers are added repeatedly to the configuration file after every
- save - thus the configuration file keeps growing and there is no way to
- remove the excess drivers. To avoid this problem do not use driver names
- greater than 32 characters in length.
-
- For information on how to create an ODBC driver connection and alias,
- search for "ODBC Driver Connection" in the BDE Configuration Utility
- online Help file.
-
-
- 8. WINDOWS 95 ISSUES
- --------------------
- - When installing Visual dBASE under Windows 95 or Windows NT, Visual
- dBASE may not automatically register with the operating system. To
- insure this process is completed, double-click on the VISUALDB.REG file
- in the \VISUALDB\BIN directory immediately after the installation
- completes.
-
- - The BDE does not support the Windows 95 Universal Naming Conventions
- for accessing network servers as directories in this release.
- Therefore, a command such as:
-
- USE \\MYSERVER\MYDATA\MYTABLE.DBF
-
- does not work. A workaround is to map the server/directory to a drive.
- For example, if in the command above we mapped \\MYSERVER to drive G:,
- the command could be entered as:
-
- USE G:\MYDATA\MYTABLE.DBF
-
- which would work.
-
- - Windows 95 requires double quotes around a filename that includes
- embedded spaces when executing a program. Therefore in the RUN()
- command, extra delimiters (square brackets or single quotes) must be
- supplied around such filenames. For example:
-
- RUN(.T., ["C:\PROGRAM FILES\ACCESSORIES\MSPAINT.EXE"])
-
-
- 9. AUTOMATED REGISTRATION NOTES
- -------------------------------
- Visual dBASE features an automated registration system which allows you to
- register your software with Borland at the time you install the product.
- Registration is accomplished via modem, if a modem is available, or by
- printing out and mailing or faxing your registration information.
-
- If you start, but do not complete, the automated registration when you
- install Visual dBASE, you will be automatically reminded to register after
- 14 days. This reminder can be disabled by removing the command
- "C:\VISUALDB\VDB55REG\remind.exe" from the line that begins "load=" in the
- WIN.INI file in your Windows directory.
-
- Under Windows NT, the steps to disable the reminder are different. The
- steps are:
- - Double-click on REGEDT32.EXE in the \WINDOWS\SYSTEM32 directory.
- - Find the "HKEY_CURRENT_USER on Local Machine" window.
- - Search the tree for Software\Microsoft\WindowsNT\CurrentVersion\Windows
- - Double-click on the "load" item to bring up the String Editor.
- - Remove the entry for REMIND.EXE from the string.
-
- Once you have registered, you can safely remove the directory
- \VISUALDB\VDB55REG and the files contained therein.
-
-
- 10. dBASE FOR WINDOWS 5.0 COMPATIBILITY ISSUES
- ----------------------------------------------
- - Note that for expression codeblocks, the Visual dBASE syntax is:
- {|[<parameters>]|<expression>}
- The pipes ( || ) are now required even if no parameters are passed. In
- dBASE for Windows 5.0 the pipes were optional if no parameters were
- passed.
-
- - Forms created using dBASE for Windows 5.0 that used the BUTTONS.CC
- custom control library, or resources from other files which resided in
- the \DBASEWIN directory tree, may need to be modified. In some cases the
- full path to a file was inserted in the .WFM file. Since the base
- directory for Visual dBASE is now \VISUALDB, not \DBASEWIN, the path to
- the file will need to be corrected.
-
- - The default ComboBox style is now 1 (DropDown).
-
- - SET CONFIRM now defaults to ON.
-
-
- 11. dBASE DOS COMPATIBILITY TIPS
- --------------------------------
- Declaring a variable PRIVATE that is in use as the screen name for SAVE
- SCREEN TO <screen name> returns the run-time error "Variable undefined:
- <screen name>". Visual dBASE handles <screen name> differently than
- dBASE for DOS; it creates <screen name> as a PUBLIC memory variable.
-
- Visual dBASE does not run dBASE DOS Label and Report binary files (.LBL
- and .FRM). Use the Component Builder to convert them to Crystal Reports
- files (.RPL and .RPT). dBASE DOS .LBG and .FRG label and report files may
- be run as source code.
-
- dBASE DOS queries that contain sort instructions cannot be used by the
- Component Builder and Crystal Reports for dBASE. In the case of QBEs that
- SORT, please see A10 in the Common Questions & Answers section below.
-
- To honor Windows keystroke behavior, Ctrl+Home and Ctrl+End no longer open
- and close memo fields. Use F9 to open them; use F9, Ctrl+W, or <Esc> to
- close them.
-
- F9 and double-click are used to open memo, OLE, and binary fields in Visual
- dBASE. If your application uses the ON KEY LABEL F9 <command> to redefine
- F9 for these fields, double-click on the icons to open them.
-
- The SET STATUS ON/OFF command is not supported (returns a warning) in
- Visual dBASE. However, you may still use the Application page of the
- Desktop Properties dialog box to turn the status bar on or off. You can
- also do this via the DBASEWIN.INI file, by changing the setting of
- StatusBar to OFF or ON in the Desktop section. This must be done before
- starting Visual dBASE.
-
- APPEND FROM ARRAY will require matching data types between the array
- element and the corresponding field in the table. This is not required in
- dBASE for DOS.
-
- Visual dBASE does not support dBASE DOS PLAY MACRO, SAVE MACROS, or
- RESTORE MACROS commands. dBASE DOS MACRO.KEY files must be converted to a
- Windows macro format or reprogrammed under Visual dBASE as functions.
-
- When installed on a standalone machine, Visual dBASE does not change
- the default for SET EXCLUSIVE to ON; however, dBASE DOS does. Because of
- this, you might want to SET EXCLUSIVE ON at the top of dBASE DOS
- applications run under Visual dBASE that require exclusive use of tables.
-
- In Visual dBASE, a new return value has been added to the READKEY()
- function to indicate that no update has occurred. READKEY() returns 14 if
- an unchanged record is left by pressing Ctrl+W or Ctrl+End.
-
- Visual dBASE uses SET DELETED ON as the default setting. If you want
- the default to be OFF you must go to the Tables page of the Desktop
- Properties dialog box to set the default to either ON or OFF. Another way
- of doing this is in the DBASEWIN.INI file, where you can change the setting
- of DELETED to OFF or ON in the "OnOffCommandSettings" section. This must be
- done before starting Visual dBASE.
-
-
- 12. WINDOWS COLOR SETTINGS
- --------------------------
- Default color settings are taken from the settings in the Windows Control
- Panel. You can use color settings for the color properties of controls
- and with the SET COLOR command. The following chart shows the available
- color settings and the corresponding setting from the Windows Control
- Panel. See the online help for the ColorNormal property for usage.
-
- Color Setting Windows 3.1 Control Panel Windows 95 Control Panel
- =================== ========================= ========================
- ActiveBorder Active Border Active Window Border
- ActiveCaption Active Title Bar Active Title Bar
- AppWorkSpace Application Workspace Application Background
- BackGround Desktop Desktop
- BtnFace Button Face 3D Objects
- BtnHighlight Button Highlight 3D Objects
- BtnShadow Button Shadow 3D Ojbects
- BtnText Button Text 3D Objects
- CaptionText Active Title Bar Text Active Title Bar
- GrayText Disabled Text <not configurable>
- Highlight Highlight Menu
- HighlightText Highlight Text Menu
- InactiveBorder Inactive Border Inactive Window Border
- InactiveCaption Inactive Title Bar Inactive Title Bar
- InactiveCaptionText Inactive Title Bar Text Inactive Title Bar
- Menu Menu Bar Menu
- MenuText Menu Text Menu
- Scrollbar Scroll Bars 3D Objects
- Window Window Background Window
- WindowFrame Window Frame <not configurable>
- WindowText Window Text Window
-
-
- 13. RUNNING THE DBCLOCK SAMPLE PROGRAM WITH DASHBOARD
- -----------------------------------------------------
- If you use the optional Visual dBASE Compiler to compile the sample program
- dBClock to an .EXE file, and you use Dashboard from Starfish Software,
- dBClock will not run. This is caused by a naming conflict; Dashboard has a
- DLL called DBCLOCK.DLL. A simple workaround is to rename the .EXE so the
- name does not conflict. For example, rename DBCLOCK.EXE to DBCLOCK1.EXE.
-
-
- 14. COMMON QUESTIONS & ANSWERS
- -------------------------------
- Q1: How much hard disk space do I need to install Visual dBASE?
-
- A1: Full Installation requires 24 MB. If space is a problem, select
- Custom Installation and omit the options you don't need. Minimum
- Installation requires 10 MB of hard disk space. In addition, you should
- have 1.5 MB of free drive space on the drive/partition where Windows is
- installed (if installing on a different drive/partition). When using a
- compressed drive, allow a plus 20 percent margin.
-
- Q2: The User's Guide says 6 MB of RAM is required (8 MB preferred). Will
- Visual dBASE run on a 4MB machine?
-
- A2: A 4 MB RAM machine has 3 MB of extended memory available before
- anything else is loaded into extended memory. Typically, Windows 3.1
- has SMARTDRIVE installed which takes 1 MB of extended memory. The 2 MB of
- extended memory remaining is then used by Windows in conjunction with a
- (Windows) swap file created on your hard drive. All your Windows programs
- will be sharing this limited resource. Visual dBASE will likely run
- on this environment but with reduced performance. The product is
- recommended for machines that have the specified (6 MB or more) amount of
- RAM.
-
- Q3: How do I access Windows memory management controls?
-
- A3: a) Choose the Windows Control Panel.
- b) Choose 386 Enhanced.
- c) Click the Virtual Memory pushbutton.
- d) Click the Change pushbutton.
- e) Choose "Permanent Swap File".
- f) Increase the value of the New Size option.
- Consult your Windows documentation for further information.
-
- Q4: Can dBASE for DOS and Visual dBASE be installed on the same machine?
- Which one will start when I issue the dBASE command at DOS with dBASE in
- my PATH?
-
- A4: dBASE for DOS (dBASE IV or dBASE 5.0) starts by calling DBASE.EXE.
- Visual dBASE has an executable file named DBASEWIN.EXE. The command
- DBASE, issued at DOS, will execute dBASE for DOS. On a system with Windows
- 3.1, the command DBASEWIN, issued at DOS, will give you a DOS error "Not a
- DOS Program." You must start Windows first. The command WIN DBASEWIN from
- DOS will start Visual dBASE. Typically Visual dBASE will be run from the
- Program Manager in Windows 3.1. Windows 95 does not use DOS, but can
- emulate a DOS command line. Issuing the DBASEWIN command at a Windows 95
- "DOS" prompt will start Visual dBASE.
-
- Q5: All my old data files (.DBF, .DBT, .MDX, .QBE, .FMT, .FRG, etc.) are
- located on my C:\DBASE or C:\DBASE\DATA subdirectory. Do I have to move
- them to the VISUALDB directory?
-
- A5: Subdirectory selection is easy from the Navigator in Visual dBASE.
- Enter the correct path in the entry field or click the file icon to select
- a new directory. Files in various directories can also be organized in a
- catalog. When running Visual dBASE, it is ok to change the current
- directory to a directory on which dBASE for DOS is installed to access
- data files.
-
- Q6: Where can I get more examples on programming with Visual dBASE?
-
- A6: Additional samples and example source code are available in the Visual
- dBASE forum on CompuServe, and at Borland's World Wide Web site on the
- Internet (http://www.borland.com).
-
- Q7: As a dBASE DOS user, sessions are new to me. Where can I get more
- information about how these work?
-
- A7: See the "About Sessions" topic under "Visual dBASE Basics" in
- the dBASE online Help system. An article is also available on the
- Borland TechFax machine; obtain a catalog by calling 1-800-822-4269.
-
- Q8: When starting Visual dBASE, I receive the error "Buttons.cc not
- found"; however, this file is located on my network drive. What do I need
- to change in my configuration?
-
- A8: Edit your DBASEWIN.INI file, usually located in your \VISUALDB\BIN
- directory, and locate the [CustomClasses] section. Look for the line
- beginning with CC that specifies the location of your BUTTONS.CC file. Make
- sure the line has the proper path to the location of your BUTTONS.CC file.
- This file should be located in your \VISUALDB\SAMPLES directory. Then
- restart Visual dBASE.
-
- Q9: I have a large application written in dBASE IV 2.0. What do I need to
- do to run this application in Visual dBASE?
-
- A9: You can run your program from the Command window; however, your
- program will only be displayed in the results pane. You can convert your
- code to Windows type code using the Component Builder included with Visual
- dBASE. For further information on using the Component Builder, load the
- Component Builder by clicking its icon and see the Conversion Guidelines in
- the Component Builder online Help file.
-
- Q10: When I run or design a report based on a sorted Query, my fields
- disappear from the report. How do I see my fields?
-
- A10: This is because the sorted query creates a temporary file with a
- unique name, each time the query is executed. We recommend that you
- perform the sort in the report designer. Alternately, you can edit
- the query as a program and change the variable assignment of SORT___001
- to a unique specific file name like SORT___001 = "NEW" and delete the
- rest of the line. You should add a line, SET SAFETY OFF, before the
- variable assignment, and add a line at the end of the QBE, SET SAFETY
- ON. Now you are ready to build a new report on this query. More
- complete details are available on the Borland TechFax machine; obtain a
- catalog at 1-800-822-4269.
-
- Q11: What do I need to do before creating Referential Integrity rules
- for Paradox tables?
-
- A11: Before creating referential integrity (RI) rules for Paradox tables,
- all tables must have a Primary Key defined. To create an RI rule based on a
- one-to-many link between tables, the child table's linked field must have
- a secondary index.
-
- Q12: How can I make sure a PaintBox control correctly processes the
- Windows OnPaint messages?
-
- A12: In the OnPaint event of you PaintBox control, you should use either
- the BeginPaint() and EndPaint() functions to bracket your paint routine, or
- use the ValidateRect() or ValidateRgn() functions. This will prevent your
- control from receiving excessive Paint messages. These functions are all
- Windows API calls, and are prototyped as EXTERN functions in the WINAPI.H
- header file that comes with Visual dBASE.
-
-
- 15. WORKING WITH FOXPRO TABLES
- -------------------------------
- Visual dBASE can open, read, and write to FoxPro tables as follows:
- .DBF - FoxPro table file
- .CDX - FoxPro multiple index file
- .FPT - FoxPro table memo file
-
- 1. If the table has no production index, memo field, or general field,
- Visual dBASE will open it and read and write data to it.
-
- 2. If the table has a production index (.CDX), you have an option to
- open it read-only, which ignores the .CDX file, or create a new
- .MDX file with the same index tags as are in the .CDX file.
-
- 3. If the table has a memo field or general field (.FPT), you have the
- option to open it, and read and write to it, as a non-dBASE table.
- If the table has a general field with OLE documents in them, dBASE
- for Windows can read and write them.
-
- You can also open the table and convert the memo or general field
- (.FPT) to the dBASE .DBT format. If you convert it, the original
- .FPT file is deleted, so you should make a backup of the table
- before converting.
-
-
- 16. INSTALLING ADOBE(R) ACROBAT(TM)
- ------------------------------------
- NOTE: This section applies only to the version of Visual dBASE
- distributed on CD-ROM.
-
- To install the Adobe Acrobat Reader manually:
- 1. place the Visual dBASE CD in the CD-ROM drive.
- 2. Run the program d:\INSTALL.ADB\ACROREAD.EXE, where "d:" is
- the drive letter of your CD-ROM.
- 3. In Program Manager, drag the Adobe Acrobat Reader icon into the
- Visual dBASE Program Group.
- 4. With the icon selected, select File | Properties on the Program
- Manager menu bar.
- 5. Add the following to the end of the command line statement:
- d:\BOOKS\STARTUP.PDF
- where d: is the drive letter of your CD-ROM
-
- Windows 95 and Windows NT users should be aware that the Acrobat
- installation program will reboot Windows at the completion of the
- installation.
-
- This version of the Acrobat Reader will not run under Windows NT. Windows
- NT users should contact Adobe for information on availability of an Acrobat
- reader that is compatible with Windows NT.
-
-
- 17. dBASE MAGAZINES AND SUPPORTING PRODUCTS
- --------------------------------------------
- See the "Companion Products and Services" Help file for information on
- additional software, training, books, and magazines that support Visual
- dBASE.
-
-
- 18. ACKNOWLEDGMENTS
- --------------------
- Some of the sound files were provided by Programmer's Warehouse from Sound
- Explosion for Windows. Copyright (c) 1992-1994 Programmer's Warehouse. All
- rights reserved. Licensed sounds Copyright (c) 1990-1992 The Hollywood
- Edge.
-
- Sample music database provided by AudioFile, providers of current
- information for the retail music industry. Product listed in this database
- is available through Sound Delivery, 1280 Santa Anita Court, Woodland, CA
- 95776.
-
- Sampled music provided by Southern Library of Recorded Music, 6777
- Hollywood Boulevard, Los Angeles, CA 90028, (213) 469-9910.
-
-