ProfitPress Mega CDROM2 Shareware Freeware (MSDOS)(1992)(Eng)

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

/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / TEXT / EDITOR / DPRFTMRG.ZIP / DPERFECT.DOC < prev next >

Wrap

Text File | 1990-09-26 | 45.3 KB | 1,064 lines

▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ dPerfect Merge Converts data base files to Word Perfect secondary merge files Copyright (c) 1990 Newdorf Research 1565 Regatta Road Laguna Beach, CA 92651 Barbara J. Feldman CompuServe ID: 73170,216 ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ 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 1 dPerfect Merge Table of Contents CREATE MERGE FILE . . . . . . . . . . . . . . . . . . . . . . . . . Page 3 "Enter path and filename of source data base file:". . . . . . Page 3 "Enter key expression to create index:". . . . . . . . . . . . Page 3 "OR enter path and filename of existing index:" . . . . . . Page 4 "Enter path and filename of Word Perfect secondary merge file to be created:" . . . . . . . . . . . . . . . . . . . . . . . . Page 4 "Enter record selection criteria:" . . . . . . . . . . . . . . Page 4 "There are ___ records that meet your criteria". . . . . . . . Page 4 "Mark fields to be included with the PLUS key:". . . . . . . . Page 5 "Want to save these parameters as a setup file? [Y/N]" . . . . Page 5 "Do you want to print a summary sheet? [Y/N]". . . . . . . . . Page 5 CHANGE dPERFECT MERGE CONFIGURATION . . . . . . . . . . . . . . . . Page 6 Default Configuration Parameters . . . . . . . . . . . . . . . Page 6 "Word Perfect Version:". . . . . . . . . . . . . . . . . . . . Page 6 "Date format:" . . . . . . . . . . . . . . . . . . . . . . . . Page 6 "Temporary Delimiter:" . . . . . . . . . . . . . . . . . . . . Page 6 "Logical Values:". . . . . . . . . . . . . . . . . . . . . . . Page 6 Use of the Configuration File. . . . . . . . . . . . . . . . . Page 6 REGISTRATION INFO . . . . . . . . . . . . . . . . . . . . . . . . . Page 7 "Name of Registered Owner:". . . . . . . . . . . . . . . . . . Page 7 "Registration Key:". . . . . . . . . . . . . . . . . . . . . . Page 7 CompuServe Offer . . . . . . . . . . . . . . . . . . . . . . . Page 7 USING dPERFECT MERGE. . . . . . . . . . . . . . . . . . . . . . . . Page 8 Using Setup Files. . . . . . . . . . . . . . . . . . . . . . . Page 8 Versions of Word Perfect Supported . . . . . . . . . . . . . . Page 8 Using Word Perfect Merge Files . . . . . . . . . . . . . . . . Page 8 Network Capabilities of dPerfect Merge . . . . . . . . . . . . Page 9 Use of the Tilde (~) Character . . . . . . . . . . . . . . . . Page 9 Working Disk Space Required. . . . . . . . . . . . . . . . . . Page 9 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 2 dPerfect Merge Converts 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 9 seconds). Answer each question followed by [Enter]. 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 from which your data will be read and converted. 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 that is 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]. Page 3 "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 name 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 field 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. However, if you do not specify an extension, ".SF" is used. The merge file is created in Word Perfect 5.0 format (which also works with WP 5.1) unless your configuration file specifies otherwise. For more information on changing to a WP 4.2 format merge file, see "Change dPerfect Merge Configuration" on Page 6. For more information on using this file to create merge letters, see "Using Word Perfect Merge Files" on Page 8. "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). 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. Page 4 "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 6. "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 To use the setup file, see "Using Setup Files" on Page 8. 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 (e.g. ^F1^,^F2^). This is a useful tool for creating your Word Perfect primary merge file. The summary sheet is printed to DOS port LPT1. Page 5 CHANGE 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.0 or greater Date format: (1) MM/DD/YY Temporary Delimiter: (1) tilde (~) Logical Values: (1) Y/N "Word Perfect Version:" dPerfect Merge will create a 4.2 compatible merge file, if the version parameter is set to (2) WP 4.2. Otherwise, the merge file will be 5.0 format (which can also be used in 5.1). When you first retrieve the merge file in 5.0 or 5.1, Word Perfect will reformat for your default printer. In WP 5.1, you have the option of converting the 5.0 merge codes into 5.1 format, or using them without conversion. "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. 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 6 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 us: Newdorf Research 1565 Regatta Road Laguna Beach, CA 92651 Barbara J. Feldman CompuServe ID: 73170,216 "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 7 USING dPERFECT MERGE 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 5. Versions of Word Perfect Supported The default Word Perfect version is 5.0 (which also works on 5.1). To create a 4.2 compatible merge file, change the dPerfect Merge configuration (from the main menu). Word Perfect 5.1 gives you the option of either using 5.0 merge files, or converting them to the 5.1 format. 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 begin the merge from within Word Perfect, use [Ctrl F9] [Merge] and name your secondary and primary files. If you use Word Perfect 5.0 or 5.1 to edit your secondary merge file, you may notice that Word Perfect will automatically reformat the merge file to match your default printer. For additional information, see your Word Perfect reference manual. Uses for dPerfect Merge include: 1) Mailing labels 2) Personalized form letters 3) Data base publishing 4) Directories, lists, etc. Page 8 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. 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 function dPerfect() in dPERFECT.OBJ. dPerfect supports up to 1024 fields per data base. dPerfect creates secondary merge files for either Word Perfect 4.2, or Word Perfect 5.0 (which also work on WP 5.1). 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 9 Index 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 having to train 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 12 CLIPPER FUNCTION dPERFECT() For Clipper 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. 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(). Page 13 Sample 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. You must treat this software just like a book. An example is that this software may be used by any number of people and may be freely moved from one computer location to another, so long as there is no possibility of it being used at one location while it's being used at another. Just as a book cannot be read by two different persons at the same 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 renumeration 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 1565 Regatta Road Laguna Beach, CA 92651 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 1, Page 15 Batch Processing. . . . . . . . . . . . . . . . . . . . . . . . . . Page 12 Carat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Clipper . . . . . . . . . . . . . . . . . . . . . . . . . . Page 3, Page 13 CompuServe. . . . . . . . . . . . . . . . . . . . . . . . . .Page 1, Page 7 CONFIG.SYS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9 Configuration . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 8 Defaults . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 File . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 9 Control Keys [Ctrl-Y] . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 [Esc]. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 [F10]. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 [F2] . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4 [F4] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 [F5] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Create Merge File . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Dates European . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Formats. . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 dBase III Plus. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5 Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Delimiter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Carat. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Horizontal bar . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Tilde. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Directory Listing . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4 Disk Space Required . . . . . . . . . . . . . . . . . . . . . . . . .Page 9 DOS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9 dP_BTEST.BAT. . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 12 dP_CLIPP.PRG. . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 14 dP_READ.ME. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 dPERF.EXE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 dPERF$$$.DBF. . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 9 dPERFBV.EXE . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 12 dPERFECT.OBJ. . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13 DPerfect(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13 Errorlevels . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 12 Expressions, logical. . . . . . . . . . . . . . . . . . . . . . . . Page 11 Fields. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5 Date . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5, Page 6 Field names. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Logical. . . . . . . . . . . . . . . . . . . . .Page 3, Page 5, Page 6 Memo . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 5 Filename Extensions . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 .DBF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 .MEM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5 .NDX . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 9 .SF. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Filenames . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1 Filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13 Horizontal Bar. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6 Page 17 Index. . . . . . . . . . . . . . . . . . . . . . . Page 3, Page 4, Page 13 Index Expression. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Key Expression. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Logical Expressions . . . . . . . . . . . . . . . . . . . . . . . . Page 11 LPT1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5 Networks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9 Operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 11 Print . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5 Record Selection. . . . . . . . . . . . . . . . . . . . . . Page 4, Page 11 Register dPerfect Merge . . . . . . . . . . . . . . . . . . . . . . Page 16 Registration key. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 7 Save Setup File . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5 Selection Criteria. . . . . . . . . . . . . . . . . . . . . . . . . .Page 4 Setup File. . . . . . . . . . . . . . . . . . . . . Page 5, Page 8, Page 12 Shareware . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 15 Sort. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Source data base. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3 Summary Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5 Support . . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 16 Tilde . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 9 Warranty. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 15 Word Perfect 4.2. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 6 5.0. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 6 5.1. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 6 Field Names (^F1^) . . . . . . . . . . . . . . . . . . . . . . .Page 5 Primary merge file . . . . . . . . . . . . . . . . . . . . . . .Page 5 Secondary merge file . . . . . . . . . . . . . . . . . .Page 4, Page 8 Versions . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 8 Page 18