Welcome to Pibbles.NET!

PowerBuilder Knowledge Base, Library, and Idea source
Home
Pages to Watch
PowerScript
Datawindows
IDE
Eye Candy
PFC
Databases
.Net
API
OLE
Web/XML/DOM
EAServer
Other Info
PowerBuilder Solutions
About Us
Contact Us
Site Map
Other Information Related to PowerBuilder
 
This is a completely random set of examples and thoughts that have been gathered from a variety of sources.  Where I can remember the source, I included a note.  If you see your unsourced idea here, drop me a note and I'll give you or the web site credit.
 

How to write a service

Bruce Armstrong, PFC newsgroup, 4/24/06

Create a non-visual object inherited from n_cst_base. Add functions as appropriate. If applicable, create a modified version of a user object that has a of_Set method to instantiate the new service. Wire events and functions on the user object as appropriate to invoke the service.

 

Add Change event to SingleLineEdit

Breck Carter

pbm_enchange: A user event corresponding to pbm_enchange can be used to trap changes to a SingleLineEdit control as the user is typing. It corresponds to the Windows EN_CHANGE event which indicates the user has taken an action that may have altered the text. It is triggered after Windows has updated the display but doesn't wait until the user changes focus.

 

ASCII Values

Breck Carter

To include special ASCII characters in a string search on "ASCII Values" in the Help. For example, to display a symbol like © use the either the decimal or hexadecimal value: "Copyright ~169 1996" or "Copyright ~hA9 1996".

 

 

 

Google Directory:  PowerBuilder is a list of PB-related web sites.  You can fill out a form to submit your own web site to the list.

 

TriggerEvent vs. Event

Note the difference between This.TriggerEvent( "ue_my_event" ) and This.Event ue_my_event() in the return codes. With the first, you get the return code for TriggerEvent. With the second, you get the return code for ue_my_event().

 

AcceptText() returns 1 if ItemChanged returns 2

Papadomichelakis and Molter, DW newsgroup

 

SQL Server Datawindow Argument

Smith and Fisher, DW newsgroup

SQL Server error 37000 on a SQL statement that works under Oracle.

 

Color chart

Use this color chart so you don't have to keep a sticky note with the RGB values of the colors you want to use in your application.