Corel Products. Performance. Value. Compatibility.


| CSP Website |




CSP Newsletters

CSP S/W Orderform
   *Revised*

Feature Web Site
   of the Month

CorelDRAW® 10
   *Now Available*

WordPerfect® 2002
   **Coming Soon**

New Corel Corp.
   Repositions for Growth**
   Growth

Paradox® Newsletter
   **Coming Soon**





DEVELOPER TIPS


*PerfectScript Macro:*
- Launching an application
   with a command Line
  parameter


*Paradox® :*
- using a variable in
   a tcursor





Newsletter: your connection to corel

January 2001 Corel Solution Partners
Newsletter


"Boundless power to create. Anytime. Anywhere.
Share Corel's vision."


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

The CSP Members Web site contains private sections for Paradox, Platinum and Standard CSP members only.

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

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

CSP members can tap into the leading-edge developer tools and technology provided in the Corel® Software Developer Kits (SDKs). The SDKs also include documentation and sample code to help reduce development time and to create a similar look and feel to other Corel products.

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

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

CorelDRAW®10 for Windows has been added to the CSP software order form




FEATURE WEB SITE OF THE MONTH
http://paradoxtips.free.fr/eng/index.html

This website was developed by a devoted Corel Paradox® fan --- Pascal Hutton. On this site, you will find an abundance of Tips & API calls related to Corel Paradox®.


CorelDRAW® 10 - available to all CSP members

CorelDRAW® 10 Graphics Suite (full version) is now available for shipping to all CSP Platinum & Paradox members at "No Charge". All Platinum & Paradox members interested in receiving this product should email their request to partners@corel.com Also, all Standard CSP members can purchase CorelDRAW® 10 by completing the online CSP Software Order Form.




WordPerfect® Office 2002 Coming This Spring!
Customer priorities reflected in new version of flagship office suite

Ottawa, Canada – Jan 30, 2001
Today, Corel Corporation (NASDAQ: CORL, TSE: COR) is pleased to announce that the next version of its flagship office suite, WordPerfect® Office 2002, will be available for purchase in North America starting in the spring of 2001. The beta version of WordPerfect® Office 2002 is now in its final testing stage and is being evaluated by media across North America. WordPerfect® Office 2002 Standard Edition will feature the latest versions of the core applications – WordPerfect® 10, Quattro® Pro 10, Corel® Presentations™ 10 and CorelCENTRAL™ 10. In addition to these applications, the Professional Edition will include the powerful database Paradox® 10 and the voice-recognition software Dragon NaturallySpeaking™ 5.0. Recognized worldwide for its superior quality and performance, Dragon NaturallySpeaking is ideal for individuals with accessibility needs and for those who prefer to dictate their text directly into WordPerfect®.

"Over 70 percent of the new features and enhancements developed for WordPerfect Office 2002 are the direct result of feedback from our customers," said Graham Brown, executive vice-president, business applications for Corel Corporation. "This release is designed to improve the overall software experience for our users, giving them the core features they've come to expect while boosting functionality and performance to put the full power of the suite into their hands."

The upcoming release of Corel's flagship office suite will include the electronic version of the world's most trusted reference – The Pocket Oxford Dictionary – created by Oxford University Press. With the click of a mouse, Corel's WordPerfect® customers will have fast and easy access to more than 30,000 word definitions, saving them time and effort as they create their documents.

WordPerfect® customers will also enjoy the time-saving features that have been built into CorelCENTRAL 10. With new and enhanced capabilities, Corel's e-mail client will facilitate the sending and receiving of e-mail messages and provide access to one central address book from all of the suite's applications. CorelCENTRAL 10 also supports groupware, multiple e-mail accounts and the sharing of address books. Users will be able to organize their time more efficiently as they schedule events, tasks and meetings with the simple and attractive new design of CorelCENTRAL 10.

Corel is committed to rewarding customer loyalty. Existing WordPerfect® customers will be eligible to receive the upgrade price of US $159 for the Standard Edition of the suite or US $259 for the Professional Edition. The full version of WordPerfect® Office 2002 Standard Edition will be available for US $399 and the full version of the Professional Edition will be available for US $499. Prices are subject to change. Dealers may sell for less.

