TeamSybase Blogs

Brad Wery

PowerMenu: Rounding Home Base Sep 23 The new PowerMenu control is nearly done. There are two features that need to be implemented. 1) a pin button so you can dock and undock the ribbon. 2) a scroll bar so you can scroll through the ribbon if the width is too small to display all the contents. Everything has been ported to all supported versions of PowerBuilder.  The new ribbon brings a nice look to PB9 applications. In addition to the new PowerMenu control, the following enhancements have been implemented:  ...

PowerMenu almost done Sep 14 It didn't take long. The new PowerBuilder "ribbon" control is almost complete (version 1 at least). There is one major obstacle that needs to be dealt with and a couple minor items that need to be coded: Major: Figuring out what to do when the ribbon is too large for the screen. Traditionally, ribbon controls will shrink to fit, adjusting the layout as the window sizes. Version 1 may not have this capability. I'm thinking of other ways to address this. Minor: ...

PowerBuilder Ribbon Control Sep 13 PowerToTheBuilder is working hard to develop a new Ribbon\Menu control for PowerBuilder applications. This new object is going to be PowerBuilders take on the Office Ribbon. Instead of calling it a Ribbon, it will most likely be refered to as a enhanced menu (PowerMenu). The idea is to make the entire control render based on the items that are on the windows menu. See image below.        There will be some setup required in order to get everything look...

PB UI Controls Version 2.6.3 Now Available Jan 19 Version 2.6.3 of the UI controls are now available for download. This release focuses on performance improvements and bug fixes. You should now experience no flickering in the tab control and powerdock control. The buttonlistbar was enhanced a bit to make it perform a little quicker whan no image is specified for a button. The toolbar control had a bug that caused it to crash when resizing if there are items on both the left and right side. Please let us know if you see any other iss...

Free UI Control Offer Jan 4 Until Jan 30, 2010, Werysoft is offering the PB UI controls free to anyone who purchases a copy of QweryBuilder. QweryBuilder is a database development and SQL query tool. Its purpose is to make accessing information from a database simple, quick, accurate and efficient. QweryBuilder implements innovative ideas to make this possible. An end user can extract and update data without writing a line of SQL. Database developers can create ad-hoc queries, procedures, tables, views and trig...

Breck Carter

RUN anywhere May 18 RUN anywhere is one of the slogans in this new TV commercial: Yes, an actual SAP TV commercial, actually running in prime time on the Fox News Channel. ...and we all know what RUN anywhere means, don't we? nudge, nudge, wink, wink [ahem] SQL Anywhere [cough]

"Whaddaya mean, backups have failed for the last month?" May 16 Oren Jacob and Galyn Susman tell the story of how all the Toy Story 2 files vanished: The moral of the story?Test your backups, of course.

