Here is a way to split up a block of text and return a result set based on a delimeter. A table function is used to do the ‘heavy lifting’ and, utilizing some newer features of SQL Server (2005 and 2008), you can even join to it providing for even greater flexability. This situation I…
You are currently browsing the PowerBuilder category
PowerBuilder ‘Gotcha’ – PixelsToUnits
From the Powerbuilder Help on this method: Converts pixels to PowerBuilder units. Because pixels are not usually square, you also specify whether you are converting the pixels’ horizontal or vertical measurement. Syntax PixelsToUnits ( pixels, type ) Argument Description pixels An integer whose value is the number of pixels you want to convert to PowerBuilder…
PowerBuilder – Reading Outlook Items
Here is some code which reads data from Outlook (2007 was tested) into PowerBuilder. You basically need to create a window with a multiline edit and a button on it. Put this into the clicked event of the button. To run it, open Outlook, select something (email message, task, etc.) then click the button on…
PowerBuilder – Grid datawindow object with variable number of columns
Here is a way to build a grid datawindow which contains columns corresponding to an unknown number of data elements. You could use this approach in creating a project schedule, inventory location system, baseball box score, or any number of other examples. My example assumes the minimum number of columns to be four. This create…
PowerBuilder – Selecting and scrolling to an entry in a Listview control
The listview control in PB lacks the capability to scroll to a highlighted item within the native Powerscript. Here is an easy way to do this by simulating key strokes. First declare the following API subroutine. keybd_event( int bVk, int bScan, int dwFlags, int dwExtraInfo) Library "user32.dll" Next create a user event in the listview…
PowerBuilder – Folder Selection Dialog Window
Here is an NVO used to envoke a Windows folder selection dialog since PowerBuilder does not have it’s own version. You can change the API calls to ANSI for earlier versions of PB. I’ve had this squirreled away for awhile and I no doubt got it from someone else off the web. Thanks! // window…
PowerBuilder – Connect to SQLite version 3 database (ODBC)
If you are interested in doing PowerBuilder development with an SQLite database here is the DSN Less connection string to get you going. string ls_dbparm, ls_dbfile, ls_exepath, ls_file[] ls_dbfile = c:\temp\sqlite.db3' IF Fileexists(ls_dbfile) THEN // do nothing ELSE IF GetFileOpenName('Select Data File',ls_dbfile, ls_file,'db3','SQLite files (*.db3),*.db3') < 1 THEN Messagebox('No Data File Chosen','Application will close') HALT…
PowerBuilder ‘Gotcha’ – Datawindow Column Alignments
I’ve been working quite a bit lately on the ‘tooltip’ type of functionality for datawindows. I encountered an issue today which gave me a bit of hassle until I worked it out. My technique looks at the width of the column and it’s position within the datawindow control to decide whether or not all the…
PowerBuilder – Type ahead style dropdown datawindow columns
This type of functionality is one of those things which fills a gap so completely and perfectly that when you encounter some application (and almost all web pages) which doesn’t have it you groan to yourself. In the ancient past this was alternatively referred to as ‘Quicken style’ dropdowns since that application was one very…
PowerBuilder ‘Gotcha’ – Modify Parent Datawindow after a Getchild
If your window makes use of a datawindowchild for whatever reason remember that if you modify the parent datawindow the reference to the child will (most likely) be lost. In the PB Help it states: If a property causes this behavior, this is noted in its description in Chapter 3, “DataWindow Object Properties.” but I…