Chapter 3: DataWindow Object Properties

Properties for the DataWindow object

An x in the M (Modify) column means you can change the property. An x in the S column means you can use the property with the SyntaxFromSQL method. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for the DataWindow	M	S	Description
Attributes			All general properties.
Bands			List of bands.
Bandname.property	x		Color, height, and so on for a band, where bandname is Detail, Footer, Header, Summary, or Trailer.
Bandname.Text	x		Rich text content where bandname is Detail, Footer, or Header.
Color	x	x	Background color.
Column.Count			Number of columns.
Data			Description of data.
Data.HTML			Description of the data and format of the DataWindow in HTML format.
Data.HTMLTable			Description of the data in the DataWindow in HTML table format.
Detail.property	x		Color, height, and so on for the detail band.
EditMask.property	x		Settings for EditMask edit style.
FirstRowOnPage			The row number of the first displayed row.
Font.Bias	x		Treat fonts as display or printer.
Footer.property	x		Color, height, and so on for the footer band (see Bandname.property in this table).
Grid.ColumnMove	x		Whether the user can drag to reposition columns.
Grid.Lines	x		Options for lines in grid DataWindow and crosstab.
Header.#.property	x		Color, height, and so on for a group’s header band.
Header.property	x		Color, height, and so on for the header band.
Help.property	x		Help settings for DataWindow actions.
HideGrayLine	x		Whether a gray line displays at page boundaries.
HorizontalScrollMaximum			Width of scroll box in the horizontal scroll bar.
HorizontalScrollMaximum2			Width of second scroll box when scroll bar is split.
HorizontalScrollPosition	x		Position of the scroll box in the scroll bar.
HorizontalScrollPosition2	x		Position of scroll box in second split scroll bar.
HorizontalScrollSplit	x		The position of the split in the scroll bar.
HTMLDW	x		(exp) Whether HTML for the DataWindow is interactive and coordinated with a server component for retrievals and updates.
HTMLGen.property	x		(exp) Settings for HTML generation.
HTMLTable.property	x		Settings for the display of DataWindow data when displayed in HTML table format.
Label.property	x	x	Settings for the Label presentation style.
LastRowOnPage			The last visible row on the page.
Message.Title	x	x	The title of the dialog box that displays errors.
NoUserPrompt	x		Determines whether an error message is displayed to the user.
Objects			The controls in the DataWindow.
Pointer	x		(exp) The pointer when over the DataWindow.
Print.Buttons	x		Whether buttons display on the printed output.
Print.Preview.Buttons	x		Whether buttons display in print preview.
Print.property	x	x	Various settings for printing.
Printer	x		The currently selected printer.
Processing			Processing required by the presentation style.
QueryMode	x		Whether the DataWindow is in query mode.
QuerySort	x		Whether to sort the result set from the query.
ReadOnly	x		Whether the DataWindow is read-only.
Retrieve.AsNeeded	x		Whether to retrieve data only as needed.
Row.Resize	x		Whether user can change the height of rows.
Selected	x		List of selected controls.
Selected.Data			List of selected data.
Selected.Mouse	x		Whether user can use the mouse to select.
ShowDefinition	x		(exp) Display column names instead of data.
Sparse	x		(exp) The repeating columns to be suppressed.
Storage			The amount of storage used by DataWindow.
StoragePageSize			The default page size for DataWindow storage.
Summary.property	x		Color, height, and so on for the summary band.
Syntax			The syntax of the DataWindow.
Syntax.Data			The data of the DataWindow in parse format.
Syntax.Modified	x		Whether the syntax has been modified.
Table.property	x		Various settings for the database.
Table.sqlaction.property	x		Stored procedures for update activity.
Timer_Interval	x	x	The milliseconds between timer events.
Trailer.#.property	x		Color, height, and so on for a group’s trailer band.
Units		x	The unit of measure for the DataWindow.
VerticalScrollMaximum			The height of the scroll box in the scroll bar.
VerticalScrollPosition	x		The position of the scroll box in the scroll bar.
Zoom	x		The scaling percentage of the DataWindow.

Properties for Button controls in DataWindow objects

View this book as PDF