It’s a fairly common practice to report on a set of data derived from a larger group of rows. There are many techniques to do this in code and with the methods available with datawindows/datastores. One typical approach is to use the Filter method. The problem with this is it requires another trip to the…
- .ics
- .NET
- Active Directory
- blacksmithing
- C#
- Citrix
- COM
- Connection string
- coppersmithing
- Dashboard
- datawindow
- debug
- disaster prepardness
- DIY
- ETL
- Facsys
- Flash
- frogs
- games
- MDI
- mySQL
- ODBC
- OLEDB
- Outlook
- parenting
- PB.INI
- pfc
- php
- Powerbuilder
- Powerbuilder OLE
- Powerbuilder Tutorial
- programming
- SCOPE_IDENTITY
- source control
- SQL Anywhere
- SQL Native Client
- SQL Server
- TWAIN
- Uniface
- Visual Basic
- Windows API
- Windows settings
- woodworking project
- wordpress
Powerbuilder – Discarding Rows with Find
Powerbuilder – Discarding Rows with Find - the full story »
PowerBuilder – Determining if Controls Overlap
I had a situation where I needed to know if the user is clicking on a control which is underneath a rectangle on a datawindow. In this case the interior of the rectangle was transparent. ls_name = dwo.name IF (left(ls_name, 2) = ‘r_’) THEN // my standard rectangle naming convention ls_objects = this.Describe( ‘DataWindow.Objects’) ls_objects…
100 Days of PowerBuilder – Day 6 – Adding Controls to a Form
This is part of my project ’100 Days of PowerBuilder’ which is a series of discussions focused on basic PowerBuilder development. Note: This article is written with examples created in PowerBuilder version 12.5. Most steps/examples will be identical with any version going back to 9. Lets add some additional controls to our main form and…
Comment on 100 Days of PowerBuilder – Day 6 – Adding Controls to a Form »
PowerBuilder ‘Gotcha’ – Enabled Property on Controls
I’m writing a generic datawindow processor service to look at the controls on any given datawindow. I’m using the Getobjectatpointer method to give me the name of the current control (dwo.Name can be used as well) but I can’t get anything for a single control. Hmmmm…. To make things more interesting it’s a PB generated…
Comment on PowerBuilder ‘Gotcha’ – Enabled Property on Controls »
100 Days of PowerBuilder – Day 5 – Building up the Application Structure
This is part of my project ’100 Days of PowerBuilder’ which is a series of discussions focused on basic PowerBuilder development. Note: This article is written with examples created in PowerBuilder version 12.5. Most steps/examples will be identical with any version going back to 9. So lets get back to work on our sample application…
Comment on 100 Days of PowerBuilder – Day 5 – Building up the Application Structure »
PowerBuilder – SQL Native Client and DisableBind
Okay so you are upgrading your application, perhaps using the latest version of PowerBuilder (12.5) and SQL Server (2008 R2), and decide to use the SQL Native Client (SNC) to take advantage of new features in the database. Now like many organizations which use Microsoft SQL Server, you may have gone to OLE DB in…
Comment on PowerBuilder – SQL Native Client and DisableBind »
Something to do – Today
A tornado missed my house by about 1000 feet this past Saturday at about 2:30am. Thankfully there was almost no damage done to the house I live in, indeed, even though several houses in my neighborhood were extensively damanged, there were no injuries. This leads me to the purpose of this topic: prepare an emergency…
100 Days of Powerbuilder – Day 4: A Look at the IDE
This is part of my project ’100 Days of PowerBuilder’ which is a series of discussions focused on basic PowerBuilder development. Note: This article is written with examples created in PowerBuilder version 12.5. Most steps/examples will be identical with any version going back to 9. Mastering the PowerBuilder Integrated Development Environment (IDE) is the key…
Comment on 100 Days of Powerbuilder – Day 4: A Look at the IDE »
Powerbuilder – Fontheight method in Expressions
An enhancement was put into PB12.1 dealing with determining the height of a datawindow column based on its font setting. It’s called Fontheight and takes a string parameter. Unfortunately there does not appear to be any documentation on it in the PB help files (I’m looking in PB12.5). You can see a reference to it…
Comment on Powerbuilder – Fontheight method in Expressions »
Coding for Amateurs
Bumped into this code the other day. Hmmmm… //b_paint_good is a boolean set somewhere else IF NOT b_paint_good THEN //do not do something here [code follows] ELSE // do something here [more code follows] END IF Now what's the point of this? Trying to raise the defect count on your software (in the immortal words…
