Tuesday, December 21, 2010

Sending email with Powerbuilder

Several months ago, I posted the article which explain how to create Outlook Calendar Appointment with Powerbuilder. One of the reader asked me to how if  we want to send an email with Powerbuilder via Microsoft Outlook.

Well, several years ago, I wrote this PBL which have a window inside that can read the Address Book of Microsoft Outlook, and put as the recipients and send the email via Microsoft Outlook. Since I am not using Microsoft Outlook anymore, I don't know it will be run smoothly or not in Outlook version 2007 or 2010.

You can download it by clicking here

New features in Powerbuilder 12.1

In 21 Sept 2010, Sybase launched the EBF for Powerbuilder version 12 with 12.1 as the minor version.

According to PowerbuilderTV.Com, there are some new features in version 12.1 such :

  • XAML Editor Enhancements
  • 3rd Party Control Support
  • OLE Control Support in WPF Application
  • WPF DW RightToLeft Enhancements

But still there are some limitations like
  • No support for dynamically creating OLE controls in PowerScript
  • No support for saving and retrieving the structure storage of an OLE control
  • Must install .NET framework SDK 2.0 or later before you migrate OLE controls to WPF
For detail, visit this link to see the complete video. The duration is about 40 minutes. And you can download the version 12.1 EBF file from Sybase official download site

Wednesday, December 15, 2010

Webcast: Powering the Future with PowerBuilder 12

PowerbuilderTV (!/PowerBuilderTV) release they tweet about webcast with subject Powering the Future with Powerbuilder 12, last night. This webcast is sponsored by Sybase and will be held Tuesday, December 14, 2010, 10:00 am PST / 1:00 pm EST.

Check out the detail at this link

Friday, December 10, 2010

Set Local Computer Time with Powerbuilder

With External Function feature, we can set the Local Computer's time with Powerbuilder.

First, we need to declare the external function, called SetLocalTime from kernel32.dll

FUNCTION long SetLocalTime(ref str_SYSTEMTIME lpSystemTime ) LIBRARY "kernel32.dll" alias for "SetLocalTimeA"

To use the function, just pass a datetime variable when you call the function.


DataTime dtToday
dtToday = DateTime(Today(),Now())


Wednesday, December 1, 2010

Integer versus Long Data Type in Powerbuilder

When you have an INTEGER column type in a table on your database, you must be aware to script in Powerscript.

The Integer data type in Powerbuilder just have the 16-bit signed characteristic, which mean only can store the integer number between -32768 to +32767. It's totally different with the Integer data type in your SQL database engine. I'm talking about Ms. SQL Server 2000/2005 in this case.

Make sure always using LONG data type in your variable, instead of INTEGER, to prevent the value outside -32768 or +32767.

For example, if the value of the column in your database is 34000, you'll get an error if you store the value into the integer variable on your script.