Blogs about: Powerscript 1 Powerbuilder General
Featured Blog
Getting a Reference to a Submenu
Getting a reference to the window’s menu is easily accomplished using the window’s MenuId property. But what if you want to get a reference to a submenu and all you have is a string with … more →
Schultz's PowerBuilder Notes
Getting a Reference to a Submenu
— 1 comment
rick130 wrote 4 months ago: Getting a reference to the window’s menu is easily accomplished using the window’s MenuI … more →
Setting the RowStatus
— 4 comments
rick130 wrote 11 months ago: If you have worked with PowerBuilder for a while, you have learned that setting the status of a row … more →
Guaranteeing a Singleton
rick130 wrote 1 year ago: Because the datetime on the client machine may not be accurate, I wanted to write a function to get … more →
Nulls
— 1 comment
rick130 wrote 1 year ago: I find nulls to be the cause of so many bugs. Here are a few things that have helped me get my mind … more →
Negative Logic
— 2 comments
rick130 wrote 1 year ago: I maintain several PowerBuilder applications which were written a long time ago by developers just s … more →
System Functions
rick130 wrote 1 year ago: Evaluate( ) The evaluate( ) function is available for use with Describe( ). Evaluate( ) lets you eva … more →
Dynamically Changing DataWindow Properties
— 1 comment
rick130 wrote 1 year ago: What is the difference between SELECT and PBSELECT PBSELECT is generic database independent SQL whic … more →
Working with DDDW Properties
— 1 comment
rick130 wrote 1 year ago: The following example returns the display value for the dept_id column for the current row: String l … more →
How do I call a Function in an Ancestor?
rick130 wrote 1 year ago: Functions default behavior is to Override any existing function with the same name and signature. If … more →
Writing Reusable code
rick130 wrote 1 year ago: Use DYNAMIC keyword Of _GetRow( powerobject ldw ) Choose case TypeOf( ldw ) Case DataStore!, DataWin … more →
Opening up a Window from a Menu Item
rick130 wrote 1 year ago: 1) Create the following user event in your application’s frame window ////////////////////////////// … more →
Temp Tables
rick130 wrote 1 year ago: How do I destroy a temp table (Sybase) Example: //Drop the temp table if it exists ls_command = … more →
PowerBuilder Special String Characters
rick130 wrote 1 year ago: Character Meaning ~n New Line ~f Form feed ~r Carriage Return ~b Backspace ~t Tab ~v Vertical tab ~” … more →
PowerBuilder Colors
— 1 comment
rick130 wrote 1 year ago: RGB Deriving RGB values. The formula for combining primary color values into a number is: 256*256*bl … more →
Working with a Text File
rick130 wrote 1 year ago: This example has shows all the important steps for opening a text file, reading its contents and clo … more →
Stored Procedures
rick130 wrote 1 year ago: Stored Procedures as External Function Declare a Local External Function in n_tr_lm object. (In thi … more →
Embedded SQL
rick130 wrote 1 year ago: If you are using embedded SQL, check the SQLCode, SQLDBCode, and SQLErrText properties of the transa … more →
Class() and TypeOf()
rick130 wrote 1 year ago: Class() The class is the name of an object. You assign the name when you save the object in its pain … more →
Variables
rick130 wrote 1 year ago: Arrays Initializing String ls_array[] Ls_array = {“value1”, “value2”,“value3”, “value4”} Set to null … more →