Note: Corel WordPerfect® Office 2002 Beta2 CD's will be made available to Corel Solution Partners PLATINUM & PARADOX members requesting a copy. Please email partners@corel.com if you would like to receive this Beta CD. Again, this offer is for PLATINUM & PARADOX members only.



New Corel Repositions for Growth
Corporate strategy provides blueprint for the future

Ottawa, Canada – Jan 23, 2001
Today, Corel Corporation (NASDAQ: CORL, TSE: COR) is pleased to announce the details of a new corporate strategy designed to reposition the company for long-term growth and profitability.

Corel will leverage its solid foundation as a global technology leader with over 15 years of experience to enhance its relationships with existing customers while targeting new customers in emerging markets fueled by the rapid expansion of the Web and the increasing demand for graphics-rich visual communication.

"This strategy represents the start of an important new chapter in Corel's history. It is a long-term program based on three key principles that will form the basis of Corel's business philosophy for the future: Dynamic Technology, Dedication to the Customer and Disciplined Financial Management," said Derek J. Burney, president and CEO of Corel Corporation. " Our blueprint for the future includes a solid foundation, a clear plan, and space for growth through strategic investments and acquisitions. We are committed to success and we believe that this plan, properly executed, will result in Corel's return to profitability by the third quarter of this fiscal year. By building on our core strengths and directing our efforts strategically, we have the opportunity to grow the company's revenues at a compounded annual growth rate of at least 20% over the next three years."

These targets are based on the objectives that have been established for each of Corel's product groups:

Linux®: The company's expanding vision for Linux® includes providing customers with a bundled solution that minimizes the total cost of ownership and eliminates integration issues. To realize its Linux vision and to increase the value of its Linux equity for both customers and shareholders, Corel is actively pursuing opportunities to allow it to spin off the Linux Distribution element of its Linux division while retaining an interest in the new prospective company. Corel will continue to develop brand name applications for the Linux operating system including WordPerfect® Office for Linux and CorelDRAW® for Linux.

WordPerfect®: Corel's flagship office suite will generate significant revenues and contribution for the company. With its long-standing reputation for word-processing excellence, WordPerfect® remains the choice of professional users who work extensively on longer, format-rich documents. Its stability and unique features are renowned by users in the legal community and in government offices where specialized formatting and stability are critical to productivity.

Corel recognizes that there are untapped opportunities within its existing user base of dedicated WordPerfect customers and that there is a strong business in satisfying this community. Corel will further enhance its relationship with its WordPerfect customers to ensure that their priorities are addressed with each release and update to the product. Over 70% of the new features and enhancements planned for WordPerfect® Office 2002 are based directly on client feedback. Corel's commitment to its WordPerfect customers will be reflected in targeted sales and marketing programs that will reward customer loyalty through preferred pricing and licensing options. In addition, the company will leverage premium sales channels to service its professional customers in the small-to-medium sized corporate market.

The company is committed to supporting profitable business practices. Corel will invest heavily in campaigns to support English versions of WordPerfect, both in North America and in International markets since these are products for which there is a demonstrated customer demand. This strategic investment is consistent with the company's vision for future profitability.

Creative Products: The company's creative products will provide the primary engine for revenue growth. Corel will investigate and identify opportunities in new and fast growing markets fueled by the increasing demand for Web content and graphics, a market expected to reach $2.9 billion by 2003. Corel will use its expertise in the graphics arena to capitalize on these opportunities. The company has established a framework for the future that will unfold in three phases:

Phase 1: Over the next twelve months, Corel has the opportunity to significantly grow its creative products revenues by successfully:

  • upgrading users to CorelDRAW® 10 Graphics Suite
  • launching CorelDRAW 10 Graphics Suite for Macintosh®
  • releasing new versions of Corel® KnockOut masking software, Corel® Painter™, Bryce® and KPT®
  • implementing targeted sales and marketing programs for new vertical markets

Phase 2: Over the next one to two years, Corel will expand the scope and reach of its current suite of creative products through strategic investments in infrastructure and new growth opportunities. Corel is taking steps to transform its current graphics suite to deliver creative solutions to customers who work primarily on the Web.

