COREL® Solution Partners Web site
http://partners.corel.com

* * * * * * * * * * * * *

Software Developer Kits (SDK)
http://www.corel.com/partners_developers/csp/soft_kits.htm

* * * * * * * * * * * * *

COREL® Solution Partners Software Order form (UPDATED)
ftp://cspusr:MSERFL@sftp2.corel.ca/csp/cspusr/csp_orderform.pdf

As part of the Corel Solution Partners Program, we are providing our Platinum & Paradox members with the opportunity to obtain a CorelDRAW® 10 Beta2 CD. If you are interested in obtaining this Beta2 CD, please e-mail your request to partners@corel.com. All Corel Solution Partners Platinum & Paradox members requesting this Beta2 CD will be required to complete, sign and return a "BETA Testing Agreement" before the Beta2 CD is shipped. Once again, these Beta2 CD's are only available to Platinum & Paradox members.

Alternatively, members can become officially registered Corel BETA testers by applying to the Corel BETA Program located on-line at: http://www.corel.com/betaprogram/index.htm.

For more information relating to this show, please visit the Linux Expo website at: http://www.linuxexpo.com/

• Corel WordPerfect OFFICE 2000 "THE OFFICIAL GUIDE" - CSP Price = $20 US + shipping
• CorelDRAW™8 "THE OFFICIAL GUIDE" - CSP Price = $15 US + shipping
• CorelDRAW® 9 "THE OFFICIAL GUIDE" - CSP Price = $20 US + shipping

As part of the Corel Solution Partners membership, we are providing all Platinum and Paradox members with the opportunity to obtain a Corel Paradox® Runtime SP3 Patch CD. If you are interested in obtaining this CD, please e-mail your request to partners@corel.com. Once again, these CD's are only available to CSP Platinum and Paradox members only.

Alternatively, the Corel Paradox® Runtime SP3 Patch can be downloaded from Corel's website at: http://www.corel.com/support/ftpsite/pub/paradox/paradox9/index.htm.

The Paradox Developer Newsletter will be transmitted on August 1st, 2000. Again, we would like to invite all CSP Members interested in receiving our new monthly Corel® Paradox Developer Newsletter to please register on-line at: http://195.7.54.129/paradox_subscribe/. This newsletter will prove to be quite informative and extremely valuable to those interested in keeping abreast of Corel® Paradox issues and developments. We look forward to your comments and feedback.

Developer TIPS

To show you how OLE Automation works with WordPerfect, we will use Visual Basic 4.0 as our developer tool. Below is a complete example on how to complete a task defined in WordPerfect.

• Our task will be to take a Paradox database and merge all the records into a WordPerfect merge data file.
• Once this task is completed, we will save the data file to disk and then complete the merge process in WordPerfect by creating a form letter to send out to various individuals.
• Once this has been accomplished, we will print each of the form letters.
  

PerfectScript Commands Used

We will use the ImportDatabase, FileSave, MergeRun, and PrintFull commands as well as other commands required to accomplish this task.

Files Required and Created

To accomplish this task, we will need a Paradox database, and a WordPerfect merge form letter. During this task we will create a WordPerfect merge data file from the database and the result of the accomplished task will be form letters to send to each of the names in the database.

Private Sub BtnCreateCustomerAd_Click()

'The OLE automation object to use with PerfectScript
Dim WP As Object 




'Holds the field names in the database
Dim sFieldNames As String 


'Holds the name of the database
Dim sDatabaseName As String


'Holds the secondary merge file name
Dim sDataFile As String


'Holds the merge form file name 
Dim sFormFile As String 




'Create a new document if you can, already has a WP object defined
CheckOpenDocuments (True)   


'Create the WordPerfect object needed to send OLE Automation commands
Set WP = CreateObject("WordPerfect.PerfectScript")


'Define the field names to put into the secondary merge file
sFieldNames = "Contact ID,Company Name," 
sFieldNames = sFieldNames + "Contact Name,Title,Address,"
sFieldNames = sFieldNames + "City,State,Country,Postal Code"



'sRootPath is a global to our program root path
sDatabaseName = sRootPath + "data\customer.db" 


'All predefined files are stored off this path
sFormFile = sRootPath + "docs\cstadver.frm" 


'Start sending the OLE Automation code to WP
With WP    


'Set the database filename to import
.ImportSetFileName sDatabaseName  


'Set the source, 34 is a paradox database
.ImportSetSource 34


'Set the destination, 3 is a secondary merge file
.ImportSetDestination 3   


'Set the field names to import
.ImportSetFields sFieldNames
  
'Set the query
.ImportSetQuery   


'Do the import of the data.  This will create the file in 
'WP.  We must now save it out to disk
.ImportDoImport   


'Save the sec. merge file to disk under this name in WP6 format
.FileSave sRootPath + "docs\dbdoc.dat", 6 


'Get the name of the file saved.  Bypass this step most of the time
'by knowing, as in the above example, the name of the saved file.
sDataFile = .EnvPath + .EnvName  


'Close the secondary merge file created
.Close 0    


'Maximize WP
.AppMaximize    


'Select the type of merge to perform 0 is all records
.MergeSelect 0


'Perform the merge.  The first 2 in the command tells PerfectScript to
'merge from a form file on disk.  The second 2 tells PerfectScript to
'merge from a secondary file on disk. And the last parameter, a 1,
'tells PerfectScript to create a new document with the 'merged data.
.MergeRun 2, sFormFile, 2, sDataFile, 1 




'Optionally, you can but don't have to delete the secondary merge
'file.
.FileDelete sDataFile   


'This is a mandatory command to send at the end of each sequence of
'PerfectScript commands sent through OLE Automation.  If you do not
'send this command, WordPerfect will be left in a macro play state and
'will not work properly.
.Quit     


'End the OLE Automation command stream
End With    


'Release the OLE Automation object
Set WP=Nothing    
End Sub