You are currently browsing the Programming category

PowerBuilder – Capture Images from Webcam

Posted on August 31, 2010 at 8:20 pm in

Here’s some code to capture an image from a webcam in Powerbuilder using EZTWAIN. It worked fine on my Vista Home Premium laptop. I came across it earlier in 2010 but the blog page seems to be gone now. If you know the author, let me know so I can give credit. The file and…

PowerBuilder – Capture Images from Webcam - the full story »

PowerBuilder ‘Gotcha’ – Null Messagebox

Posted on August 30, 2010 at 8:20 pm in

As with many methods in Powerbuilder, the ‘Messagebox’ function returns a NULL if any of the paramenters you send it are NULL. This can be problematic in your ‘defensive programming’ situations where you are informing the user of some type of error or condition. For Example: ls_value = TRIM(data) IF Len(ls_value) > 0 THEN SELECT…

PowerBuilder ‘Gotcha’ – Null Messagebox - the full story »

Look what I found – part 2

Posted on August 23, 2010 at 8:30 pm in

Here is an interesting comment in the header section of a method: // Invoke Service // verb (used with object), -voked, -voking. // 1. to call for with earnest desire; make supplication or pray for: to invoke God’s mercy. // 2. to call on (a deity, Muse, etc.), as in prayer or supplication. // 3.…

Look what I found – part 2 - the full story »

PowerBuilder – Ethiopian multiplication

Posted on August 20, 2010 at 8:01 pm in

I stumbled across this task on the Rosetta Code website. (Link here) Of course I decided to do the task and, as a result, added Powerbuilder to the Rosetta Code website list of languages. There are plenty of other tasks to do so get crackin’. The process of this method of multiplication is to write…

PowerBuilder – Ethiopian multiplication - the full story »

PowerBuilder – Database transactions using PFC n_tr

Posted on August 19, 2010 at 8:19 pm in

Here is a relatively painless way to handle transaction processing in your Powerbuilder application. This code assumes the use of the PFC but could be adapted without too much trouble. This will work with the following database connections: ADO.NET ASE, SYC and SYJ Sybase Adaptive Server Enterprise DIR Sybase DirectConnect I10 Informix IN9 Informix JDB…

PowerBuilder – Database transactions using PFC n_tr - the full story »

PowerBuilder – Data Load/ETL process

Posted on August 18, 2010 at 8:20 pm in

One common piece of functionality in many business applications is the ability to import data from an external source. This could be anything from invoices and orders to inventory forecasts and patient medical histories. Quite often if this type of process is not considered in a generic context you end up with a solution which…

PowerBuilder – Data Load/ETL process - the full story »

PowerBuilder ‘Gotcha’ – SQL Errors

Posted on August 10, 2010 at 8:20 pm in

Most applications I’ve worked on make at least a limited attempt to inform the user of any database related errors especially after an insert, update, and (usually) a commit. Along with this is normally code which displays the database error from the transaction object in a messagebox. Unless you use a custom messagebox with a…

PowerBuilder ‘Gotcha’ – SQL Errors - the full story »

Development tools at Home

Posted on August 10, 2010 at 8:08 pm in

Here is a list of some of the software I use at home. avast! Free Antivirus (www.avast.com) Fine antivirus program at no charge. XnView (www.xnview.com) Free image and graphic file viewer/converter. FileZilla Client (filezilla-project.org) Open Source FTP. Microsoft Visual Studio (www.microsoft.com/express) Great set of tools to use (I use Visual Basic/C# and SQL Server mostly). …

Development tools at Home - the full story »

PowerBuilder: Transparent MDI Frame

Posted on August 6, 2010 at 8:40 pm in

I’m working on an MDI application which uses an mdi frame (naturally) with a sheet (window type: Main!) which normally covers the entire working area of the frame. This window serves as a large ‘sitemap’ of the over all application. One of the windows of the application displays time sensitive data (could be orders, deliveries,…

PowerBuilder: Transparent MDI Frame - the full story »

PowerBuilder – User Customization Service

Posted on July 27, 2010 at 8:20 pm in

Here is an easy to implement user customization service you can add to your Powerbuilder applications which stores configuration information in a database. This gives the added benefit of portability to the users as nothing is stored in files or the registry. It is PFC based but, with minor modifications, could be un-coupled from that…

PowerBuilder – User Customization Service - the full story »

Top