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 Noteswrote 3 years ago: Our DBMS limits the number of Items in an “IN Clause” to 255. If you attempt to retrieve … more →
wrote 4 years ago: An effective GUI quickly communicates to the users how they can interact with the current window. … more →
wrote 4 years ago: If you have worked with PowerBuilder for a while, you have learned that setting the status of a row … more →
wrote 4 years ago: The Dialog box Comments are prefixed with “//” A carriage return is created with <cntrl> <r … more →
wrote 4 years ago: When are DDDWs populated automatically? A Retrieve() is issued and the DDDW does not have a result s … more →
wrote 4 years ago: How do I set a property for an entire column? Modify(“shft_id.visible = 0″) Modify( … more →
wrote 4 years ago: How do I build a DataWindow dynamically? Build the SQL statement for the DataWindow object as a stri … more →
wrote 5 years ago: About External datawindows have a data source other than a database Typical uses of External Datawin … more →
wrote 5 years ago: Key Columns This option is commonly used for single-user applications. It’s also used when working w … more →
wrote 5 years ago: What is a composite report? A composite report contains other reports based on independent SQL state … more →
wrote 5 years ago: What is a nested report? A report can nest another report as an object within it. This can be useful … more →
wrote 5 years ago: How can I use Retrieval Arguments to make my where clause more flexible? Here is a solution I came u … more →
wrote 5 years ago: Header GroupHeader Detail Group Trailer Footer (end of each page) Summary Suppress Repeating Values … more →
wrote 5 years ago: Display Properties (Masks) ! Upper Case ^ Lower Case a Alphanumeric x Any character # Number Sample … more →
wrote 5 years ago: How do I get my field to appear like a MLE and word wrap? In the datawindow painter, select the colu … more →
wrote 5 years ago: Original Buffer This buffer holds the original data. It is read only and invisible to user. You ca … more →
wrote 5 years ago: Use DYNAMIC keyword Of _GetRow( powerobject ldw ) Choose case TypeOf( ldw ) Case DataStore!, DataWin … more →
wrote 5 years ago: DataWindow, DWChild, and DataStore are all inherited from different places. DataWindow PowerObject A … more →
wrote 5 years ago: You may find yourself working in PB 7 and wanting to use a DataWindow developed in PB 9. This can be … more →