Phase 3: Over the next two to three years, Corel's advanced technologies incubator, the New Ventures division, will investigate acquisition opportunities and new market segments where Corel can leverage its graphics software assets to generate new revenue streams for the company. In addition, by working on projects related to Microsoft's powerful new .NET framework, Corel will be better positioned to provide its customers with the most up-to-date technology as soon as it becomes available. Corel's alliance with Microsoft is part of the company's commitment to deliver applications, expanded services and content over the Web.

Having successfully restructured and realigned its operations, Corel is turning its attention to the future. The strategy is the culmination of a comprehensive corporate review directed by the company's senior executive team over a period of several months.


Corel Paradox® Developer Newsletter - *Update*

The Corel Paradox® Developer Newsletter is currently under development and is expected to be released this first quarter of 2001. If you have not already registered to receive this newsletter and would like to be placed on the distribution list, please email partners@corel.com. This newsletter will continue 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 #1

The following article was written by one of Corels Premium Services Technicians (Bruce Bidgood) and was pusblished in the November 2000 'Peer to Peer' Newsletter Volume XVI.

Launching an application or executable with a command line parameter
from within a PerfectScript macro..


As many are aware the PerfectScript token, AppExecute, cannot use command line parameters when launching executables. This greatly hinders the Developer when they wish to automate WordPerfect with another process. A DLL call can resolve this problem. The macro (AppComdLineExec.wcm) below shows how to make a DLL call to the Kernel32.dll and call WINExec to launch the executable with its command line parameter.

//Code begins...
/*
Macro Name: AppCmdLineExec.wcm
Purpose: To launch another application with command line parameters
This is to be used in place of the AppExecute() token that will not take any command line parameters when launching the desired executable.

Note: This example shows how to launch the utility WPLook.exe and pass a document via command line using a Dll Call to the kernel32.dll.

*/
//**************** Prototypes for WINAPI Functions ****************
DLLCall ProtoType WinExec("kernel32.dll"; "WinExec"; DWORD; {AnsiString(lpCmdLine); nCmdShow})
// Launch the executable wplook.exe with the command line parameter "c:\test.wpd".
WinExec("e:\wplook.exe c:\test.wpd";"")
//Code Ends...

This is one of many DLL Calls that can be made. Check out the WordPerfect 8/9 SDK kit under the PerfectScript Code Wizard section its well worth the look!


The FileFind Token

Many times a developer will need to go through all the documents their users have in WordPerfect to change or fix certain things. Lets say a company merges with another one and the names change from Joe's Mighty Macros to Jane and Joe's Mighty Macros. This means that they will need to change all the presently saved documents to Jane and Joes Mighty Macros. Now they have about 10000 or more documents and this would take up a fair amount of time and money to convert these files. Why not write a simple macro that will go through and change it for them? The first thought is that this would take an immense amount of time and expertise to do this.... WRONG!!! The token FileFind has the ability to not only find one file but find all files in a directory or subdirectory which meet the same criteria, lets say we need to search and find only the documents with the .wpd extension. No problem! This snippet shows the heart of the macro that will search for each file.

// Code begins...
// First Search finds first file
vFilename = FILEFIND(vFileFolder+ "*.wpd"; SearchSubDirs!; 1)

//Add code to handle first document found
// Loop through all the remaining files until none are found
WHILE(vFilename != "")
vFilename = FILEFIND(""; ; 1)
// Add what you would like to do to each found document

ENDWHILE

// Code ends...

The first line you come across sets up your search parameters, you tell it what directory to start searching in ( vFileFolder), the type of file to Search for(*.wpd) you can also use wild cards such as *.* that will find all files. You can chose between having it search through just a specific directory or go through that directory and all its subdirectories;

This will search only the specified directory:
vFilename = FILEFIND(vFileFolder+ "*.wpd"; Normal!; 1)

This will search the specified directory and subdirectories:
vFilename = FILEFIND(vFileFolder+ "*.wpd"; SearchSubDirs!; 1)

The next thing that happens is the macros enters a While() loop that will continue until the FileFind token does not return a filename. In this loop you can do what you wish with the file, you may open it and make changes such as mentioned above, from "Joes Mighty Macros" to "Jane and Joes Mighty Macros".
Note the FileFind token; vFilename = FILEFIND(""; ; 1)

