Blogs about: 2 Datawindows
Featured Blog
Datawindow Retreive With Large In Clause
Our DBMS limits the number of Items in an “IN Clause” to 255. If you attempt to retrieve with an array of a larger size, the retrieve fails. One method of dealing with this constraint is t… more →
Schultz's PowerBuilder Notes
Datawindow Retreive With Large In Clause
rick130 wrote 3 months ago: Our DBMS limits the number of Items in an “IN Clause” to 255. If you attempt to retrieve … more →
Making DW Radio Buttons and Check Boxes look disabled
rick130 wrote 8 months ago: An effective GUI quickly communicates to the users how they can interact with the current window. … 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 →
Datawindow Column Properties
rick130 wrote 11 months ago: The Dialog box Comments are prefixed with “//” A carriage return is created with <cntrl> <r … more →
Populating Dropdown DataWindows
rick130 wrote 1 year ago: When are DDDWs populated automatically? A Retrieve() is issued and the DDDW does not have a result s … more →
DataWindow Script Techniques
— 8 comments
rick130 wrote 1 year ago: How do I set a property for an entire column? Modify(“shft_id.visible = 0″) Modify( … more →
Dynamic DataWindows
rick130 wrote 1 year ago: How do I build a DataWindow dynamically? Build the SQL statement for the DataWindow object as a stri … more →
External DataWindows
rick130 wrote 1 year ago: About External datawindows have a data source other than a database Typical uses of External Datawin … more →
Where Clause for Update/Delete
rick130 wrote 1 year ago: Key Columns This option is commonly used for single-user applications. It’s also used when working w … more →
Composite DataWindow
rick130 wrote 1 year ago: What is a composite report? A composite report contains other reports based on independent SQL state … more →
Nested Report
rick130 wrote 1 year ago: What is a nested report? A report can nest another report as an object within it. This can be useful … more →
SQL Painter
rick130 wrote 1 year ago: How can I use Retrieval Arguments to make my where clause more flexible? Here is a solution I came u … more →
DataWindow Bands
rick130 wrote 1 year ago: Header GroupHeader Detail Group Trailer Footer (end of each page) Summary Suppress Repeating Values … more →
Column Properties
rick130 wrote 1 year ago: Display Properties (Masks) ! Upper Case ^ Lower Case a Alphanumeric x Any character # Number Sample … more →
Column Display
rick130 wrote 1 year ago: How do I get my field to appear like a MLE and word wrap? In the datawindow painter, select the colu … more →
Datawindow Buffers
— 5 comments
rick130 wrote 1 year ago: Original Buffer This buffer holds the original data. It is read only and invisible to user. You ca … more →
Writing Reusable code
rick130 wrote 1 year ago: Use DYNAMIC keyword Of _GetRow( powerobject ldw ) Choose case TypeOf( ldw ) Case DataStore!, DataWin … more →
DataWindow Ancestry
rick130 wrote 1 year ago: DataWindow, DWChild, and DataStore are all inherited from different places. DataWindow PowerObject A … more →
Migrating a DataWindow from PB 9 Back to PB 7
rick130 wrote 1 year ago: You may find yourself working in PB 7 and wanting to use a DataWindow developed in PB 9. This can be … more →
