You are currently browsing all posts tagged with Powerbuilder

PowerBuilder – Selecting and scrolling to an entry in a Listview control

Posted on August 17, 2011 at 8:20 pm in

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 – Selecting and scrolling to an entry in a Listview control - the full story »

Using ICalendar (.ICS) files for Event Scheduling

Posted on June 24, 2011 at 8:20 pm in

Here is a very easy way to schedule events from within your application. This assumes you have a way to send emails with attachments. If you are dealing with a high volume situation, you may with to write the data to a table and have the database (or some other process) send them out. The…

Using ICalendar (.ICS) files for Event Scheduling - the full story »

PowerBuilder – Folder Selection Dialog Window

Posted on June 23, 2011 at 8:20 pm in

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 – Folder Selection Dialog Window - the full story »

PowerBuilder – Connect to SQLite version 3 database (ODBC)

Posted on June 14, 2011 at 8:20 pm in

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 – Connect to SQLite version 3 database (ODBC) - the full story »

PowerBuilder ‘Gotcha’ – Datawindow Column Alignments

Posted on June 9, 2011 at 8:20 pm in

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 ‘Gotcha’ – Datawindow Column Alignments - the full story »

PowerBuilder – Type ahead style dropdown datawindow columns

Posted on June 6, 2011 at 8:20 pm in

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 – Type ahead style dropdown datawindow columns - the full story »

PowerBuilder ‘Gotcha’ – Modify Parent Datawindow after a Getchild

Posted on May 27, 2011 at 8:20 pm in

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…

PowerBuilder ‘Gotcha’ – Modify Parent Datawindow after a Getchild - the full story »

PowerBuilder – Treeview like Tooltips for Datawindows

Posted on May 18, 2011 at 8:20 pm in

The treeview control has a very neat piece of functionality built in called Tooltips. When this property is checked your application will automatically display all the text on a treeview item if it is cut off by the edge of the control when the mouse pointer goes over that row. If the row text is…

PowerBuilder – Treeview like Tooltips for Datawindows - the full story »

PowerBuilder – Datawindow column Edit.Style values

Posted on May 11, 2011 at 8:20 pm in

checkbox dddw ddlb edit editmask inkedit radiobuttons richtext For some reason I couldn’t find this information in a nice list so here it is.

PowerBuilder – Datawindow column Edit.Style values - the full story »

PowerBuilder – Filter vs Find performance

Posted on May 6, 2011 at 8:20 pm in

If you have rows in a datawindow/datastore and you want to look through them for a match against some new code (say you are looking for an existing entry so you can add to the quantity), it is better to use the Find method in a loop than to use the Filter method. Filtering large…

PowerBuilder – Filter vs Find performance - the full story »

Top