Powerbuilder 2025 will support ARM machine

Appeon released new information about the upcoming new version of Powerbuilder, which will support ARM processors. Finally!

In the next version of Powerbuilder 2025 R2 / R3, it will supposedly be possible to install on PCs or Notebooks powered by ARM processors such as Snapdragon or Apple Macbook with M chipset series (via VM with ARM version of Windows installed).

Hopefully, we can have all the same Powerbuilder features as the X86/64 version.

You can see the details in the following link: https://www.appeon.com/developers/roadmap

[Updated]

Here's some screenshot of Powerbuilder 2025, installed on Apple Macbook Air M3, via UTM

Installation Process

Warning during the Installation

First Running of Powerbuilder 2025

Finish the Regeneration Process from Version 2019

Application Running

Powerbuilder for Web Alternative Solution

For Powerbuilder users, since Appeon no longer provides the Powerbuilder for Web feature, the solution below can be an alternative if you want to convert your Powerbuilder application into a Web-based application.

Powerbuilder with MySQL Database

One of the easiest way to connect to MySQL DB from Powerbuilder is thru ODBC connection. You have to install latest version of MySQL ODBC Driver  from their official site: https://dev.mysql.com/downloads/file/?id=415028 Download the 32 bits version

SQL Server TRIM Function

I always wondering, why do I have to create my own TRIM function  in SQL Server, all this time. Even the self made TRIM function is simple to be done, but still looks silly when others have the build in function.

But don't worry, the new version of SQL Server (code name SQL Server vNext), adding the TRIM function as build in function, finally...

Beside the TRIM function, another build in functions are CONCAT_WS and TRANSLATE, based on this article.

The latest version SQL Server vNEXT is CTP 1.1 by this December. You can read the full features by clicking this link, as well as download the CTP version

SQL Server Function to Get How Long in Word

This below SQL User Defined Function script is to returns How Long the date already passed, in wording. It's usually displayed in articles to inform the reader how long the article already posted.

Return SQL Server 2016 JSON format In 1 row format

The newest version of Microsoft SQL Server, which it version 2016, comes with JSON native support. So you don't need to convert anymore at script side with 3rd party module like Newtonsoft library.

SQL syntax to show all days in a week

This is SQL SERVER trick is to show the entire daily data from database even there is no transaction data in a particular day

Let say you have a table with the below structure

Table: dailysharelike
Columns:
datetimetrans DATETIME
share_number INT
like_number INT

The data rows are
2016-09-05 00:00:00 | 2   | 1
2016-09-05 00:00:00 | 2   | 3
2016-08-25 00:00:00 | 10  | 1
2016-08-30 00:00:00 | 100 | 90
2016-08-25 00:00:00 | 150 | 80

If you do the query with simple query:

SELECT DATEPART(dw,datetimetrans) AS weekdaynum, DATENAME(dw,datetimetrans) AS weekdayname,
 ISNULL(SUM(like_number),0) AS like_number,
 ISNULL(SUM(share_number),0) AS share_number
 FROM dailysharelike
 GROUP BY DATEPART(dw,datetimetrans), DATENAME(dw,datetimetrans)
 GROUP BY DATEPART(dw,datetimetrans), DATENAME(dw,datetimetrans)

then you will get this (without Sunday, Wednesday, Friday and Saturday)

2 | Monday   | 4   | 4
3 | Tuesday  | 100 | 90
5 | Thursday | 160 | 81

To show all the days in a week, you can use this syntax

SELECT DISTINCT weekdaynum, weekdayname, SUM(like_number) AS like_number,
SUM(share_number) AS share_number FROM
(SELECT 1 AS weekdaynum, 'Sunday' AS weekdayname, 0 AS like_number, 0 AS share_number UNION
 SELECT 2, 'Monday' AS weekdayname, 0 AS like_number, 0 AS share_number UNION
 SELECT 3, 'Tuesday' AS weekdayname, 0 AS like_number, 0 AS share_number UNION
 SELECT 4, 'Wednesday' AS weekdayname, 0 AS like_number, 0 AS share_number UNION
 SELECT 5, 'Thursday' AS weekdayname, 0 AS like_number, 0 AS share_number UNION
 SELECT 6, 'Friday' AS weekdayname, 0 AS like_number, 0 AS share_number UNION
 SELECT 7, 'Saturday' AS weekdayname, 0 AS like_number, 0 AS share_number UNION
 SELECT DATEPART(dw,selfie_upload) AS weekdaynum, DATENAME(dw,selfie_upload) AS weekdayname,
 ISNULL(SUM(like_number),0) AS like_number,
 ISNULL(SUM(share_number),0) AS share_number
 FROM selfie
 GROUP BY DATEPART(dw,selfie_upload), DATENAME(dw,selfie_upload)
) AS hasil GROUP BY weekdaynum, weekdayname
ORDER BY weekdaynum, weekdayname

1 | Sunday    | 0   | 0
2 | Monday    | 4   | 4
3 | Tuesday   | 100 | 90
4 | Wednesday | 0   | 0
5 | Thursday  | 160 | 81
6 | Friday    | 0   | 0
7 | Saturday  | 0   | 0

