Thursday, October 28, 2010

Powerbuilder Function

In every modern programming languages, there is a feature call FUNCTION, as well as Powerbuilder.

FUNCTION is a collection of scripts or statment which it can be re-used. Normally, FUNCTION has a return value.

In Powerbuilder, there are 2 types of FUNCTION: Function and Window Function. The different is FUNCTION can be use anywhere in object that has capabilities to call function, but Window Function just can called in the window itself.

Monday, October 25, 2010

Unlock SA login in Microsoft SQL Server

If you or your team members who has access to your Microsoft SQL Server database with SA login, did type the wrong password three times, normally the SA login will be locked. It should be an error :

Login failed for 'sa' because the account is currently locked out. The system administrator can unlock it.

To solve this problem, you need an authority to access the database server directly. Login with the administrator login name, then open Microsoft SQL Server Management Studio. Choose Windows Authentication mode, then click Connect.

Saturday, October 23, 2010

How to create Sparkline GraphMicrosoft Excel 2010

One new feature in Microsoft Office Excel 2010 is Sparklines. 
Sparklines is a graph display of the collection of data in Microsoft Office Excel, but displayed only in one cell. 
There are 3 types Sparklines: Line, Column and Win / Loss.

Wednesday, October 20, 2010

Powerbuilder Pipeline

Another feature in Powerbuilder programming is Pipeline.
According to manual help of Powerbuilder, a Pipeline system object is used to manage a data pipeline during execution.

You use a Pipeline object by defining a standard class user object inherited from the built-in Pipeline object in the User Object painter. You can then access the Pipeline events by writing scripts that contain code for the events.

Friday, October 15, 2010

How to activate Microsoft Office Trial Version which bundled with Toshiba Notebook

When you buy a new Toshiba notebook, usually you will be given within Microsoft Office applications. By default, the application can only run for 60 days since it was first used, and even then you have to do the activation online, if not you can only use as much as 25 times.

How do I activate Microsoft Office applications are to be used for 60 days for free? 

Wednesday, October 13, 2010

Modify Compute Field Expression in Powerbuilder

Compute Field is an object in Powerbuilder programming, which can be inserted in datawindow. One of mandatory property of Compute Field is Expression.

Expression is set of statement or syntax which represent what you want to show at this compute field. Can be static text, calculation, or the other things.

Saturday, October 9, 2010

Toshiba Portege R700 Short Review

When I first received the Toshiba Portege R700, the first impression is, I admire the luxury of a notebook that is worth about $ 1499.
Physically, the keyboard feels very comfortable, because it uses technology Spill Resistant Keyboard. The distance between one button to another button is separated with a space big enough, so those of you who have big fingers will feel comfortable using it.
Since Toshiba's tag line for this notebook consign this to the business class, the various facilities have been embedded in the Portege R700 is. For example, a dedicated button that is destined for those of you who often make presentations. In another model, you are required to press the fn and F5 key combination to move or duplicate your screen to a projector, now you simply press a button located on the top right of the keyboard. Also for those of you who are not comfortable using its touch pad, and often use the mouse, provided also that the key could direct to turn off the touch pad. Not forget to mention, thinness of this notebook is only about 19 mm and the weight started to 1.39 kg, makes you comfortable when you travel.

With enhanced processor from Intel ® Core
TM i3-350M processor (2.26GHz, 3MB L3 cache), Microsoft Windows 7 Home Premium (32/64-bit), and 4GB memory and a Solid State Drive (to a certain type), Toshiba Portege R700 in the claim has more battery life than other types.

For detail specs for every models of Toshiba Portege R700, you can click here

Friday, October 8, 2010

Rumor: Microsoft will buy Adobe

Adobe Systems Inc. stock price on Thursday (10/07/2010) New York time listed on the Nasdaq stock exchange, had jumped 17 percent to 30 dollars per share before closing at 28.69 dollars per share. Speculation that Microsoft may acquire Adobe's stock price surge triggers the software maker (software) this.

Earlier, The New York Times reported that privately, Microsoft CEO Steve Ballmer has been met with Adobe CEO Narayen Chantanu at Adobe offices in San Francisco recently.

Wednesday, October 6, 2010

How to program Right Click Event in Powerbuilder

As we know at least there are 2 buttons in every mouse that you use with your computer. Known as Left and Right button.

For right-handed user, Left Button is for SELECT purpose. And Right button usually is for displaying the Popup Menu to shortcut the steps.

Tuesday, October 5, 2010

Toshiba Libretto W100 Short Review

In order to celebrate the 25th birthday of their notebook products, Toshiba launched a special product called Toshiba Libretto W100.  Libretto, is one of the classes in Toshiba notebook, which is devoted to small-sized notebook.

Uniquely, the Libretto W100 has 2 screens at once, and has no physical keyboard, such as notebooks in general. When first opened, we will be faced with 2 screens, top and bottom, each measuring 7" wide, with a resolution of 1024x600. The screen can be opened 180 degrees. By default, the screen is "integrated" into a main screen. By pressing the button" keyboard "on the left below, which are made in a dedicated, then at the bottom of the screen will display a virtual keyboard.

How to connect to 2 databases in Powerbuilder

How to connect to more than 1 database in Powerbuilder

Some times, you need to connect to more than 1 database in your application. In Powerbuilder, there's 1 object for database connection that you can create programmatically. The object call: TRANSACTION.

In this example, I will explain how to connect to 2 databases, which mean 1 is with default database connection object (named SQLCA), and the other is the object that we create mannualy.

Sunday, October 3, 2010

AVG Anti-Virus 2011 Free Edition Short Review

Release on Sept 28th, 2010, AVG Anti-Virus Free Edition 2011 brings some new features.

With around 110 MB file size, at least 2 new features added on this version.

1. Social Network Protection