Webcast: Powering the Future with PowerBuilder 12

PowerbuilderTV (http://twitter.com/#!/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

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

1:  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.

Example:

1:  DataTime dtToday  
2:    
3:  dtToday = DateTime(Today(),Now())  
4:  SetLocalTime(dtToday)  

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.