Blogs about: 2 Datawindows

Featured Blog

Datawindow Retreive With Large In Clause1 comment

rick130 wrote 3 years ago: Our DBMS limits the number of Items in an “IN Clause” to 255. If you attempt to retrieve … more →

Tags: Argument, Array, datastore, In, retreival, retreival arguments, retreive

Making DW Radio Buttons and Check Boxes look disabled7 comments

rick130 wrote 4 years ago: An effective GUI quickly communicates to the users  how they can interact with the current window.  … more →

Tags: Datawindow PowerScript, Expressions, Modify and Describe, Box, Button, check, check box, Column, Disable

Setting the RowStatus9 comments

rick130 wrote 4 years ago: If you have worked with PowerBuilder for a while, you have learned that setting the status of a row … more →

Tags: Datawindow PowerScript, Powerscript, buffer, change, DataModified!, new, NewModified!, NotModified!, ROW

Datawindow Column Properties

rick130 wrote 4 years ago: The Dialog box Comments are prefixed with “//” A carriage return is created with <cntrl> <r … more →

Tags: Datawindow Painter, Expressions, Modify and Describe, Background, Border, COLOR, green bar, Previous, ROW

Populating Dropdown DataWindows

rick130 wrote 4 years ago: When are DDDWs populated automatically? A Retrieve() is issued and the DDDW does not have a result s … more →

Tags: Drop Down Data Window (DDDW), automatically, populated

DataWindow Script Techniques8 comments

rick130 wrote 4 years ago: How do I set a property for an entire column? Modify(“shft_id.visible = 0″) Modify( … more →

Tags: Datawindow PowerScript, TAB, dynamic, Column, datetime, Modify, Properties, dynamically, example

Dynamic DataWindows3 comments

rick130 wrote 4 years ago: How do I build a DataWindow dynamically? Build the SQL statement for the DataWindow object as a stri … more →

Tags: Build, DataWindow, datawindows, DwSyntax, dynamic, dynamically, example, OpenUserObject, sample

External DataWindows

rick130 wrote 5 years ago: About External datawindows have a data source other than a database Typical uses of External Datawin … more →

Tags: external, leverage

Where Clause for Update/Delete

rick130 wrote 5 years ago: Key Columns This option is commonly used for single-user applications. It’s also used when working w … more →

Tags: Datawindow Painter, delete, where clause, Update, key, Modified, Columns, Updateable

Composite DataWindow2 comments

rick130 wrote 5 years ago: What is a composite report? A composite report contains other reports based on independent SQL state … more →

Tags: Presentation Styles, DataWindow, Footer, composite, sharedata, train, Train the Footer, getchild

Nested Report1 comment

rick130 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 →

Tags: Presentation Styles, DataWindow, Report, nested

SQL Painter

rick130 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 →

Tags: Datawindow Painter, null, DataWindow, SQL, Painter, retrieval, Argument, Prefix, Graphic

DataWindow Bands

rick130 wrote 5 years ago: Header GroupHeader Detail Group Trailer Footer (end of each page) Summary Suppress Repeating Values … more →

Tags: Datawindow Painter, Band, bands, DataWindow, detail, Footer, Group, groupheader, grouptrailer

Column Properties

rick130 wrote 5 years ago: Display Properties (Masks) ! Upper Case ^ Lower Case a Alphanumeric x Any character # Number Sample … more →

Tags: Datawindow Painter, !, #, Code, Column, DataWindow, Display, Edit, itemerror

Column Display1 comment

rick130 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 →

Tags: Datawindow Painter, Word, time, Date, DataWindow, Column, Display, Painter, checkbox

Datawindow Buffers9 comments

rick130 wrote 5 years ago: Original Buffer This buffer holds the original data.  It is read only and invisible to user.  You ca … more →

Tags: DataWindow, Buffers, Primary, Original, Filter, delete, filteredcount()

Writing Reusable code

rick130 wrote 5 years ago: Use DYNAMIC keyword Of _GetRow( powerobject ldw ) Choose case TypeOf( ldw ) Case DataStore!, DataWin … more →

Tags: Powerscript, Datawindow PowerScript, Script, DataWindow, dynamic, reuse

DataWindow Ancestry

rick130 wrote 5 years ago: DataWindow, DWChild, and DataStore are all inherited from different places. DataWindow PowerObject A … more →

Tags: DataWindow, Ancestor, datastore, Heirarchy, powerobject, datawindowchild

Migrating a DataWindow from PB 9 Back to PB 7

rick130 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 →

Tags: PowerBuilder Versions, Export, Convert, Import, S.R.D., 7, 9, migrate, Reverse


Related Tags
All →

Follow this tag via RSS