Borland Delphi 2005 Architect Edition Update 3 Cyclone

A compatible version of the award winning model-driven framework Bold for Delphi is now available for download from.This edition contains a few bug fixes beyond Delphi 7 Architect Service Pack 2, but has no new features. Additional information on MDA (Model Driven Architecture) technology for Borland Delphi with either ECO (for Delphi and other languages that run on the Microsoft.NET platform) or Bold (for Delphi on the Win32 platform), can be found on the on BDN.Note: This is an unsupported, use at your own risk, download for use with Delphi 2005 Architect. Bold is certified for use with Delphi 7 Architect, and is still a supported technology for owners of Delphi 7 Architect. Bold is not certified for use with Delphi 2005. This is a build directly from Borland R&D, and is not supported by Borland's Customer Support department.The free download contains.

1. Borland Delphi 2005 Architect Edition Update 3 Cyclone Pro

Lots of never before released source code. ExamplesNot included in the download.

Online help (use ). A fancy installer. SupportTo install for Delphi 2005, run the exe, approve the license and you'll find a few files extracted into the current directory.

Borland Delphi 2005 Architect Edition Update 3 Cyclone Pro

The readme.txt contains installation instructions.Please use the newsgroup to discuss this unofficial release.Download from CodeCentral.

In this tutorial, we'll use Delphi 2005 to build, debug and deploy an ASP.NET Web forms application, demonstrating the new features and enhancements in Delphi 2005 for ASP.NET projects. There will be one example application, starting right here, that will be used to demonstrate all new features.- To build the example ASP.NET project, start Delphi 2005- Do File New and select 'ASP.NET Web Application - Delphi for.NET'- Enter 'WebAppTutorial' as name, which will produce a new ASP.NET project in the c:inetpubwwwrootWebAppTutorial directory, as specified below:New ASP.NET Web Application dialog.Note that by default Internet Information Server (IIS) is used.

However, Delphi 2005 also supports the free Cassini Web Server. Feel free to use Cassini, but refer to the online help to install and use this open source Web server.From the readme:If IIS is installed after the.NET Framework, ASP.NET must be registered with IIS by choosing Start Run and entering the following command:%comspec% /K%windir%microsoft.netframeworkv1.1.4322aspnetregiis.exe -iOtherwise, attempting to run an ASP.NET application in the IDE will result in the error Unable to start debugging on the Web server. Unable to attach to ASP.NET worker process (typically for aspnetwp.exe or w3wp.exe)- Click on OK to generate the WebAppTutorial ASP.NET Web forms project.This will create a new WebAppTutorial project with one ASP.NET Web form called WebForm1.aspx. Project Manager.

The Delphi 2005 Project Manager has a number of new ASP.NET specific features, including a connection with the Object Inspector, built-in support to create new folders or add other files, and a deployment node (which will be covered in detail at the end of this tutorial).- Check out Project Manager, which should display the project structure as shown below:Project Manager for ASP.NET ProjectIf you select a node in the Project Manager, then the Object Inspector will display information regarding the specific node. Specifically, for the code behind assembly as well as the source files, you can see the File Name and Full Path properties.- Click on the WebForm1.aspx file in the Project Manager. The Object Inspector will display the File Name (WebForm1.aspx) as well as the Full Path. The latter will be grey, indicating that you cannot edit it.- Change the value of the File Name property from WebForm1.aspx to WebForm42.aspx.This action will change the filename of the ASP.NET Web Form to WebForm42.aspx. Apart from the Object Inspector, which can be used to edit individual attributes, the Delphi 2005 HTML Tag Editor now lets you edit the entire tag (not just the inner HTML as before).- Click on the value attribute for the TextBox element in the HTML Tag Editor, and change the value from 'Hello' to 'Hello Delphi 2005' (see screenshot below).Delphi 2005 HTML Tag EditorThe HTML tag editor can be used to edit most HTML tags, with the exception of body, tbody, tr, caption, and tfoot. Structure View. The Delphi 2005 Structure View (in the upper-left corner of the IDE) shows the hierarchy of the HTML in the.aspx page.

You can double-click on nodes in the Structure View to be taken to the corresponding HTML code snippet in the Code Editor.- Click on the WebForm42.aspx tab at the bottom of the code editor so the HTML view is shown.For the current example, the Structure View is as follows:HTML Structure View- Double-click on elements in the HTML Structure View, and note that you'll be taken to the start of the corresponding HTML tag in the HTML Code Editor.Apart from simple HTML elements, there are more powerful controls, including Borland's own DB Web controls. DB Web Controls.

Delphi 2005 introduces four new DB Web controls. Fortunately, altering tables directly from the Data Explorer is also a new feature added to Delphi 2005.- Select the EMPLOYEE table, right-click on it and select 'Alter Table'.This gives you a new page in the designer where you can view the EMPLOYEE table record structure, and can make changes to it. Initially, the design is as follows:Delphi 2005 Table Design for EMPLOYEE- Go to the last line, and enter the name AUDIO. The Data type will get the value CHAR by default, but change this to VARCHAR, and set the Precision (size) to 128.- Add another field called VIDEO with a Data type of VARCHAR, and Precision (size) of 128 again.Delphi 2005 modified Table Design for EMPLOYEE- Right-click on the Table Design view, and select 'Show DDL', which will be as follows: ALTER TABLE EMPLOYEE ADD AUDIO VARCHAR(128), ADD VIDEO VARCHAR(128)- Right click on the Table Design view, and select 'Execute DDL'.The table EMPLOYEE has now been extended with two fields: AUDIO and VIDEO. We will fill them and use them in a minute.First, we need to make sure that the EMPLOYEE table can be used by the ASP.NET project.- Select the EMPLOYEE table in the Data Explorer, and drag it onto the ASP.NET Web Form.As a result, you will now see a BdpConnection and a BdpDataAdapter component in the non-visual component area of the HTML designer. The BdpConnection is responsible for the connection to the InterBase Employee.gdb database, while the BdpDataAdapter connects to the EMPLOYEE table in this database.