Windows 10 GodMode

Here's the trick to enable Windows 10 GodMode

• Make a new folder in your desktop
• Rename the folder into 

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

• Now the Godmode shortcut and icon will appear
• Do it with your own risks 

Send SMS with Powerbuilder

Even prestige has begun to decline, in fact, text message (SMS / Short Message System) is still used for 2-way mobile communication. SMS even today is used as a medium for authenticating an application, especially those related to security issues. From social media applications such as Facebook and Twitter, to the e-commerce and even banking applications such as internet banking.

Installing Ghostscript on Windows 10

One of the lack of Powerbuilder feature or function is the native exporting the datawindow object into PDF format. Yes, you can use the SaveAs function in the datawindow object, but for PDF format, you need 3rd party application called Ghostscript to be installed on your PC.

Powerbuilder Function to Check Email Address Validity

This function was made based on Visual Basic scripting. The original was created by Chad M. Kovac, and I tried to translate into Powerbuilder language and fix some minor bugs.

What is HTTP/2 and is it going to speed up the web?

Biggest change to how the web works since 1999 should make browsing on desktop and mobile faster

The web is about to get faster thanks to a new version of HTTP – the biggest change since 1999 to the protocol that underpins the world wide web as we know it today.

Hypertext Transfer Protocol is familiar to most as the http:// at the beginning of a web address. It governs the connections between a user’s browser and the server hosting a website, invented by the father of the web Sir Tim Berners-Lee.

Remove Facebook Account in OSX

When you upgrade your OSX version to the newest one, usually will followed by iPhoto application. Then when you open iPhoto application, there's will be Facebook Account in SHARED directory, and automatically will syncing all the photo from your Facebook account.

Appeon Web for Powerbuilder

Since several years ago, Appeon, 3rd party solution for Powerbuilder which made possibility to deploy the windows based application created by Powerbuilder, into Web-based or even mobile platform.

The first version of Appeon Web for Powerbuilder, was only support for Internet Explorer browser. But now, the newest version can support almost all major browsers such as Firefox, Chrome and even Safari, with only just once deployment step.

See the demo below:

Fingerprint Verification with Powerbuilder

Mr. Yakov Werde, one of the Powerbuilder guru, shown us how to use a free SDK for fingerprint device within Powerbuilder. He using Powerbuilder version 12.5 and free fingerprint SDK from Neuro Technology.

This video shows how to do it in detail

Powerbuilder Function to Get Last Date in Month

This function is to get last date in particular month

Create a function named f_lastdate

Specify a date type as return value
Specify a date type parameter name dTgl, then type this script below

1:  integer iMonth, iDate  
2:  iMonth = Month(dTgl)  
3:  CHOOSE CASE iMonth  
4:       CASE 1, 3, 5, 7, 8, 10, 12  
5:            iDate = 31  
6:       CASE 4, 6, 9, 11  
7:            iDate = 30       
8:       CASE 2  
9:            IF isDate( '29/' + String(iMonth) + '/' + String(Year(dTgl))) THEN  
10:                 iDate = 29  
11:            ELSE  
12:                 iDate = 28  
13:            END IF  
14:  END CHOOSE       
15:  dTgl = Date( String(iDate) + '/' + String(iMonth) + '/' + String(Year(dTgl)))  
16:  RETURN dTgl  

To use the function, use this script

1:  Date dLastDate  
2:  dLastDate = f_lastdate(today())  

dLastDate value should be: 30 April 2014, if assume today is 3rd April 2014.

Samsung Galaxy S5 vs. Apple iPhone 5S vs. Google Nexus 5

This article was taken from IT World, and wrote by Jon Gold

February 26, 2014, 12:10 PM — Samsung made the Galaxy S5 official on Monday at a Mobile World Congress presentation in Barcelona, touting a slimmed-down approach to the latest flagship's feature set and simplified design.

It's a small but notable departure for the South Korean company, whose devices all too frequently combine undeniable engineering brilliance with a glut of marginally useful features. Co-CEO J.K. Shin and other Samsung executives who presented at the event were eager to talk up the way in which the company had listened to input from their customers.

Apple officially unveils the iPhone 5s, coming September 20

Just as expected, the newly introduced Apple iPhone 5s looks the same on the outside (if you don't count the new white with gold/champagne color option). It still has the same thin 7.6mm profile and it still weighs merely 112g. However it comes with a number of changes under the hood where pretty much all the work has gone into this time around.

Accessing Youku outside of China

Are you a huge fans of Chinese, Korean, Japanese movies or TV serial? I'm sure you already knew Youku!!!

Youku is the biggest online streaming movies provider from China. Many movies, from west to east, are available inside youku, and you can watch them with FREE, as long as you are in China territory. Means that you have living in China, since Youku will detect your IP address.

Web CD Player with Powerbuilder & Appeon

Chris Pollach, one of master of Powerbuilder demonstrated the power of Appeon. Build with Powerbuilder 12.1 and compile to be pure web-based version with the Appeon. He made the CD player application.

Read the full article and download the apps for free.