In most ways, the DataWindow in PowerBuilder .NET behaves like the DataWindow in PowerBuilder Classic; however there are some differences.
The DataWindow was rewritten for PowerBuilder .NET using managed code.
To open the Preview, Column Specifications, and Data views, click . The DataWindow object and the data from the database appear in the Preview view only when you click Retrieve.
The Control List has been replaced with the Document Outline, which is a hierarchical list of controls, organized within the bands of the DataWindow object (header, detail, summary, and footer).
In PowerBuilder .NET, you can add custom controls to DataWindow objects.
Closing the Layout view is the same as closing the DataWindow painter in PowerBuilder Classic.
| Cascading menu item in View menu | Menu item |
|---|---|
| Other Windows | Command Window, Document Outline, Task List, Error List, Start Page, Web Browser |
| DataWindow Painter Windows | Preview, Column Specifications, Data Note: Import/Export Template is not available in PowerBuilder .NET version 12.5.
|
These features are not supported for DataWindow objects in PowerBuilder .NET.
| Feature | Unsupported |
|---|---|
| Expressions | AscA, CharA, FillA, LeftA, LenA, MidA, PosA, ProfileInt, ProfileString, ReplaceA, RightA |
| Import types | Dbase 2 & 3 |
| Export types | Dbase 2 & 3, DIF, EMF, Excel, Excel 5, HTML Table, Powersoft Report, Sylk, WKS, WK1, WMF, XSL-FO |
| DataWindow object properties | CSSGen.property, Data.HTML, Data.HTMLTable, Data.XHTML, Data.XMLWeb, Data.XSLFO, Export.PDF.Distill.CustomPostScript, Export.PDF.Method, Export.PDF.XSLFOP.Print, Export.XHTML.TemplateCount, Export.XHTML.Template[ ].Name, Export.XHTML.UseTemplate, Font.Bias, HideGrayLine, HorizontalScrollMaximum2, HorizontalScrollPosition2, HorizontalScrollSplit, HTMLDW, HTMLGen.property, JSGen.PublishPath, JSGen.ResourceBase, Label.Sheet, OLE, Client.property, Picture.Blur, Print.ClipText, Print.Color, Print.Copies, Print.Duplex, Print.OverridePrintJob, Print.Page.Range, Print.Page.RangeInclude, Print.Paper.Source, Print.Preview.Rulers, Print.Quality, Print.Scale, ReplaceTabWithSpace, RichText.ControlsCharVisible, RichText.DisplayOnly, RichText.PictureFrame, RichText.ReadOnly, RichText.ReturnsVisible, RichText.RulerBar, RichText.SpacesVisible, RichText.TabBar, RichText.TabsVisible, RichText.WordWrap, ShowBackColorOnXP, ShowFocusRectangle, XHTMLGen.Browser, XMLGen.property, XSLTGen.property, Zoom Background.Brushmode: ScaledAngle brushmode is not supported in WPF Obsolete properties: Storage, StoragePageSize, Table.CrosstabData, Table.Data.Storage OLE is not supported: OLE.Client.Class, OLE.Client.Name |
This table lists DataWindow objects and controls with unsupported properties.
| DataWindow control | Unsupported properties |
|---|---|
| Bitmap | AccessibleDescription, AccessibleRole, HTML.property, TransparentColor |
| Button | AccessibleDescription, AccessibleRole, Font.CharSet, Font.Escapement, Font.Family, Font.Pitch, Font.Strikethrough, Font.Underline, Font.Width |
| Column | AccessibleDescription, AccessibleRole, CheckBox.3D, CheckBox.Scale, Compute, dddw.AutoHScroll, dddw.HSplitScroll, dddw.ShowList, dddw.UseAsBorder, ddlb.AutoHScroll, ddlb.ShowList, ddlb.UseAsBorder, ddlb.VScrollBar, Edit.AutoHScroll, Edit.AutoVScroll, Font.CharSet, Font.Escapement, Font.Family, Font.Pitch, Font.Width, HTML.property, Ink.AntiAliased, InkEdit.UseMouseForInput, LineRemove, MultiLine, RadioButtons.3D, RadioButtons.Scale, UseInternalLeading, Width.AutoSize |
| Compute | AccessibleDescription, AccessibleRole, Font.CharSet, Font.Escapement, Font.Family, Font.Pitch, Font.Width, HTML.property, MultiLine, Width.AutoSize |
| Custom | AccessibleDescription, AccessibleName, AccessibleRole |
| Graph | AccessibleDescription, AccessibleRole, property.DispAttr.Font.CharSet, property.DispAttr.Font.Escapement, property.DispAttr.Font.Family, property.DispAttr.Font.Pitch, property.DispAttr.Font.Width |
| GroupBox | AccessibleDescription, AccessibleRole, Border, Font.CharSet, Font.Escapement, Font.Family, Font.Pitch, Font.Strikethrough, Font.Underline, |
| InkPicture | Ink.AntiAliased, InkPic.AutoErase, InkPic.HighContrastInk, InkPic.InkEnabled |
| Report | AccessibleDescription, AccessibleName, AccessibleRole, Criteria, Pointer |
| TableBlob | ClientName, OLEClass, Template |
| Text | AccessibleDescription, AccessibleRole, Font.CharSet, Font.Escapement, Font.Family, Font.Pitch, Font.Width, HTML.property |
| Tooltip | HasCloseButton |
Other properties, functions, and methods not supported in PowerBuilder .NET are listed in Unsupported Properties, Events, and Functions.
When Retrieve On Preview is enabled, the data appears in the Preview view when it is first opened. If the view is already open, however, you must click Retrieve to see the data.
If you make changes in the Data view, you must use Save twice to save the changes. First, save the changes in the Data view by selecting Save Changes, and then use to save the changes to the DataWindow object.
The context menu for the Data view in PowerBuilder .NET includes a Save Changes option.
When you are choosing the data source for a DataWindow object, you can select SQL in the wizard and in the next step choose the type: Quick Select, SQL Select, Query, or paste SQL from clipboard.
The property RightToLeft has been deprecated and is kept for backward compatibility. FlowDirection replaces RightToLeft. See Right-To-Left Formatting.
When you save content to an external file, the formatting is preserved in XPS documents but not in PDF documents.