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…
You are currently browsing the Programming category
PowerBuilder – Capture Images from Webcam
PowerBuilder ‘Gotcha’ – Null Messagebox
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…
Look what I found – part 2
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.…
PowerBuilder – Ethiopian multiplication
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 – Database transactions using PFC n_tr
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 – Data Load/ETL process
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 ‘Gotcha’ – SQL Errors
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…
Development tools at Home
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). …
PowerBuilder: Transparent MDI Frame
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 – User Customization Service
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…