DataSync and DataHub with ASP.NET. With Delphi 8 for.NET, we could start the Data Adapter Configuration dialog, edit the SELECT, INSERT, UPDATE, and DELETE commands, get a preview of the data, and specify if the result of the SELECT statement should be placed in a new or existing DataSet (or none at all). However, new in Delphi 2005 is now also the ability to use a DataSync and DataHub (see the Delphi 2005 RAD for ADO.NET tutorial for more information), which can also be used in combination with ASP.NET.- Place a DataSync component (from the Borland Data Provider category of the Tool Palette) on the WinForm. The four new DB Web controls are DbWebAggregateControl, DbWebSound, DbWebVideo and DbWebNavigationExtender. Before we can use any of them, we need to place a DbWebDataSource as 'connector' between the datatable and the other DB Web controls.- Place a DbWebDataSource component from the DB Web category on the Web Form. Using Delphi 8 for.NET, you can now place a DbWebNavigator control to navigate through the records and send changes back to the database (using the ApplyToServer button).

With Delphi 2005, it's also possible to use regular ASP.NET Buttons and extend them with navigational capabilities (by assigning navigation actions to them). This is facilitated by the DbWebNavigationExtender component.- Place a DbWebNavigationExtender component from the DB Web category on the Web Form.

The DbWebAggregateControl can be used to display aggregate values of columns from a dataset. Available aggregate operations include Avg, Count, Min, Max, and Sum.- Place a DbWebAggregateControl on the ASP.NET Web Form.- Connect the DBDataSource property of the DbWebAggregateControl component to the DbWebDataSource.- Connect the TableName property of the DbWebAggregateControl component to dpEmployeesTable.The AggregateType has been set to Avg by default. This means that the ColumnName property will by default only show columns that are 'averageable' (i.e. Numeric types). For the EMPLOYEE table, those columns are EMPNO, JOBGRADE, and SALARY.- Select SALARY as field for the ColumnName property of the DbWebAggregateControl component.You will now immediately see a value of 278095 in the editbox for the DbWebAggregateControl component.Note that the ColumnName property is cleared when you select a different value for the AggregateType property of the DbWebAggregateControl component. You can set AggregateType to Avg, Count, Min, Max, or Sum. Avg and Sum only work on numerical fields, Min and Max also work on String fields, and Count works on all fields (and simply returns the number of records).

DbWebSound and DbWebVideo. The DbWebSound and DbWebVideo components can be used to add audio and video to your ASP.NET applications, where the audio and video files are obtained through a dataset. The DbWebSound component supports.wav,.mp3,.wma, and other sound formats. Like the DbWebSound component, the DbWebVideo component also uses the media player (if installed on your system), and supports the.mpg and.avi formats.

They both connect through a DbWebDataSource to fields from a dataset. Delphi 2005 offers a completely new approach to debugging ASP.Net applications. This is done by the Borland.dbkasp.dll - a HttpModule, providing improved debugging of ASP.NET applications.During installation of Delphi 2005, the Delphi 2005 installation program requests permission to update your machine.config file with Borland debugger information.Delphi 2005 Installation QuestionIf you answered No to this question, then there are two ways to still enable the Borland.dbkasp.dll.

First of all, you can manually edit the web.config file of each ASP.NET project. As we saw at the start of the ASP.NET Web Application, Delphi 2005 now shows a special Deployment node in the Project Manager for ASP.NET projects. Here we can specify deployment options.- Right-click on the Deployment node in the Project Manager and select 'New ASP.NET Deployment' to get the Deployment View.ASP.NET Deployment ViewIf you have used the Borland Data Provider, then the list of files to deploy is not complete. To get a complete list, open the References node of your ASP.NET Web Application. This node lists all assemblies that are required for your project, which include Borland.Data.Common.dll, Borland.Data.DataSync.dll, Borland.Data.Provider.dll, and Borland.Data.Web.dll.

Only the latter is already included in the list of assemblies to deploy.Project Manager - References- Select the Borland.Data.Common.dll assembly, right-click on it and select 'Copy Local'. This will make sure that it's copied to the project directory (from where it can be deployed) after the next compilation.- Select the Borland.Data.DataSync.dll assembly. Apart from right-clicking on it, you can also directly set the Copy Local property in the Object Inspector to True.- Do the same thing with the Borland.Data.Provider.dll- Now, recompile the WebAppTutorial project, which will copy the missing Borland assemblies to your project's Bin directory.This will immediately update the Deployment View with the new assemblies. However, before you deploy, there's one more assembly missing: the one related to the actual database that we're using.

In this case Borland InterBase. And the missing assembly is specified in the ConnectionString of the BdpConnection component.

It's Borland.Data.InterBase.dll. In this tutorial, you have seen how to use Delphi 2005 to build, debug and deploy an ASP.NET Web forms application. Among the new features, you have experienced the new HTML designer, HTML elements, four new DB Web controls (DbWebNavigationExtender, DbWebAggregateControl, DbWebSound and DbWebVideo), ASP.NET Debugging and finally Deployment. As related topic, you've seen how to alter the structure of database tables using the Data Explorer, and how to connect the DataSync and DataHub to the DbWebDataSource component in ASP.NET Web Applications.