Author, Author! May 14 The "author" column has been added to list of SQL Anywhere technical documents found at Tales From The Doc Face. ...and now the bad news It will take some time before the author column is completely filled in... right now, the authors are only shown for the freshly-added Techwave 2006 presentations. Which brings us to the question, "Why weren't the authors included from the beginning?" Answer: Sigh... just plain stupid, I guess... too much focus on the hard stuff (figuring out the publ...

From The Golden Age of Techwave May 11 Do you remember 2007? That's when outsiders were still invited to make presentations at Techwave. And that's when 24 (twenty four!) separate technical presentations were made on the subject of SQL Anywhere ...actually, I think there were 25 but I can't find the second day of Glenn Paulley's SQL Anywhere Internals class. Anyway, the 24 Techwave 2007 presentations that do exist on the web have been added to the list at Tales From The Doc Face. Did you know?Did you know that Tales From ...

Yet More New Old Docs: Techwave 2008 May 9 Eighteen SQL Anywhere presentations from Techwave 2008 have been added to the list at Tales From The Doc Face. ...and this time, they're all available online: none are missing, and none of them had to be copied so they can be indexed by Google.

Bruce Armstrong

Haiti 2012 Apr 28 One of the things is was great to see was the amount of progress that has been accomplished since I was in Haiti last June. Last year at Repatriot, the wall around the compound wasn’t complete in the back, and the area between the school and the right wall was often standing water.  When we [...]

Sybase TechWave content split between SAP TechEd and another event yet to be announced. Apr 21 The Database and Mobility portions of TechWave are being incorporated into SAP TechEd which will be held October 15-19 at the Venetian Hotel in Las Vegas, NV. The Application Development Tools portions of TechWave will be held in a separate event at the same time and general location.  To ensure you are informed of updates specific for the Application [...]

Upcoming PowerBuilder.TV Episodes Apr 12 How to make your application multilingual with Enable 5.0 – Gian Luca De Bonis Thursday April 26th at 11:00 AM EST (New York) – 17h00 CET (Paris) Appeon Mobile Sneak Peek – Christophe Dufourmantelle Tuesday May 15th at 11:00 AM EST (New York) – 17h00 CET (Paris) How to develop Multithreaded applications with PowerBuilder – [...]

HP QuickTest Pro now supports PowerBuilder 12.5 Mar 25 At least according to a couple third party blogs.  Patch number QTPPB_00034.  One site has the patch available for download. Filed under: PBDJ, PowerBuilder, twitterfeed

March San Diego Flex User Group Meeting Mar 8 April meeting will be a dry run through of a Adobe Max presentation showing an app developed and deployed on 5 or 6 different mobile devices This meeting was a presentation by Greg Wilson of Adobe and Jeff Tapper of Spoon.  It was the type of information that should have been originally presented when Flex [...]

Dave Fish

PowerBuilder 12 CTP Hands On Guided Tours May 28 PowerBuilder 12 CTP Hands On Events in JuneSybase 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.htmlEvents will be held in:Boston,New York,Minneapolis,Houston,DenverThe public CTP is scheduled to begin in early June. Download information will be made available here as soon as the program begin...

PowerBuilder Accelerated Development Tour Jan 21 PowerBuilder Accelerated Development TourWe’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 Isolat...

PowerBuilder 11.5 and strong-named .NET Assemblies May 13 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...

More on Graphs in PowerBuilder 11.5 May 10 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 cal...

DataWindow Tooltips in 11.5 May 6 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 ...

Jason Froebe

Perl Script to Convert an Audiobook (m4b) to mp3 files splitting on the chapters Jan 7 I have an Nissan Altima with a BOSE radio that allows me to hook up an USB thumbdrive containing mp3 files. The problem is most of my audiobooks are in m4b format. Previously I’ve used tools like mp3splt and tried to split on ‘silence’ or timed increments (say 15 min) but I was getting mp3 [...]

Audiobook chapter support for FFprobe (Perl) module Jan 6 I have multiple audiobook files (m4b) that ffprobe is able to retrieve the chapters from just fine… except the chapter information is printed to stderr and never in the formatted (STDOUT) output. The Perl module FFprobe doesn’t handle the chapters so I submitted feature request #73803 Feature request is to format the chapter output. jason@jason-Inspiron-1545 [...]

Cat a number of files and want to know which file it is working on? Nov 28 In the following example, I have 21 files that came from a raw partition that I split at 10GB intervals. I am piping that to parallel bzip2 (pbzip2) and writing it to a raw partition (logical volume).  cat /mnt/DBADEV1/DBADEV1.disk.bz2.00 /mnt/DBADEV1/DBADEV1.disk.bz2.01 /mnt/DBADEV1/DBADEV1.disk.bz2.02 /mnt/DBADEV1/DBADEV1.disk.bz2.03 /mnt/DBADEV1/DBADEV1.disk.bz2.04 /mnt/DBADEV1/DBADEV1.disk.bz2.05 /mnt/DBADEV1/DBADEV1.disk.bz2.06 /mnt/DBADEV1/DBADEV1.disk.bz2.07 /mnt/DBADEV1/DBADEV1.disk...

Wanted: Technical Support Analyst – WebSphere Linux SQL (2 positions available) Nov 28 Position Responsibilities POSITION OVERVIEW The Technical Support Analyst for SunGard InvestOne’s global clients will be responsible for hands-on technical troubleshooting and support across a variety of platforms for a broad customer client base. This position is part of a global team with local responsibilities from 8am to 8pm. The Analyst will be responsible for Tier [...]

Wanted: Microsoft SQL Server DBA (Chicago, IL) Nov 28 Position Responsibilities Provides DBA services for Production, test, and development databases Administers and maintains the production, test, and development databases. Performs SQL code releases Reviews application designs for compliance with production acceptance requirements. Complies with IT policies and procedures, especially those for quality and productivity standards Complies with Information Security policies and procedures. Verifies deliverables [...]

Jay Stevens

25 Ways to Customize Sybase PowerDesigner – Miscellaneous Mar 13 Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} This is a list of PowerDesigner customizations that apply to all mod...

30 Ways to Customize Sybase PowerDesigner – Data Modeling Feb 24 30 Ways to Customize Sybase PowerDesigner – Data Modeling Here is a beginning list of ways to customize Conceptual, Logical or Physical data model behavior within PowerDesigner.  Please comment on your thoughts, additional ideas or corrections. 1.      Alter datatype mapping when generating from CDM to LDM or PDM. 2.      Customize generated DDL to include standard SQL header / comment block. 3.      Customize generated triggers. 4.      Customize default stored procedure templates. 5....

Ways to customize Sybase PowerDesigner – Introduction Dec 13 Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} As a PowerDesigner consultant, I have many opportunities t...

PowerDesigner 15 First Impressions Sep 18 The PowerDesigner 15 beta just ended last week.  This means we are getting close to the release of PD 15. I still have good friends in the PowerDesigner marketing, sales, engineering and support organizations so I have an unfair advantage when it comes to finding out what is coming next in the PowerDesigner product.  Most of you, I realize, do not have these kinds of contacts.  Even with these contacts I have found that the best way to get a head-start on new PowerDesigner versions is to get on ...