As you can see the above code is pretty easy to write once you understand what it can do.


The wp9en.wpt File and Other Templates

A template is a type of document that you can base other documents on, and the new document will inherit content, styles and other features from the template. Whenever you choose a template from the New from Projects dialog, you are really choosing which template to base your new document on.

Templates for Developers
When you create a document base on a template, the styles, toolbars, keystroke assignments, menus and macros from the template are available to the new document. This means that by placing macros that you write into a template, those macros can be available to the new document based on that template. These features make templates a better way to manage macros that by simply placing every macro you create into the wp9en.wpt file on each user’s machine.

Macros from the template remain there; they are not transferred to the new document, which means that they are only available if the template is available.
Usually, this is not a problem unless you move or delete the template file, or the user emails the document to someone who does not have your template. In either such case, the document would remain intact, but no macros would be available. You should decide on a final location for you template before it is put into active use.


Third Party Token

Third Party token packs information onto a binary form on a document or template that can be extracted at any time with the macro token BinaryUnPack and put into a variable. There are many uses for this as it allows information to be stored on a document and extracted whenever needed. Lets say a user has a test score sheet that they need to update once a month. Instead of holding the information in a bif file or a text file the information can be stored using the token ThirdPartyCreate. This information can be stored on the document, extracted once a month, updated and restored onto the file. The document can be moved from machine to machine without the worry of the information traveling with it. To be able to see this binary pack when it is created turn on reveal codes and look for a code called ThirdParty. This is a very versatile token that can help develop quicker and more flexible PerfectScript macros.

//Code begins...
// Third party token code
// Create a variable with information in it
t:= "This is the information stored in the binary pack"

// Create the third party code and pack the information from the “t” variable into it.
ThirdPartyCreate (Id:151; Data:BinaryPack( t; Auto!; Auto!; WPString!; Auto!))

// Find the third party code, unpack the information and display it in a message box
MessageBox( ;" TPCode ID = 151";BinaryUnPack( ThirdPartyFindByID (Id:151; From:BegOfFile!; Direction:Forward!); Auto!; WPString!; Auto!))

// Code ends...

The Third Party Code is a very powerful tool that can change the way you create macros. It allows you to store any kind of information with the document and then be able to pass it to other people without having to also pass a text file or bif file with it.





Developer TIPS #2

Sample code showing how to use a variable in a tcursor to manipulate a fieldvalue(s) in a table(s)

Symptom: How do I use a variable when referencing a field name in a tcursor

Solution: Place the variable in brackets

Example:

method run(var eventInfo Event)

var
tableFieldName string
newValue anytype
tc tcursor
endvar

tc.open("tableName.db")
tc.edit()

tableFieldName = tc.fieldname(1) ; get the name of the first field in a table opened in the tcursor ; and store it

tc.insertAfterRecord() ; insert a new record at the end of the table
tc.(tableFieldName) = newValue ; now assign a value to the field in the table. Remember to
; place the variable in brackets.
tc.postRecord() ; post the record

endMethod


Details:
By placing the variable in brackets you are telling Paradox that tableFieldName is a variable and not an actual field in the table. If you do not place it in brackets you will get the error that the field does not exist in the table.

The method fieldName returns the name of a field in a table opened in a tcursor. Because the method only accepts an argument of smallint type, you need to know the invariant field value. This is quit simple to determine. Basically 1 would be the first field in your table, 2 the second and so on... For more information on this, reference the paradox online help file.




If you would like to see specific examples of other Perfectscript macros or OPAL coding, please email partners@corel.com with the details.



Contact
Info
Chris Cheverie -
Corel Solution Partner Program Administrator

DEVELOPER SUPPORT*
Phone: 1-877-578-0554
devsup@corel.com
*This is a fee-based service for Standard partners

North American/International Partners:
Corel Corporation
Corel Solution Partner Program
1600 Carling Ave
Ottawa, ON K1Z 8R7
CANADA
Phone: 613-274-0503
FAX: 613-724-3447
partners@corel.com

 


Copyright © 2001 Corel® Corporation. All rights reserved.
Year 2000 Information
Graphics by Corel
Products Support Shop Contact Us News Events Search Corel Home Page