World of Shareware - Software Farm 2

home *** CD-ROM | disk | FTP | other *** search

/ World of Shareware - Software Farm 2 / wosw_2.zip / wosw_2 / DATABASE / DPF15A.ZIP / DPERFECT.DOC < prev next >

Wrap

Text File | 1991-04-24 | 51KB | 1,163 lines

▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ dPerfect Merge Convert data base files to Word Perfect secondary merge files Copyright 1991 Newdorf Research All Rights Reserved P.O. Box 2309 Rancho Santa Fe, CA 92067 Barbara J. Feldman CompuServe ID: 73170,216 VOICE: (619) 942-0688 FAX: (619) 942-9387 ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ dPerfect Merge is a copyrighted SHAREWARE program. You are free to try this program for thirty days and to distribute it freely to your friends and associates. Please distribute the self-extracting archive file instead of the individual files. If you use this program beyond the thirty day trial, you are required to register your copy. If you include any part of dPerfect Merge in a system for resale, you must register each copy of dPerfect Merge. See Page 16 for registration details. The complete dPerfect Merge package contains the following: dPERFECT.EXE -- Interactive translation utility (Try this first!) dPERFECT.DOC -- This documentation file dPERF$$$.DBF -- Required configuration file dPERFBV.EXE -- Batch translation utility (dPerfect BV) dP_BTEST.BAT -- Sample batch program using dPerfect BV dPERFECT.OBJ -- Clipper function for inclusion in Clipper programs dP_CLIPP.PRG -- Sample Clipper program using dPERFECT.OBJ dP_REGIS.TER -- Registration form dP_READ.ME -- A list of files in the archive This program is produced by a member of the Association of Shareware Professionals (ASP). ASP wants to make sure that the shareware principle works for you. If you are unable to resolve a shareware-related problem with an ASP member by contacting the member directly, ASP may be able to help. The ASP Ombudsman can help you resolve a dispute or problem with an ASP member, but does not provide technical support for members' products. Please write to the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006 or send a Compuserve message via easyplex to ASP Ombudsman 70007,3536 Note: dBase is a registered trademark of Ashton-Tate. Word Perfect is a registered trademark of WordPerfect Corp. Clipper is a registered trademark of Nantucket Corp. FoxBase and FoxPro are registered trademarks of Fox Software. Page i Table of Contents CREATE MERGE FILE . . . . . . . . . . . . . . . . . . . . . . . . . Page 1 "Enter path and filename of source data base file:". . . . . . Page 1 "Enter key expression to create index:". . . . . . . . . . . . Page 1 "OR enter path and filename of existing index:" . . . . . . Page 1 "Enter path and filename of Word Perfect secondary merge file to be created:" . . . . . . . . . . . . . . . . . . . . . . . . Page 2 "Enter record selection criteria:" . . . . . . . . . . . . . . Page 2 "There are ___ records that meet your criteria". . . . . . . . Page 2 "Mark fields to be included with the PLUS key:". . . . . . . . Page 3 "Want to save these parameters as a setup file? [Y/N]" . . . . Page 3 "Do you want to print a summary sheet? [Y/N]". . . . . . . . . Page 3 CHANGE dPERFECT MERGE CONFIGURATION . . . . . . . . . . . . . . . . Page 4 Default Configuration Parameters . . . . . . . . . . . . . . . Page 4 "Word Perfect version:". . . . . . . . . . . . . . . . . . . . Page 4 "Date format:" . . . . . . . . . . . . . . . . . . . . . . . . Page 4 "Temporary delimiter:" . . . . . . . . . . . . . . . . . . . . Page 4 "Logical values:". . . . . . . . . . . . . . . . . . . . . . . Page 4 "Color monitor:" . . . . . . . . . . . . . . . . . . . . . . . Page 4 "European character set:". . . . . . . . . . . . . . . . . . . Page 5 Use of the Configuration File. . . . . . . . . . . . . . . . . Page 5 REGISTRATION INFO . . . . . . . . . . . . . . . . . . . . . . . . . Page 6 "Name of Registered Owner:". . . . . . . . . . . . . . . . . . Page 6 "Registration Key:". . . . . . . . . . . . . . . . . . . . . . Page 6 CompuServe Offer . . . . . . . . . . . . . . . . . . . . . . . Page 6 USING dPERFECT MERGE. . . . . . . . . . . . . . . . . . . . . . . . Page 7 Help Screens . . . . . . . . . . . . . . . . . . . . . . . . . Page 7 Using Setup Files. . . . . . . . . . . . . . . . . . . . . . . Page 7 Versions of Word Perfect Supported . . . . . . . . . . . . . . Page 7 Using Word Perfect Merge Files . . . . . . . . . . . . . . . . Page 7 Network Capabilities of dPerfect Merge . . . . . . . . . . . . Page 8 Use of the Tilde (~) Character . . . . . . . . . . . . . . . . Page 8 Working Disk Space Required. . . . . . . . . . . . . . . . . . Page 8 Temporary Working Files. . . . . . . . . . . . . . . . . . . . Page 8 Minimum DOS Configuration Required . . . . . . . . . . . . . . Page 9 Index Key Expressions. . . . . . . . . . . . . . . . . . . . Page 10 Record Selection Criteria. . . . . . . . . . . . . . . . . . Page 11 BATCH VERSION OF dPERFECT MERGE . . . . . . . . . . . . . . . . . Page 12 Using the Batch Version of dPerfect (dPERFBV.EXE). . . . . . Page 12 Sample Batch File (dP_BTEST.BAT) . . . . . . . . . . . . . . Page 12 CLIPPER FUNCTION dPERFECT() . . . . . . . . . . . . . . . . . . . Page 13 dPerfect() Syntax. . . . . . . . . . . . . . . . . . . . . . Page 13 dPerfect() Arguments . . . . . . . . . . . . . . . . . . . . Page 13 dPerfect() Return Value. . . . . . . . . . . . . . . . . . . Page 13 dPerfect() Usage . . . . . . . . . . . . . . . . . . . . . . Page 13 Sample Clipper Program (dP_CLIPP.PRG). . . . . . . . . . . . Page 14 DEFINITION OF SHAREWARE . . . . . . . . . . . . . . . . . . . . . Page 15 DISCLAIMER - AGREEMENT . . . . . . . . . . . . . . . . . . . Page 15 TO REGISTER YOUR COPY OF dPERFECT MERGE . . . . . . . . . . . . . Page 16 INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 17 Page iii dPerfect Merge Convert data base files to Word Perfect secondary merge files To start the program enter dPERFECT at the DOS command line. If you are using a trial version, press any key to pass the registration screen (or you will pause for 3 seconds). Answer each question followed by [Enter]. To move between fields, use [Up arrow] and [Down arrow]. To proceed without answering additional questions, use [F10] to continue. To exit to the menu at any time, use [Esc]. To clear a response field, use [Ctrl-Y]. To select a file from a directory listing, use [F2]. To select a field name from a field list, use [F4]. CREATE MERGE FILE "Enter path and filename of source data base file:" This is the source data base which will be read and converted to a Word Perfect secondary merge file. This can be any valid dBase III Plus, Clipper, Foxbase, Foxpro or compatible data base. Pathnames are required if your data base is not in the current directory. The ".DBF" extension is optional. If you enter a filename that doesn't exist or is not a valid data base, you will not exit from the field. This is a required field. To view a directory listing use [F2]. Enter the directory path you wish to view, including a DOS file skeleton using the wildcard characters "?" or "*". To view all files use the "*.*" skeleton. To view a listing of the current directory, just press [Enter]. To scroll through the directory listing use [Up arrow], [Down arrow], [Home] and [End]. To select a file, use [Enter]. To exit from the directory listing without selecting a file, use [Esc]. "Enter key expression to create index:" This is an optional field. If you wish to dynamically create an index for your data base, enter a single field name or a compound key expression (e.g. STATE+CITY). Your merge file will be sorted on this expression. For example, to create mailing labels in zip code order, enter the zip code field name from your data base. If you enter an invalid expression or field name, you will not exit from this field. Memo and logical fields are not allowed. To skip this question, press [Enter]. For more examples, see "Key Index Expressions" on Page 10. The index created is erased before exiting the program. To select a field from a list of field names, use [F4]. To scroll through the list use [Up arrow], [Down arrow], [Home] and [End]. To select a field name from the list, use [Enter]. To exit the list without selecting a field, use [Esc]. "OR enter path and filename of existing index:" This is an optional field. If you wish to sort your merge file on an existing dBase III compatible index, enter the Page 1name of the index. You do not need to include the ".NDX" extension. If you enter a filename that does not exist, you will not exit this field. If you enter a filename that is not a valid index, you will receive an error message. You cannot enter both an index filename and a key expression to be indexed. To view a directory listing use [F2]. Enter the directory path you wish to view, including a DOS file skeleton using the wildcard characters "?" or "*". To view all files use the "*.*" skeleton. To view a listing of the current directory, just press [Enter]. To scroll through the directory listing use [Up arrow], [Down arrow], [Home] and [End]. To select a file, use [Enter]. To exit the directory listing without selecting a file, use [Esc]. "Enter path and filename of Word Perfect secondary merge file to be created:" This is the name of the file to be created and is a required field. If the file exists, you will be prompted with a warning message. The file extension is optional. If you do not specify an extension, ".SF" is used. The merge file is created in Word Perfect 5.1 format unless your configuration file specifies otherwise. For information on changing to older versions of Word Perfect, see "Change dPerfect Merge Configuration" on Page 4. For more information on using this file to create merge letters, see "Using Word Perfect Merge Files" on Page 7. "Enter record selection criteria:" This is an optional field. You may enter any valid dBase or Clipper logical expression (up to 79 characters in length). For example, you can use record selection to only convert records for clients whose balance is greater than zero, or only prospects from Tennessee. This is an advanced feature. If you enter an illegal expression, you will receive an error message. (See "Record Selection Criteria" on Page 11 for examples and legal operators). Records that are deleted, will not appear in the merge file. To skip this field, just press [Enter] and each record in your source data base file will be converted to a record in the merge file. To assist in creating your expression, you can use [F4] to select from a list of field names. To scroll through the list use [Up arrow], [Down arrow], [Home] and [End]. To select from the list, use [Enter]. To exit without selecting a field, use [Esc]. "There are ___ records that meet your criteria. Do you wish to re-enter the criteria? [Y/N]" To continue with the conversion, enter [N] or [F10]. If the number of records doesn't seem correct, enter [Y] and verify your responses and your record selection criteria. Deleted data base records are NOT processed. Page 2 "Mark fields to be included with the PLUS key:" Field names from your data base will be displayed. To include a field in your Word Perfect merge file, use [+], otherwise use [Space], [Enter], [Up arrow] or [Down arrow]. You must mark at least one field. Memo fields are not supported and will not appear in the field list or the merge file. The default format for date fields is MM/DD/YY format (e.g. 04/30/90). Logical fields are converted to "Y" or "N". To change the format of either dates or logical values, see "Change dPerfect Merge Configuration" on Page 4. To include all your database fields in the merge file, use [F5] Include all fields. To navigate between screens of field names, use [Page up] and [Page down]. When you are finished with your field selection, use [F10] Continue. "Want to save these parameters as a setup file? [Y/N]" If you want to re-use these responses to create a merge file at another time, (or to use with dPerfect BV) enter [Y]. You will then be prompted for the name of the setup file. Do NOT use an extension for the setup file -- dPerfect will save the file with the extension ".MEM". You will be warned if the setup file already exists. A setup file will save ALL of your responses including: 1) Source data base file name 2) Expression to create index 3) File name of existing index 4) Word Perfect merge file name 5) Record selection criteria 6) Field selection A setup file, however, does NOT save any of the parameters included in the configuration file. To use the setup file, see "Using Setup Files" on Page 7. A setup file is required to use the batch version dPerfect BV (see Batch Version of dPerfect Merge on Page 12). "Do you want to print a summary sheet? [Y/N]" A summary sheet will detail all of your responses and list each field that you included along with its Word Perfect field name. The Word Perfect 5.1 field names are {FIELD}1~, {FIELD}2~, etc. The older versions of Word Perfect use field names ^F1^,^F2^ etc. The summary sheet is a useful tool for creating your Word Perfect primary merge file. It is printed to DOS port LPT1. In a Word Perfect 5.1 primary merge file, you can use either the numeric field names (e.g. {FIELD}1~), or your alphanumeric data base field names (e.g. {FIELD}zipcode~). Since WP 5.1 allows a maximum of 100 alphanumeric field names, you can mix the use of both styles in your primary merge file. For example, if your dPerfect merge file has 200 field names, you can use your data base field names for the first 100 fields, and the numeric field names for the remaining fields. Page 3CHANGE dPERFECT MERGE CONFIGURATION To exit from the configuration screen without saving your changes, use [Esc] at any time. To save your changes use [F10], or answer "Y" to "Save Configuration". To return all values to the defaults, use [F5] followed by [F10]. Default Configuration Parameters Word Perfect version: (1) WP 5.1 Date format: (1) MM/DD/YY Temporary delimiter: (1) tilde (~) Logical values: (1) Y/N Color monitor: (1) Allow automatic detection of color monitor European character set: (1) Do not convert "Word Perfect version:" dPerfect Merge will create a 5.1 compatible merge file, unless the version parameter is set to (2) WP 5.0 or (3) WP 4.2. When you first retrieve the merge file in 5.0 or 5.1, Word Perfect will reformat for your default printer. In a Word Perfect 5.1 primary merge file, you can use either the numeric field names (e.g. {FIELD}1~), or your alphanumeric data base field names (e.g. {FIELD}zipcode~). Since WP 5.1 allows a maximum of 100 alphanumeric field names, you can mix the use of both numeric and alphanumeric field names. For example, if your dPerfect merge file has 200 field names, you can use your data base field names for the first 100 fields, and the numeric field names for the remaining fields. "Date format:" The default date format is "03/30/90". To change to European format (e.g. "30/03/90") use option (2) DD/MM/YY. For dates like "March 30, 1990" use option (3) Month DD, YYYY. "Temporary delimiter:" dPerfect Merge uses a temporary delimiter to create the merge files. The default is the tilde (~) character. If your data base includes the use of the tilde, choose a delimiter that is NOT in your data. Options are the carat (^) and the horizontal bar (|). "Logical values:" Logical values are converted to "Y" or "N" unless you specify (2) YES/NO or (3) Yes/No or (4) yes/no. "Color monitor:" dPerfect Merge will automatically detect whether your monitor is color or monochrome. Some "color" monitors, however, only Page 4display colors as shades of gray -- making it very difficult to view the dPerfect Merge screens in color mode. For these systems, choose (2) Force use of monochrome (useful for laptops). Your new color choice will not take effect until the next time you use dPerfect Merge. "European character set:" dPerfect Merge will convert the high Ascii characters from decimal 128 to 175, if you choose (2) Convert. These are European characters, such as umlauts and accents. For a faster conversion, choose (1) Do not convert. Use of the Configuration File dPerfect Merge uses dPERF$$$.DBF to save configuration parameters and to coordinate the naming of temporary files for multiple users. This file must be in the DOS path. If multiple users on a network are not all using the same configuration (e.g. different version of Word Perfect), each user must have his own copy of dPERF$$$.DBF in his path. If the configuration data base is erased or becomes corrupted, restore it from your original distribution disk. Page 5 REGISTRATION INFO When you register your copy of dPerfect Merge (along with the latest version of dPerfect Merge, a printed manual and 90 days of support) you will receive a registration key. Input this key number along with your registration name to bypass the initial registration screen. After you have entered your registration info, your registration name will appear on the initial menu screen. For pricing and an order form, see Page 16. For more information, you can contact me: Newdorf Research P.O. Box 2309 Rancho Santa Fe, CA 92067 Barbara J. Feldman CompuServe ID: 73170,216 VOICE: (619) 942-0688 FAX: (619) 942-9387 "Name of Registered Owner:" Enter your registration name (either an individual or a company name) exactly as shown on your registration letter. "Registration Key:" Enter the registration key that is provided in your registration letter. You will not exit this field unless you have a valid registration key. To exit without a registration key, leave the field empty. CompuServe Offer FREE!! -- when you register, you are entitled to a free introductory subscription to CompuServe Information Service, the biggest national on-line information data base and service. You will receive a private user ID number and password, a $15 usage credit (up to 2 1/2 hours connect time at 300 baud), and a complimentary subscription to CompuServe's monthly magazine. Page 6 USING dPERFECT MERGE Help Screens Context-sensitive help screens are available from almost every input field, by use of [F1]. Press any key to exit from the help screen. Using Setup Files To use a setup file, enter it as a / parameter to dPerfect on the DOS command line. For example, to use setup file ALLZIPS.MEM, start the program with: dPERFECT /allzips You will be given the opportunity to change any of your responses. To continue without any changes, press [F10] three times. A setup file will save ALL of your responses including: 1) Source data base file name 2) Expression name to create index 3) File name of existing index 4) Word Perfect merge file name 5) Record selection criteria 6) Field selection A setup file will not save the configuration parameters (such as Word Perfect version, or data format). Setup files may be used with the interactive version (dPERFECT.EXE) but are required with the batch version (dPERFBV.EXE). They can not be used with the Clipper function version (dPERFECT.OBJ). For more information on creating setup files, see "Want to save this parameters as a setup file?" on Page 3. Versions of Word Perfect Supported The default Word Perfect version is 5.1. To create a 5.0 or 4.2 compatible merge file, change the dPerfect Merge configuration (from the main menu). Word Perfect 5.1 merge files include data base field names -- allowing you to create primary merge files using your data base field names. Word Perfect 5.1 allows a maximum of 100 alphanumeric field names. Additional fields can be accessed by their numeric field name (e.g. {FIELD}101~). For more information, see your Word Perfect reference manual. Using Word Perfect Merge Files dPerfect creates a Word Perfect secondary merge file. The secondary file is the list of variable data (such as names, addresses, phone numbers) that is merged with your fixed data (primary file) to create form letters, mailing labels, etc. To create the primary merge file (the actual form letter, or mailing label format), use Word Perfect. Insert ?merge codes for each variable field [Shift-F9], using either the numeric or alphanumeric (WP 5.1 only) field name. Using a printed summary sheet from dPerfect Merge, will make it easier to remember the field names and numbers. To begin the merge from within Word Perfect, use [Ctrl F9] [Merge] and name your secondary and primary files. For additional information, see your Word Perfect reference manual. Uses for dPerfect Merge include mailing labels, personalized form letters, data base publishing, directories, and lists. Network Capabilities of dPerfect Merge dPerfect Merge will operate in a network environment allowing multiple users to access common data bases using record locking. If your source data base is unavailable for shared use, you will be given the opportunity to either retry or exit. The configuration file dPERF$$$.DBF must be located in the DOS path. This file is used to coordinate the naming of temporary files among multiple users, and stores the configuration parameters. If individual users need to have different dPerfect Configuration parameters, place dPERF$$$.DBF on a local or private drive. dPerfect Merge requires Read/Write/Create/Delete privileges in the current directory so that it may create and delete its temporary files. Use of the Tilde (~) Character WARNING!! If your data contains the tilde (~) character, dPerfect Merge MAY have trouble converting your data correctly because the tilde is used as a temporary delimiting character during the conversion. To resolve any conflicts, change the delimiter character on the configuration screen. Working Disk Space Required dPerfect Merge requires approximately twice the space of the merge file you wish to create. For example, if your data base is 10 MB in length and you are converting 30% of your records to a merge file, dPerfect will require 3 MB in temporary disk space and 3 MB for your merge file -- totaling 6 MB. Temporary Working Files dPerfect Merge creates and erases a variety of temporary working files. If the program is interrupted by a power failure, or the system is rebooted while dPerfect is running, the temporary files will NOT be erased. The temporary files are created in the current directory, and are named "DP$$$xxx.*" where xxx is a number from "000" through "999". Page 8 Minimum DOS Configuration Required dPerfect Merge requires DOS 3.1 or greater and 512Kb memory. dPerfect Merge works on dBase III Plus, Clipper, FoxPro, FoxBase or compatible data bases and supports "ndx" index files. Clipper "ntx" index files are supported by the Clipper (S'87) function dPerfect() in dPERFECT.OBJ. dPerfect supports up to 1024 fields per data base and 510 selected fields per merge. dPerfect creates secondary merge files for either Word Perfect 5.1, 5.0 or 4.2. CONFIG.SYS must contain "Files=10" or greater. For more information on CONFIG.SYS, consult your DOS manual. The configuration file dPERF$$$.DBF must be located in the DOS path. This file is used to coordinate the naming of temporary files among multiple users, and stores the configuration and registration parameters. If individual users on a network need to have different dPerfect Configuration parameters, place dPERF$$$.DBF on a local or private drive. Page 9Index Key Expressions Data Operator Type Meaning Example ---------------------------------------------------------------------------- + C Concatenation STATE+CITY + N Addition TAX+AMOUNT + D+N Adds days to date ORDER_DATE+AR_AGE - D-N Subtracts days from date CLOSE_DATE-LEN_ESCRW - D-D Elapsed days between dates SALE_DATE-LIST_DATE DTOS() D Convert date to character DTOS(SALE_DATE) STR() N Convert numeric to character STR(NUMBER) VAL() C Convert character to numeric VAL(CHAR_AMT) Be sure to consider the data type of your fields when creating a key index expression. Use DTOS(date_field) to convert dates to character type suitable for indexing. To create multiple level sorts, use concatenation. For example, to sort by state, followed by city, followed by sold date, followed by last name and first name: STATE+CITY+DTOS(SOLD_DATE)+LAST_NAME+FIRST_NAME Page 10 Record Selection Criteria Data Record Selection Operator Type Meaning Example ------------------------------------------------------------------------- = C,N,D Equal to ZIPCODE="92561" <> or # C,N,D Not equal to STATE <> "TX" > C,N,D Greater than AMOUNT > 100 < C,N,D Less than AMOUNT < 100 >= C,N,D Greater than or equal to AMOUNT >= 100 <= C,N,D Less than or equal to AMOUNT <= 100 $ C Contained within PROD_TYPE $"1234" .AND. L True if both expressions STATE="TX" .AND. are true AMOUNT>100 .OR. L True if either expression STATE="TX" .OR. is true AMOUNT>100 .NOT. L True if expression is false .NOT. STATE = "TX" + N Addition AMOUNT+TAX > 1000 + C Concatenation FIRST+LAST="JOHNSMITH" + D+N Adds days to date ORDER_DATE+10 < DATE() - N Subtraction GROSS-NET>10000 - D-N Subtracts days from date SHIP_DATE-10 <= ORDER_DATE - D-D Elapsed time between dates SHIP_DATE-ORDER_DATE > 10 * N Multiplication AMOUNT*TAX_RATE > 1000 / N Division TOT_AMT/AVG_PRICE > 10 Record selection criteria must be logical expressions -- expressions that evaluate to either .T. (true) or .F. (false). In addition to the operators listed above, any valid Clipper function may be used (e.g. !EMPTY(AMOUNT)) Be sure to use consider the data type of the fields that you are selecting. The contents of data fields must be enclosed in quotes. For example, if ZIPCODE is a character field: ZIPCODE = 90304 Not a valid expression ZIPCODE = "90304" Is a valid expression Page 11 BATCH VERSION OF dPERFECT MERGE The Batch Version of dPerfect Merge allows batch processing of your conversion, and does not require any keyboard input. dPERFECT BV uses a setup file to specify all the input parameters. It is designed to be called from a DOS batch file, from a DOS menu or from any program that can run external .EXE files. It allows a programmer to integrate dPerfect Merge into a customized system, without training the end-user on dPerfect Merge. dPERFBV will clear the screen before executing, and restore the original screen upon exit. Using the Batch Version of dPerfect (dPERFBV.EXE) To create a setup file for dPerfect BV, first use the interactive version (dPERFECT.EXE) and save your input as a setup file. After the setup file has been saved, call dPERFBV from the DOS command line or in a batch file. Remember, the setup file is a required parameter. For example: dPERFBV /setup dPerfect BV sets the DOS ERRORLEVEL as follows: ERRORLEVEL = 1 Successful completion ERRORLEVEL = 2 Fatal error If there is an error, the user is warned as to the type of error -- and is prompted to "Press Return To Continue". This is the only user input that is required. When there is a successful completion, the user is returned to the calling program (without requiring any user keystrokes). WARNING: dPerfect BV does NOT warn before writing over an existing merge file. Sample Batch File (dP_BTEST.BAT): ECHO OFF CLS ECHO This batch file assumes a setup file named "TEST" ECHO otherwise, the merge file will not be generated. PAUSE dperfbv /test CLS IF ERRORLEVEL 2 GOTO no_wp ECHO Creation of merge file successful! ECHO Word Perfect can be started with a macro that ECHO will do the merge. The following assumes that ECHO the macro is named "MERGE". PAUSE wp /m-merge GOTO end :no_wp ECHO An error prevented the creation of the merge file. PAUSE :end Page 12CLIPPER FUNCTION dPERFECT() For Clipper (Summer '87) programmers, dPerfect() is provided as an .OBJ object file to include in your linkage. dPerfect() Syntax dPerfect("MERGE.SF", ARRAY) dPerfect() Arguments "MERGE.SF" is the filename of the merge file to be created -- be sure to include it in quotes. ARRAY is the field selection array, indicating which fields are to be included in the merge file. For a field to be included, the corresponding array element must be "+". Any other value, and the field will not be included in the merge file. The ARRAY parameter is optional. If it is not specified, all fields will be included in the merge file. See the example below. dPerfect() Return Value dPerfect() returns the number of records that are translated to the merge file, as well as setting the DOS errorlevel as follows: ERRORLEVEL () = 1 Successful completion ERRORLEVEL () = 2 No merge file was specified ERRORLEVEL () = 3 Configuration record busy ERRORLEVEL () = 4 No records in source data base ERRORLEVEL () = 5 No fields included in selection array ERRORLEVEL () = 6 Temporary file busy ERRORLEVEL () = 7 Cannot open/write/close merge file dPerfect() Usage Before calling the dPerfect() function, a data base must be selected. Any indices or filters that are in use will be reflected in the merge file. This provides for the use of .NTX index files which are not supported in the interactive (dPERFECT.EXE) or batch (dPERFBV.EXE) versions of dPerfect Merge. SET DELETED ON/OFF will affect whether deleted records are processed. If "merge.sf" exists, it will be rewritten without warning. There is no error trapping included in dPerfect(). Fatal errors will be handled by Clipper (for example, if you are out of disk space). Other errors will result in an ERRORLEVEL() > 1. Upon exiting dPerfect(), your source data base will be selected and the record pointer will be at TOP. The screen and its original colors will be restored, the cursor will be on and DATE will be set to either AMERICAN or BRITISH (depending on the setting of your configuration file dPERF$$$.DBF). This configuration file must be in the DOS path. There is no user input required at any time during the execution of dPerfect(). The registered version of dPerfect() does NOT write to the screen at any time. Page 13Sample Clipper Program (dP_CLIPP.PRG): * This assumes a database named "database", * an index named "data_ntx", and a * filter expression named "data_filtr" SELECT A USE database && select your data base SET INDEX TO data_ntx && optional index SET FILTER TO &data_filtr && optional filter DECLARE array[FCOUNT()] && create optional array AFILL (array,"+") && fill with pluses array[1] = SPACE(1) && DO NOT translate 1st field count = dPerfect("merge.sf",array) && create "merge.sf" IF ERRORLEVEL() = 1 && successful completion ? STR(count) && display # records ELSE ? "Sorry -- dPerfect Error!" && error occurred ENDI Page 14 DEFINITION OF SHAREWARE Shareware distribution gives users a chance to try software before buying it. If you try a Shareware program and continue using it, you are expected to register. Copyright laws apply to both Shareware and commercial software, and the copyright holder retains all rights, with a few specific exceptions as stated below. Shareware authors are accomplished programmers, just like commercial authors, and the programs are of comparable quality. (In both cases, there are good programs and bad ones!) The main difference is in the method of distribution. Shareware is a distribution method, not a type of software. You should find software that suits your needs and pocketbook, whether it's commercial or Shareware. The Shareware system makes fitting your needs easier, because you can try before you buy. And because the overhead is low, prices are low also. Shareware has the ultimate money-back guarantee -- if you don't use the product, you don't pay for it. DISCLAIMER - AGREEMENT Users of dPerfect Merge must accept this disclaimer of warranty: "dPerfect Merge is supplied as is. The author disclaims all warranties, expressed or implied, including, without limitation, the warranties of merchantability and of fitness for any purpose. The author assumes no liability for damages, direct or consequential, which may result from the use of dPerfect Merge." dPerfect Merge is a "shareware program" and is provided at no charge to the user for evaluation. Feel free to share the self-extracting archive file with your friends, but please do not give it away altered or as part of another system. The essence of "user-supported" software is to provide personal computer users with quality software without high prices, and yet to provide incentive for programmers to continue to develop new products. If you find this program useful and find that you are using dPerfect Merge and continue to use dPerfect Merge after a 30 day trial period, you must make a registration payment of $24 to Newdorf Research. The $24 registration fee will license one copy for use on any one computer at any one time. Commercial users of dPerfect Merge must register and pay for their copies of dPerfect Merge within 30 days of first use or their license is withdrawn. Site-License arrangements may be made by contacting Newdorf Research. Anyone distributing dPerfect Merge for any kind of remuneration must first contact Newdorf Research at the address below for authorization. This authorization will be automatically granted to distributors recognized by the (ASP) as adhering to its guidelines for shareware distributors, and such distributors may begin offering dPerfect Merge immediately. (However Newdorf Research must still be advised so that the distributor can be kept up-to-date with the latest version of dPerfect Merge.) You are encouraged to pass a copy of dPerfect Merge along to your friends for evaluation. Please distribute the self-extracting archive file (rather than individual files) and encourage them to register their copy if they find it useful. All registered users will receive a copy of the latest version of dPerfect Merge, a printed manual and a registration key that will bypass the initial registration screen. Page 15 TO REGISTER YOUR COPY OF dPERFECT MERGE Receive the latest version of dPerfect Merge, a printed manual, 90 days of support via phone, fax, mail or CompuServe -- AND you are entitled to a free introductory CompuServe subscription and $15 usage credit. NOTE: Your registered copies of dPerfect Merge will not display the registration screen. Site-License arrangements may be made by contacting Newdorf Research. US Pricing US Pricing Qty: 5 1/4" disk: 3 1/2" disk: 1-10 $24 $25 11-50 $22 $23 Disk Size: [ ] 5 1/4" [ ] 3 1/2" Quantity:_________ X Price: $_____________ = Total $___________ California Sales Tax (6.25%) $___________ Mexico & Canada Shipping/Handling QTY ______ X $1.00 each $___________ Other FOREIGN Shipping/Handling QTY ______ X $4.00 each $___________ Total Enclosed $___________ Send check or money order (in US funds drawn on US bank, please) To: Newdorf Research P.O. Box 2309 Rancho Santa Fe, CA 92067 Name of Registered Owner:_________________________________________ (list name or company exactly as you wish it to appear on the screen) Contact Person:___________________________________________________ Company:__________________________________________________________ Address:___________________________________________________________ City:________________________________ State:_________Zip:__________ Phone: (______)___________________CompuServe User ID:______________ Where did you get your copy of dPerfect Merge?_____________________ Comments and Suggestions:__________________________________________ ___________________________________________________________________ Page 16 INDEX ASP . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 15 Batch Processing. . . . . . . . . . . . . . . . . . . . . . . . . . Page 12 Carat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Clipper . . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 13 Summer '87 . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13 Color monitors. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 CompuServe. . . . . . . . . . . . . . . . . . . . . . . . . .Page i, Page 6 CONFIG.SYS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9 Configuration . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 7 Defaults . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 File . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5, Page 8 Control Keys [Ctrl-Y] . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 [Esc]. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 [F10]. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 [F2] . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1, Page 2 [F4] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 [F5] . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4 Create Merge File . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Dates European . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Formats. . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 dBase III Plus. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Deleted records . . . . . . . . . . . . . . . . . . . . . . Page 2, Page 13 Delimiter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Carat. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Horizontal bar . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Tilde. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Directory Listing . . . . . . . . . . . . . . . . . . . . . .Page 1, Page 2 Disk Space Required . . . . . . . . . . . . . . . . . . . . . . . . .Page 8 DOS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9 dP_BTEST.BAT. . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 12 dP_CLIPP.PRG. . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 14 dP_READ.ME. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page i dPERF.EXE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page i dPERF$$$.DBF. . . . . . . . . . . . . . . . . . . . .Page 5, Page 8, Page 9 dPERFBV.EXE . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 12 dPERFECT.OBJ. . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13 DPerfect(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13 Errorlevels . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 12 European characters . . . . . . . . . . . . . . . . . . . . . . . . .Page 5 Expressions, logical. . . . . . . . . . . . . . . . . . . . . . . . Page 11 Field names . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4, Page 7 Fields. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Date . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4 Field names. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Logical. . . . . . . . . . . . . . . . . . . . .Page 1, Page 3, Page 4 Memo . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1, Page 3 Page 17 Filename Extensions. . . . . . . . . . . . . . . . . . . . . . . . .Page 2 .DBF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 .MEM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 .NDX . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2, Page 9 .SF. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2 Filenames . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page i Filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13 Help screens. . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 7 Horizontal Bar. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 13 Index Expression. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Key Expression. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Logical Expressions . . . . . . . . . . . . . . . . . . . . . . . . Page 11 LPT1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Monochrome monitors . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Networks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 8 Operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 11 Print . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Record Selection. . . . . . . . . . . . . . . . . . . . . . Page 2, Page 11 Register dPerfect Merge . . . . . . . . . . . . . . . . . . . . . . Page 16 Registration key. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Save Setup File . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Selection Criteria. . . . . . . . . . . . . . . . . . . . . . . . . .Page 2 Setup File. . . . . . . . . . . . . . . . . . . . . Page 3, Page 7, Page 12 Shareware . . . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 15 Sort. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Source data base. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Summary Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Support . . . . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 16 Temporary working files . . . . . . . . . . . . . . . . . . . . . . .Page 8 Tilde . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 8 Warranty. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 15 Word Perfect 4.2. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2, Page 4 5.0. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2, Page 4 5.1. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2, Page 4 Field Names. . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4 Primary merge file . . . . . . . . . . . . . . . . . . . . . . .Page 3 Secondary merge file . . . . . . . . . . . . . . . . . .Page 2, Page 7 Versions . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 7 Page 18