Techwave 2008 Impressions Aug 21 I was very pleased with Techwave 2008. I had an unfair advantage since due to my TeamSybase status it did not cost me anything to attend. My objectives for the week were, in no particular order:Reconnect with PowerDesigner Product Management, Engineering and SupportEducation, see if I could learn any new tricksNetwork, get acquainted with potential customers and or Sybase people that might need my services for their customersReceptions

Paul Horan

Using the Sybase Hosted Relay server with SUP 2.1 Hybrid Web Container Jan 10 Greetings, and a Happy 2012 to you! You may have noticed that I’ve been rather absent from the blogosphere lately.   I’ve been focusing on my transition to the Sybase/SAP Mobility team.  That doesn’t mean I’ve abandoned my passion for PowerBuilder – that’s the tool that built my career, and it will always be a [...]

Refactoring PowerBuilder code with the PowerDesigner plug-in Oct 27 Here’s a trivia question for you… How long ago did Sybase release the PowerDesigner Plug-in for PowerBuilder? Your answer would probably be, “What the heck is the PowerDesigner Plug-in for PowerBuilder???”  It is, arguably, the least-discussed feature of both PB and PD, and yet, with the release of PB12.NET, it could become the most important tool in [...]

PowerBuilderTV Oct 25 Join Dave Fish on PowerBuilderTV as he covers the enhancements included in the recently-released PowerBuilder 12.1 maintenance patch. Click this link to register. I WANT MY PBTV! Enjoy! -Paul-

Migrating PowerBuilder SOAP clients to WCF May 26 PowerBuilder 12 has been released, and if you’ve been paying attention, you know that it now comes in two flavors!  There’s PB12 “Classic” for traditional Win32, WinForm, WebForm, .NET Assembly, and J2E component targets, and PB12 .NET for WPF (Windows Presentation Foundation) and WCF (Windows Communication Foundation) proxy targets.    One of the overriding goals [...]

PowerBuilder 12 is here! May 1 Actually, it’s here!  Generally available for licensed users at the Sybase Product Download Center! The long-anticipated update to PowerBuilder is the 16th major release in 19 years, and that doesn’t count the dozens of maintenance releases and HUNDREDS of EBF patches.  But this one is special…  The last really substantial overhaul of the IDE came [...]

Yakov Werde

A Snap-In App Framework Using Dynamic PowerBuilder Assemblies (Part 2) Mar 16 This two-part series examines and contrasts PowerBuilder .NET 12.5.1’s new dynamic assembly feature with corresponding dynamic library functionality in PowerBuilder Classic. The discourse is presented in the context of a simplified yet practical use case. Part 1 presented the use case, reviewed pertinent PowerBuilder Classic dynamic APIs and presented a Classic PBD implementation. Part 2 introduces PowerBuilder .NET 12.5.1’s Dynamic Assembly feature, reveals relevant PowerBuilder .NET generated ...

Building a Snap-In App Framework Using Dynamic PowerBuilder Assemblies Mar 2 The articles in this two-part series examine and contrast PowerBuilder .NET 12.5.1’s new dynamic assembly feature with corresponding dynamic library functionality in PowerBuilder Classic. The discourse is presented in the context of a simplified yet practical use case. The first article presents the use case, reviews pertinent PowerBuilder Classic dynamic APIs, and presents a Classic PBD implementation. The second article introduces PowerBuilder .NET 12.5.1’s Dynamic Assembly feature, reveals re...

Breaking Platform Limitations Mar 2 One of the innovative new features in the PowerBuilder 12.5.1 release is its ability to deploy PowerBuilder .NET code to run in 64-bit mode on 64-bit Windows platforms. In this article, after gaining background and perspective on 32- and 64-bit memory management and .NET deployment models, you’ll explore the internals, strengths and limitations of this new feature. Almost all current server, desktop and notebook hardware platforms have 64-bit processors. Almost all current versions of Windows op...

PFC Project Partitioning Using a Referenced PowerBuilder Assembly Target Feb 22 Paul Harvey, the great American radio personality, would always conclude his colorful broadcasts with the quip “And now you know the rest of the story.” For those of you not acquainted with Paul’s broadcasts, here’s a sample. If you get to about 3:40 in, you’ll hear the classic remark. Paraphrasing Paul’s tag line, in this article you’ll learn “the rest of the story” about RAD Development methodology in PowerBuilder 12.5 .NET using a Referenced PB Assembly Target. I’ll explain the technique and ...

Writing to the Console in PowerBuilder 12.5 .NET Nov 3 Yesterday I taught an intro to PowerBuilder .NET 12.5 session. Part of the presentation had me comparing the.NET IL code inside an assemblies generated from code written in C# and PowerBuilder. The C# code, after performing a simple arithmetic calculation echoed results to the console using these two lines of code. In PowerScript, ordinarily, I echo results using a Messagebox call, but yesterday, I thought I’d “step out on the limb” and echo output to the console using the same NET Framework ...