PowerBuilder 12 CTP Hands On Guided Tours

PowerBuilder 12 CTP Hands On Events in June

Sybase in conjunction with ISUG will be holding a series of hands on Guided Tours of the new PowerBuilder .NET Community Technology Preview release during the month of June. 

For more information and to register please visit:

www.isug.com/common/UpcomingEvents.html

Events will be held in:

Boston,

New York,

Minneapolis,

Houston,

Denver

The public CTP is scheduled to begin in early June. Download information will be made available here as soon as the program begins.

PowerBuilder Accelerated Development Tour

PowerBuilder Accelerated Development Tour

We’re packing up the PowerBuilder team and hitting the road to bring the latest in PowerBuilder news, code, and goodies to you.

PowerBuilder 11.5 just came out and we want to share how the new features and capabilities will help accelerate your development, bring aesthetic enhancements to your PowerBuilder applications, and simplify .NET development. We are also working fast and furiously on delivering PowerBuilder 12, which blend the Visual Studio Isolated Shell with the prowess of DataWindow and PowerBuilder technology.

Fresh from the labs, we will give you a sneak peek of arguably the biggest news for PowerBuilder since its inception: PowerBuilder 12.

PowerBuilder evangelists and team members are excited to share the latest in PowerBuilder innovations and are looking forward to meeting you at an Accelerated Development event.

Detailed Overview of Topics
PowerBuilder 11.5 The release of PowerBuilder 11.5 brings a multitude of new capabilities and features that will help accelerate your development, bring aesthetic enhancements to your PowerBuilder applications, and simplify .NET development.

Topics covered will include DataWindow® innovations, Native ASE 15, SQL Server® 2008, and Oracle 11g drivers, .NET enhancements: Strong Named Assemblies and IIS7 Support, Security features such as.NET CAS and FDCC, and new premiums included with PB Enterprise: PocketBuilder™ and PowerBuilder Application Server Plug-in.

Sneak Peek at PowerBuilder 12We're going to cover the new exciting and revolutionary features being built into PowerBuilder 12 including:

Visual Studio Isolated Shell
Front to back WPF
Fully Managed Code @ Runtime
WPF DataWindow
WCF Support
Latest in Web Services technologies
Oracle, Sybase, Informix, and SQL Server Support

For more information and to register click here.

PowerBuilder 11.5 and strong-named .NET Assemblies

Another new feature in PowerBuilder 11.5 is the ability to generate strong-named assemblies for any of the four .NET targets (Web Forms, Windows Forms, .NET Web Services or .NET Assemblies). What does this mean?

Well the Help file says this:

A strong name consists of an assembly's identity—its simple text name, version number, and culture information (when provided)—plus a public key and digital signature. It is generated from an assembly file using the corresponding private key. The assembly file contains the assembly manifest that includes the names and hashes of all the files that make up the assembly.

So, what are the benefits of creating strong name assemblies?

First you can be assured that a name is globally unique. According to the MSDN website, strong names satisfy the following requirements:

• 
  Strong names guarantee name uniqueness by relying on unique key pairs. No one can generate the same assembly name that you can, because an assembly generated with one private key has a different name than an assembly generated with another private key.
• 
  Strong names protect the version lineage of an assembly. A strong name can ensure that no one can produce a subsequent version of your assembly. Users can be sure that a version of the assembly they are loading comes from the same publisher that created the version the application was built with.
• 
  Strong names provide a strong integrity check. Passing the .NET Framework security checks guarantees that the contents of the assembly have not been changed since it was built.

Note that creating strong-named assemblies does not imply the same level of trust that is provided by a digital signature and supporting certificate.

More on Graphs in PowerBuilder 11.5

Last week I posted a screen shot of the new 3D Rendering capabilities being added to some of the 3D graphs in PowerBuilder 11.5. It was met with mixed reviews on the PowerBuilder Futures newsgroup (forums.sybase.com) so I went back to the drawing board to see what I could come up with. Apparently there are quite a few configuration settings one can set programmatically to render better looking graphs. For example, the primary color scheme default can be changed by making a couple of function calls for each data point or series. Here is a screen shot of an example application I am putting together to be released when 11.5 ships:

This feature is still in development so the legend doesn't take advantage of the translucency property yet.

Now lets look at a 3D chart that contains a series. First here is a screen shot of the original 3D graph style available in PowerBuilder 11.2 and earlier (and still available in 11.5 if you like the retro look):

Now lets see that same chart with the new 3D (DirectX) rendering turned on and translucency set on some of the series:

Looks a lot better. The new 3D rendering capability will be available for the following 3D graph styles: Area, Column, Pie, Bar, and Line. This should meet the majority of users' 3D graph needs. If you need something more powerful or want a wider selection of charting options, take a look at the FusionCharts demo available on CodeXchange at:

https://powerbuilder.codexchange.sybase.com/files/documents/67/2838/FusionChartsfree.zip

DataWindow Tooltips in 11.5

Today's sneak preview is on the DataWindow Tooltip enhancement in 11.5. This screenshot shows a tooltip on the first_name column:




This shows a tooltip with the title property populated as well as an icon property selected. It also shows the bubble format. Below you can see the list of properties that will be available for tooltips:



It is important to point out that you can place a tooltip on any control on the DataWindow. Drawing objects, buttons, nested reports, computed fields, labels, they all support the tooltip property!

New Graph Styles in 11.5

G'Day from Down Under. I've been in Australia since April 27th and while it is great to be "home" (I lived in Sydney from 1995-2000) I've been too busy to keep my blog up to date. I've got a few spare minutes today so I want to share with you another new feature being added to PowerBuilder 11.5.

There will be some new 3D graph styles based on DirectX technology. These new graphs will be available for Win32 and .NET Windows Forms applications.



Here's a screen shot of the new 3D Pie Chart. It isn't feature complete yet but it should give you an idea of what to expect.





You'll notice that there are some new properties in the DataWindow painter and some new functions are being added to allow you to get and set data and series labeling on various 3D graphs.

PowerBuilder 11.5

PowerBuilder 11.5 will have a number of DataWindow enhancements. Over the next several days I will be posting some screen shots along with descriptions of many of these new features.

I should point out that these enhancements are for Win32 (PowerBuilder native) and .NET Windows Forms applications only. They won't be available in .NET Web Forms applications (sorry!). Eventually these enhancements will be rolled into DataWindow .NET 3.0.

The first enhancement I want to demonstrate is the background image for DataWindows. This new property lets you select a .bmp, .jpg, .gif, .png, .rle, or .wmf file as a background for your DataWindow. I'm using a .jpg file of the Sybase headquarters building in Dublin, California in this example. There are several tile mode options available from "original size" to "fit to width" to "flip xy". There are also several clip properties and a transparency property. Of course all of the properties can be set in the DataWindow painter or programmatically in your code.

Speaking transparency. Notice the state_name column? There is now a text transparency property for columns and labels (computed fields too). In this example I have set the value to 50%. The state_id column's text transparency property value is set to zero (completely opaque).

The background color property for both columns has been set to transparent so you can see the image come through the columns. You can also set a color and then set the transparency property anywhere from 0% to 100% (which gives you the same effect as setting the background color to transparent):

So, lets use this DataWindow in a Drop Down DataWindow column.

Pretty cool! It might be totally impractical and make it more difficult for your users to see the data in the Drop Down DataWindow but it sure looks nice!

In my next entry I will talk about the new gradient properties being added to the DataWindow. The screen shot above gives you a hint as to what you can do with these properties but it barely scratches the surface.