PowerBuilder Tips

A number of useful PowerBuilder tips are provided under the following topic headings:

• General PowerBuilder Tips
• Diagnosing / Solving Difficult PowerBuilder Problems
• DataWindow Tips
• PFC Tips
• ... Back to Main PowerBuilder Topics

General PowerBuilder Tips

• Setting Focus to the TabPage with the Control
• Re-initializing an unbounded array
• Calling Oracle Stored Procedures from PowerBuilder
• Checking for Errors after Inline SQL or Stored Procedures
• Setting Focus to a Window (handling minimized)
• Numeric Values for Standard Windows Colours (e.g. Button Face, etc.)
• PowerBuilder treatment of Nulls
• The Invisible MessageBox

Diagnosing / Solving Difficult Problems

• Cryptic Errors that Mean Something
• Determining whether the Problem is yours or PowerBuilder's
• Working around known PowerBuilder Problems
• Figuring out a Problem in EXE but not Development Environment
• Tracing an EXE
• A Simple/Safe EXE Configuration
• A list of PowerBuilder Execution Errors

DataWindow Tips

• Change Grid DW into List DW and Vice-Versa
• Getting two columns from the same row onto a DW graph
• Making "Groupboxes" inside a DW (pre-PB6)
• Making grids look "nice" (3 suggestions)
• Copying data from a Grid DW to the Windows Clipboard
• Dealing with Proportional Font Data (2 major areas)
• General Routine to Validate DDDW Input
• Capturing Special Keys on your DataWindow (e.g. Enter, Tab)
• Avoiding "Double" Error Messages in DW Validation
• Full ItemChanged, ItemError and DBError Code Samples

PFC Tips

• Making PFC Help Easily Accessible
• Message Handling in a PFC DataWindow
• Replacement for pfc_u_tv's of_FindItem
• CloseQuery Fix
• String-to-DateTime Conversion Function
• Shutdown Window with no Prompts
• Larger PFC Discussion Topics

Coding conventions used on this site

Copyright © Woodger Computing Inc.