|
"Boundless power to create. Anytime. Anywhere. Share Corel's vision." COREL® Solution Developers Web site * * * * * * * * * * * * * Software Developer Kits (SDK) * * * * * * * * * * * * * COREL® Solution Developers Software Order Form CorelDRAW® 10 for Windows, Corel WordPerfect® Office 2002, Bryce®, Corel® KnockOut, KPT® & procreate™ Painter™ FEATURE WEB SITE OF THE MONTH Trade Shows - August / September 2001 Corel Corporation will be participating in the following Trade Shows for the month of August and September 2001. For more information relating to any of the shows listed below, please visit the Events section on Corel's Web Site at this URL: http://www.corel.com/servlet/Satellite?pagename=Corel/Company/Standard&id=1042152901862
Corel To Acquire SoftQuad Companies Sign Definitive Agreement: Acquisition Advances Next Phase of Corel's Growth Strategy Ottawa & Toronto, Canada – Aug 7, 2001 Corel Corporation (NASDAQ: CORL, TSE: COR) and SoftQuad Software, Ltd. (OTC BB: SXML) today announced that they have signed a definitive agreement whereby Corel will acquire SoftQuad in a stock-for-stock transaction to be accounted for as a purchase transaction. This acquisition advances key aspects of the company's growth strategy and builds upon its recently-announced plans to acquire Micrografx, Inc. By acquiring SoftQuad and its ground-breaking XML-enabling technologies, Corel is adding a key ingredient required to implement horizon two of its growth strategy. In addition, this acquisition will enable Corel to enrich the existing XML capabilities within its WordPerfect® product line. "Upon completion of this acquisition, we believe we will have the core technologies needed to realize our vision of providing customers with an expansive cross-media publishing solution," said Derek Burney, president and CEO of Corel Corporation. "We intend to give customers the tools they need to create, manage and simultaneously deploy customized content across multiple delivery channels, including the Web. This streamlined production process will afford them maximum flexibility while saving them valuable time and resources. Our solution will capitalize on SoftQuad's expertise in the XML arena and its strong partnerships with leading content management system vendors, Micrografx's innovative emerging technologies and Corel's internationally recognized strengths in graphics and publishing. This acquisition will also benefit our WordPerfect customers. By integrating SoftQuad's market-leading XML technologies into our award-winning word-processing application, we will further enhance the XML functionality that many of our customers in the government and legal community currently enjoy. "We are very excited about the opportunities that lie ahead for Corel. With a clear focus on our immediate goals and intelligent investments to supplement our long-term growth, we believe we now have the tools necessary to position Corel as the new industry standard in emerging segments where there are currently no established leaders." "We are pleased to be joining forces with a company that shares our vision for pervasive XML content," said Roberto Drassinower, CEO of SoftQuad. "With Corel's development expertise, international brand recognition and strong balance sheet, we will be able to accelerate the delivery of XML-based content creation, transformation and exchange solutions to our shared customer base." Corel and SoftQuad share synergies which, when the two operations are combined, are expected to generate new revenue opportunities and cost efficiencies from which its collective global customer base will benefit. Based on preliminary estimates, after the realization of anticipated synergies and excluding any one-time integration costs, this acquisition is expected to be accretive to cash flow and cash earnings per share within approximately twelve months from the date of closing. The company does not expect any significant negative impact on cash flow as a result of this acquisition. Over the next several weeks, Corel and SoftQuad will work together on a comprehensive plan outlining how best to integrate the two companies. Following the closing of the deal, expected in the fourth quarter of Corel's fiscal 2001, the companies will announce further details related to the integration plan. Exchange terms: The transaction will be a stock-for-stock transaction. Each common share, or equivalent, of SoftQuad will be exchanged for .4152 of a Corel common share on closing, being the ratio of $1.50 to $3.6129. The $1.50 value for each SoftQuad share equals an approximate 34 per cent premium over the closing price of SoftQuad on August 6, 2001. The $3.6129 value for Corel common shares represents the prior 10 day volume weighted average share price of Corel common stock. At current values, Corel would issue approximately 9.85 million shares if all in-the-money options and warrants of SoftQuad are exercised prior to closing. All figures are expressed in US currency. The above noted exchange ratio will be fixed for movement in Corel's common share price between $2.71 per share and $4.52 per share. For prices outside this range, Corel would issue more shares at a lower price and fewer shares at a higher price. The maximum number of shares Corel could issue is approximately 11.2 million. The transaction is subject to regulatory approval and approval by SoftQuad's shareholders. Corel WordPerfect® Office 2002 - SDK Now Available What's included with the WordPerfect Office 2002 SDK:
The SDK architecture has been rewritten to provide a more robust development environment. As such, most tools, wizards, documentation and samples have been compiled into one executable SDKTools.exe Further to the changes in architecture, the SDK help files have been revised and reformatted using WinHelp. The help files can be accessed from the Help menu of the WordPerfect Office SDK application window, or from the Windows Start Menu by choosing: Programs, WordPerfect Office 2002, Help Files, SDK Help The File Format documentation is still available in HTML format and can be accessed from the SDK Help files. A number of tools have been re-purposed and renamed to accommodate the design changes. Following is summary of changes made to various SDK tools: Tool and Utility Name Changes: NEW to this version of the SDK are two variants of the OLE Command Inserter:
-Corel Presentations does not create toolbar buttons for Third Party Handler dlls developed using the WordPerfect Office SDK. -Some screen shots in the Help files are based on beta versions of the WordPerfect Office SDK and are not consistent with UI name changes. Contact Info: Please direct any questions, comments or suggestions you have concerning the SDK or SDK Documentation to: sdkprodman@corel.com Note: A limited quantity of Corel® WordPerfect Office 2002 SDK CD's are now available to all Platinum Developers. If you are interested in obtaining this SDK CD, please send your request by e-mail to partners@corel.com. Paradox®10 - Runtime now available for download Paradox® 10 Runtime is now available for download from Corel's Website at: http://www.corel.com/runtime10/ Paradox® 10 Runtime CD's will be available to all requesting Platinum Developers at "no charge". Please send your request via e-mail to partners@corel.com Developer TIPS Using ColdFusion with Paradox® Tables The following article was written by Roy Frieband for ParadoxCommunity.com © 2001 Roy Frieband This example has been tested using Windows® 98, Cold Fusion Server 4.0, MS PWS (Personal Web Server), Paradox 9, INTERSOLV® Paradox ODBC driver (ships with Paradox 9). Preface ColdFusion offers a way to continue to use your Paradox tables if you need to web enable your database and using the Corel® Web Server OCX is not an option. In addition the company offers a "lite" version called ColdFusion Express that may be downloaded for free. While it only contains a subset of the functionality of the full product, it is still very functional. Combine this with hundreds of ISP's hosting ColdFusion at a reasonable price and you have a viable option for getting your Paradox database on the web at a reasonable cost. There are 3 parts to using ColdFusion with Paradox tables: 1. Setting Up Paradox as a ColdFusion datasource. From the Windows control panel double click the icon that says ODBC Data Sources (32bit). Click the Drivers tab of the dialogue box (4th tab). In the list look for a driver named INTERSOLV 3.11 32-BIT ParadoxFile (*.db). If you don't see this driver on the list then it is not installed and you need to install it from the Paradox 9 CD. If you see the driver then you are ready to proceed. Click on the second tab of the dialogue box, the one that says System DSN. Click the Add... button. From the list that pops up choose the Paradox driver and click the Finish button. You are then presented with the ODBC Paradox Driver Setup Form. On the General tab the first field is for Data Source Name (basically the same as an alias name in Paradox). The name you type in here is the same name you will use to reference your tables in a ColdFusion query. The second field is for description. This can be anything you want. The third field is for Database Directory and this is where you set up the path your datasource (i.e. alias) will point to. Note you can use a hard coded path or a Paradox alias. So :MYALIAS: will work fine here. Then go to the Advanced tab. The first field is the location of the net file if you are accessing shared network data. The third field is Create Type and this is where you can tell it to use version 7 tables, as opposed to the MS drivers which only go up to version 5. For the rest of the fields, you can read the help files to find out more about what they do. Then click the OK button and you should see the name of your datasource appear in the ODBC Data Sources form. Close the form, this part is done. 2. Verifying the connection Prior to this step make sure your web server and ColdFusion server are running. Open the ColdFusion Administrator (found in the ColdFusion 4 Server folder). In the frame on the left click the link that says ODBC. You should see the datasource name you set up in the last step in the Data Sources available list. Next to it is a hyperlink that says Verify. Click on this and it should tell you the connection was verified. You are now ready to access your data. Close the Administrator. 3. Using ColdFusion to access the data Create a test table in Paradox with 3 fields: ID, FirstName, LastName. Make the ID field a LongInt type. Be sure this table is in the directory or alias pointed to by the datasource you previously set up. Name the table cftest.db and add 3 or 4 records to the table. Create a ColdFusion page in any text editor. Note that the page must be saved below the root directory of your server. So for MS PWS for example you would save the page somewhere below C:\Inetpub\wwwroot. If you are using your local computer to test the app then the page must be saved in the C:\Inetpub\wwwroot\Cfdocs directory. The page must be saved with a cfm extension. For this example lets name it cftest.cfm. To query out the data from your Paradox tables: <CFQUERY NAME="MyTest" DATASOURCE="YourDatasourceName"> SELECT ID, FirstName, LastName FROM cftest.db </CFQUERY>To output your queried data to the browser: <CFOUTPUT QUERY="MyTest"> #ID# #FirstName# #LastName#<BR> </CFOUTPUT>Putting it all together your cftest.cfm page would look like this: <HTML> <HEAD> <TITLE>Paradox CF Test</TITLE> </HEAD> <BODY> <CENTER> <B>First Cold Fusion Paradox Page</B><BR> </CENTER> <CFQUERY NAME="MyTest" DATASOURCE="YourDatasourceName"> SELECT ID, FirstName, LastName FROM cftest.db </CFQUERY> <CFOUTPUT QUERY="MyTest"> #ID# #FirstName# #LastName#<BR> </CFOUTPUT> </BODY> </HTML>Run this page from your browser and you should be seeing your Paradox data live on the web. Note that you cannot run a ColdFusion page from your hard drive (i.e. by double clicking it in Explorer). It must be run from the web server. So to run this example you would type the url: http://127.0.0.1/CFDOCS/cftest.cfm into your browser. To Insert Data From ColdFusion into your Paradox tables: You would probably be inserting data using form variables but for the purpose of this example I will insert static values. <CFQUERY NAME="AddRec" DATASOURCE="YourDatasourceName"> INSERT INTO cftest.db (ID, FirstName, LastName) VALUES (3000, "Roy", "Frieband") </CFQUERY>Add the above code with the starting and ending HTML tags and save with a cfm extension. When the page is run it will add a record with the above values into the cftest.db table you previously created. Summary The relative ease of learning the basics of ColdFusion along with the low cost of implementation would seem to create a variety of opportunities for Paradox users to provide access to their databases via the internet. There might be a place for this kind of implementation alongside the Paradox OCX in certain situations, in situations where the OCX could not be used, and to be able to exchange or update data seamlessly between your main Paradox application and your tables that reside on the web server. It should be noted that not all ISPs that host ColdFusion allow ODBC access to Paradox tables, although there are many that do. If you decide to look for a host make sure you will be able to use your Paradox tables. If you would like to see specific examples of CorelDRAW® VBA Macros, Perfectscript Macros or OPAL coding, please e-mail partners@corel.com with the details. |
||||||||||||||||||||||||||||||||
| Contact Info |
Chris Cheverie Corel Solution Developers Program Administrator DEVELOPER SUPPORT* |
North American/International Developers: Corel Corporation Corel Solution Developers Program 1600 Carling Ave Ottawa, ON K1Z 8R7 CANADA Phone: 613-274-0503 FAX: 613-274-6373 partners@corel.com |
| Copyright © 2001 Corel® Corporation. All rights reserved. Year 2000 Information Last updated: Wed Dec 31 1969 |
 |