You place DataWindow controls in a window or user object and then specify the DataWindow object you want to use within them to display and manipulate data in the window.
A DataWindow object allows users to display, manipulate, and update database or other information. You build DataWindow objects in the DataWindow painter.
For information about DataWindow objects, see Working with DataWindows in Users Guide.
Obsolete functions
Several DataWindow control functions are described as obsolete, which means that although the function operates as usual in this release, it will be removed in a future release. You should replace all use of these functions as soon as possible.
DataWindow property |
Datatype |
Description |
---|---|---|
String |
A description of the control and/or its purpose for use by accessibility tools such as readers for visually impaired users. |
|
String |
A label that briefly describes the control, such as the text in a button or the name of a menu item. |
|
AccessibleRole (enumerated) |
Describes what kind of user interface element the control is. |
|
Boolean |
Specifies whether the control has a border. Values are: TRUE -- Control has a border. FALSE -- Control does not have a border. |
|
BorderStyle (enumerated) |
Specifies the border style of the control. Values are: StyleBox! StyleLowered! StyleRaised! StyleShadowBox! |
|
Boolean |
Specifies whether PowerBuilder moves the control to the top of the front-to-back order. |
|
ClassDefinition |
PowerObject |
An object of type PowerObject containing information about the class definition of the object or control. |
Boolean |
Specifies whether the Control Menu box displays in the control title bar. Values are: TRUE -- Control Menu box displays in the control title bar. FALSE -- Control Menu box does not display in the control title bar. |
|
String |
Specifies the name of the DataWindow object associated with the control. |
|
Boolean |
Specifies whether PowerBuilder puts the control automatically into Drag Mode. DragAuto has these boolean values: TRUE -- When the control is clicked, the control is automatically in Drag Mode. FALSE -- When the control is clicked, the control is not automatically in Drag Mode. You have to put the control into Drag Mode manually by using the Drag function. |
|
String |
Specifies the name of the stock icon or the file containing the icon you want to display when the user drags the control (the ICO file). The default icon is a box the size of the control. When the user drags the control, the icon displays when the control is over an area in which the control can be dropped (a valid drop area). When the control is over an area that is not a valid drop area, the No-Drop icon displays. |
|
Boolean |
Specifies whether the control is enabled (can be selected). Values are: TRUE -- Control is enabled. FALSE -- Control is not enabled. |
|
Integer |
Specifies the height of the DataWindow control, in PowerBuilder units. |
|
Boolean |
Specifies whether a horizontal scroll bar displays in the control when all the data cannot be displayed at one time. Values are: TRUE -- Horizontal scroll bar is displayed. FALSE -- Horizontal scroll bar is not displayed. |
|
Boolean |
Specifies whether the split bar displays in the control. Values are: TRUE -- Split bar is displayed. FALSE -- Split bar is not displayed. |
|
String |
Specifies the name of the ICO file that contains the icon that displays when the DataWindow control is minimized. |
|
Boolean |
Scrolls the rows in the DataWindow control while the user is moving the scroll box. |
|
Boolean |
Specifies whether a Maximize Box displays in the DataWindow control title bar. Values are: TRUE -- Maximize Box displays. FALSE -- Maximize Box does not display. |
|
Boolean |
Specifies whether a Minimize Box displays in the DataWindow control title bar. Values are: TRUE -- Minimize Box displays. FALSE -- Minimize Box does not display. |
|
Object |
DWObject |
Used for the direct manipulation of objects within a DataWindow object from a script. These objects can be, for example, columns or text objects. |
Boolean |
Specifies whether the DataWindow control is resizable. Values are: TRUE -- DataWindow is resizable. FALSE -- DataWindow is not resizable. |
|
Boolean |
Specifies that characters should be displayed in right-to-left order. The application must be running on an operating system that supports right-to-left display. Values are: TRUE -- Characters display in right-to-left order. FALSE -- Characters display in left-to-right order. |
|
Integer |
Specifies the tab value of the DataWindow control within the window or user object (0 means the user cannot tab to the control). |
|
String |
Specifies the tag value assigned to the DataWindow control. |
|
String |
Specifies the text that displays in the DataWindow control title bar. |
|
Boolean |
Specifies whether a title bar displays in the DataWindow control. The user can move the DataWindow control only if it has a title bar. Values are: TRUE -- Title bar is displayed in control. FALSE -- No title bar is displayed in control. |
|
Boolean |
Specifies whether the DataWindow control is visible. Values are: TRUE -- Control is visible. FALSE -- Control is not visible. |
|
Boolean |
Specifies whether a vertical scroll bar displays in the control when not all the data can be displayed at one time. Values are: TRUE -- Vertical scroll bar is displayed. FALSE -- Vertical scroll bar is not displayed. |
|
Integer |
Specifies the width of the DataWindow control, in PowerBuilder units. |
|
Integer |
Specifies the X position (the distance from the left edge of the window), in PowerBuilder units. |
|
Integer |
Specifies the Y position (the distance from the top edge of the window), in PowerBuilder units. |
Some but not all DataWindow events have return codes that you can use to determine what action is taken after the event occurs. You set the return codes in a RETURN statement in the event script.
DataWindow event |
Occurs |
---|---|
ButtonClicked in DataWindow Reference |
When the user clicks a button. |
ButtonClicking in DataWindow Reference |
When the user clicks a button. This event occurs before the ButtonClicked event. |
Clicked in DataWindow Reference |
When the user clicks between fields in the DataWindow control. Return codes: 0 - (Default) Continue processing. 1 - Stop processing. |
Collapsed in DataWindow Reference |
When a node in a TreeView DataWindow has collapsed. |
Collapsing in DataWindow Reference |
Before a node in a TreeView DataWindow collapses. |
Constructor in DataWindow Reference |
Immediately before the Open event occurs in the window. |
DBError in DataWindow Reference |
When a database error occurs in the DataWindow control. |
Destructor in DataWindow Reference |
Immediately after the Close event occurs in the window. |
DoubleClicked in DataWindow Reference |
When the user double-clicks between fields in the DataWindow control. For a RichText presentation style DataWindow, when the user double-clicks in the text. |
DragDrop in DataWindow Reference |
When a dragged control is dropped on the DataWindow control. |
DragEnter in DataWindow Reference |
When a dragged control enters the DataWindow control. |
DragLeave in DataWindow Reference |
When a dragged control leaves the DataWindow control. |
DragWithin in DataWindow Reference |
When a dragged control is within the DataWindow control. |
EditChanged in DataWindow Reference |
When a user types in an edit control in the DataWindow control. |
Error in DataWindow Reference |
When an error is found in a data or property expression for a DataWindow object. |
Expanded in DataWindow Reference |
When a node in a TreeView DataWindow has expanded. |
Expanding in DataWindow Reference |
Before a node in a TreeView DataWindow expands. |
GetFocus in DataWindow Reference |
Just before the DataWindow control receives focus (before it is selected and becomes active). |
Help in PowerScript Reference |
When the user presses the F1 key or drags the context help button (question mark) from the title bar to a menu item or control. |
ItemChanged in DataWindow Reference |
When a field in the DataWindow has been modified and loses focus (for example, the user presses Enter, the Tab key, or an arrow key, or clicks the mouse on another field within the DataWindow). Return codes: 0 - (Default) Accept the data value. 1 - Reject the data value and do not allow focus to change. 2 - Reject the data value but allow focus to change. |
ItemError in DataWindow Reference |
When a field has been modified, the field loses focus (for example, the user presses Enter, Tab, or an arrow key, or clicks the mouse on another field), and the field does not pass the validation rules for its column. Return codes: 0 - (Default) Reject the data value and show an error message box. 1 - Reject the data value with no message box. 2 - Accept the data value. 3 - Reject the data value but allow focus to change. If the Return code is 0 or 1 (rejects the data), the field with the incorrect data regains the focus. |
ItemFocusChanged in DataWindow Reference |
When the current item in the control changes. |
LoseFocus in DataWindow Reference |
When the DataWindow control loses focus (becomes inactive). |
Other in PowerScript Reference |
When a Windows message occurs that is not a PowerBuilder event. |
Printend in DataWindow Reference |
When the printing of the DataWindow ends. |
PrintPage in DataWindow Reference |
Before each page of the DataWindow is formatted for printing. Return codes: 0 - Do not skip a page. 1 - Skip a page. |
PrintStart in DataWindow Reference |
When the printing of the DataWindow starts. |
RButtonDown in DataWindow Reference |
When the right mouse button is pressed on the control. For a RichText presentation style DataWindow, if PopUp Menu has been turned on, this event is not triggered when the right mouse button is pressed. |
Resize in DataWindow Reference |
When the user or a script resizes a DataWindow control. |
RetrieveEnd in DataWindow Reference |
When the retrieval for the DataWindow is complete. |
RetrieveRow in DataWindow Reference |
After a row has been retrieved. Return codes: 0 - (Default) Continue. 1 - Stop the retrieval. |
RetrieveStart in DataWindow Reference |
When the retrieval for the DataWindow is about to begin. Return codes: 0 - (Default) Continue. 1 - Do not perform the retrieval. 2 - Do not reset the rows and buffers before retrieving the data from the database. |
RowFocusChanged in DataWindow Reference |
When the current row changes in the DataWindow. |
RowFocusChanging in DataWindow Reference |
When the current row is about the change in the DataWindow. This event occurs before the RowFocusChanged event. |
ScrollHorizontal in DataWindow Reference |
When the user scrolls right or left in the DataWindow control with the Tab or arrow keys or the scroll bar. |
ScrollVertical in DataWindow Reference |
When the user scrolls up or down in the DataWindow control with the Tab or arrow keys or the scroll bar. |
SQLPreview in DataWindow Reference |
After a Retrieve, Update, or ReselectRow function call and immediately before the SQL statement is submitted to the DBMS. The following return codes specify the action that takes place when the event occurs after an Update function call only: 0 - (Default) Continue. 1 - Stop. 2 - Skip this request and execute the next request. |
UpdateEnd in DataWindow Reference |
When all the updates from the DataWindow to the database are complete. |
UpdateStart in DataWindow Reference |
After an Update function call and just before changes in the DataWindow are sent to the database. Return codes: 0 - (Default) Continue. 1 - Do not perform the update. |
WSError in DataWindow Reference |
Occurs when an error is returned for a DataWindow using the WSConnection object to connect to a Web service data source. |
DataWindow function |
Datatype returned |
Description |
---|---|---|
AcceptText in DataWindow Reference |
Integer |
Applies the contents of the DataWindow control's edit control to the current item in the DataWindow buffer. |
CanUndo in DataWindow Reference |
Boolean |
Specifies whether the last edit can be undone with the Undo function. Applies to the edit control over the current row and column. Values are: TRUE -- Last edit can be undone. FALSE -- Last edit cannot be undone. |
CategoryCount in DataWindow Reference |
Integer |
Returns the number of categories in the specified graph in the DataWindow control. |
CategoryName in DataWindow Reference |
String |
Returns the name of the specified category in the specified graph in the DataWindow control. |
ClassName in DataWindow Reference |
String |
Returns the name assigned to the DataWindow control. |
Clear in DataWindow Reference |
Integer |
Clears (deletes) the selected text in the edit control of the DataWindow control. For a RichText presentation style DataWindow, clears the selected text in the DataWindow. |
ClearValues in DataWindow Reference |
Integer |
Deletes all items from the value list associated with the specified column in the DataWindow control. |
Clipboard in DataWindow Reference |
Integer |
Copies the specified graph in the DataWindow control to the clipboard. |
Copy in DataWindow Reference |
Integer |
Copies the selected text in the edit control over the current row and column of the DataWindow control to the clipboard. For a RichText presentation style DataWindow, copies the selected text in the DataWindow control. |
CopyRTF in DataWindow Reference |
String |
Returns the selected text, pictures, and input fields in a DataWindow control as a string with rich text formatting. Bitmaps and input fields are included in the string. |
Create in DataWindow Reference |
Integer |
Creates a DataWindow object using the specified source code and replaces the DataWindow object in the specified DataWindow control with the new DataWindow object. |
CrosstabDialog in DataWindow Reference |
Integer |
Displays the Crosstab Definition dialog box so the user can modify the definition of a crosstab DataWindow object during execution. |
Cut in DataWindow Reference |
Integer |
Cuts the selected text from the edit control over the current row and column of the DataWindow and stores it in the clipboard. For a RichText presentation style DataWindow, cuts the selected text in the DataWindow control. |
DataCount in DataWindow Reference |
Long |
Returns the number of data points in the specified series in the specified graph in the DataWindow control. |
DBCancel in DataWindow Reference |
Integer |
Cancels a database retrieval in progress. |
DBErrorCode in DataWindow Reference |
Long |
Returns the error code (number) generated by a database error. Obsolete function DBErrorCode is an obsolete function and will be discontinued in a future release. Database error codes are now available as event arguments. |
DBErrorMessage in DataWindow Reference |
String |
Returns a string containing the text of the error message generated by a database error. Obsolete function DBErrorMessage is an obsolete function and will be discontinued in a future release. Database error messages are now available as event arguments. |
DeletedCount in DataWindow Reference |
Long |
Returns the number of rows that have been deleted from the DataWindow control but have not yet been updated in the associated database table. |
DeleteRow in DataWindow Reference |
Integer |
Deletes the specified row from the DataWindow control. |
Describe in DataWindow Reference |
String |
Returns requested information about the structure of the DataWindow control. |
Drag in DataWindow Reference |
Integer |
Starts or ends the dragging of the DataWindow control. |
Filter in DataWindow Reference |
Integer |
Displays specific rows of the DataWindow control based on its current filter. |
FilteredCount in DataWindow Reference |
Integer |
Returns the number of rows that are not visible because of the current filter. |
Find in DataWindow Reference |
Long |
Syntax 1: Finds the next row in a DataWindow control in which data meets a specified condition. Syntax 2: For Rich Text presentation style Data Windows, finds the specified text in the control and highlights the text if found. You can specify search direction and whether to match whole words and case. |
FindCategory in DataWindow Reference |
Integer |
Returns the number of the specified category in the specified graph in the DataWindow control. |
FindGroupChange in DataWindow Reference |
Long |
Searches starting at a specified row for the first break for the specified group in the DataWindow control. |
FindNext in DataWindow Reference |
Integer |
Finds the next occurrence of text in the control and highlights it, using criteria set up in a previous call of the Find function. This function applies only to DataWindow controls whose content has the RichText presentation style. |
FindRequired in DataWindow Reference |
Integer |
Identifies the required columns that the user has not filled. |
FindSeries in DataWindow Reference |
Integer |
Returns the number of the specified series in the specified graph in the DataWindow control. |
GenerateHTMLForm in DataWindow Reference |
Integer |
Creates an HTML Form element containing columns for one or more rows. Also returns an HTML Style element containing style sheet information. |
GenerateResultSet in DataWindow Reference |
Long |
Returns an EAServer result set from a PowerBuilder user object running as a component on EAServer. Obsolete function GenerateResultSet is an obsolete function, because EAServer is no longer supported since PowerBuilder 2017. |
GetBandAtPointer in DataWindow Reference |
String |
Returns the string containing the band in which the pointer is currently located followed by a tab character (~t) and the number of the row associated with the band. |
GetBorderStyle in DataWindow Reference |
Border (enumerated) |
Returns a Border enumerated datatype indicating the border style of the specified column in the DataWindow control. Values are: Box! Lowered! NoBorder! Raised! ResizeBorder! ShadowBox! Underline! |
GetChanges in DataWindow Reference |
Long |
Retrieves changes made to a DataWindow into a blob. This function is used primarily in distributed applications. |
GetChild in DataWindow Reference |
Integer |
Stores in the specified variable the name of the child DataWindow in the specified column. |
GetClickedColumn in DataWindow Reference |
Integer |
Returns the number of the column in the DataWindow control that the user clicked or double-clicked. |
GetClickedRow in DataWindow Reference |
Long |
Returns the number of the row in the DataWindow control that the user clicked or double-clicked. |
GetColumn in DataWindow Reference |
Integer |
Returns the number of the current column in the DataWindow control. |
GetColumnName in DataWindow Reference |
String |
Returns the name of the current column in the DataWindow control. |
GetContextService in DataWindow Reference |
Integer |
Creates a reference to a context-specific instance of the specified service. |
GetData in DataWindow Reference |
Double |
Returns the value of the specified data in the specified series in the specified graph in the DataWindow control. See also GetDataValue in DataWindow Reference. |
GetDataPieExplode in DataWindow Reference |
Integer |
Reports the percentage that a pie slice is exploded in a pie graph. |
GetDataLabelling in DataWindow Reference |
Integer |
Determines whether the data at a given data point is labeled in a DirectX 3D graph. |
GetDataStyle in DataWindow Reference |
Integer |
Finds out the appearance of a data point in a graph. Each data point in a series can have individual appearance settings. There are different syntaxes, depending on what settings you want to check. |
GetDataTransparency in DataWindow Reference |
Integer |
Obtains the transparency percentage of a series in a DirectX 3D graph. |
GetDataValue in DataWindow Reference |
Integer |
Returns the value of the specified data in the specified series in the specified graph in the DataWindow control. |
GetFormat in DataWindow Reference |
String |
Returns the format used for display in the specified column of the DataWindow control. |
GetFullState in DataWindow Reference |
Long |
Retrieves the complete state of a DataWindow into a blob. This function is used primarily in distributed applications. |
GetItemDate in DataWindow Reference |
Date |
Returns the date data in the specified row and column of the DataWindow control. |
GetItemDateTime in DataWindow Reference |
DateTime |
Returns the datetime data in the specified row and column of the DataWindow control. |
GetItemDecimal in DataWindow Reference |
Decimal |
Returns the decimal data in the specified row and column of the DataWindow control. |
GetItemNumber in DataWindow Reference |
Double |
Returns the numeric data in the specified row and column of the DataWindow control. |
GetItemStatus in DataWindow Reference |
dwItemStatus (enumerated) |
Returns the status of the item at the specified row and column location in the specified buffer. Values are: DataModified! New! NewModified! NotModified! |
GetItemString in DataWindow Reference |
String |
Returns the string data in the specified row and column of the DataWindow control. |
GetItemTime in DataWindow Reference |
Time |
Returns the time data in the specified row and column of the DataWindow control. |
GetMessageText in DataWindow Reference |
String |
Obtains the message text generated by a crosstab DataWindow object in the DataWindow control. Obsolete function GetMessageText is an obsolete function and will be discontinued in a future release. Message text is now available as an argument in a user-defined DataWindow event associated with the token pbm_dwnmessagetext. |
GetNextModified in DataWindow Reference |
Long |
Returns the number of the first row that was modified in the specified buffer in the specified DataWindow control after the specified row. |
GetObjectAtPointer in DataWindow Reference |
String |
Returns the string containing the name of the column or graphic control under the pointer in the DataWindow control, then a tab character (~t), and then the row number. |
GetParent in DataWindow Reference |
PowerObject |
Returns a reference to the name of the parent object. |
GetRow in DataWindow Reference |
Long |
Returns an integer containing the number of the current row in the DataWindow control. |
GetRowFromRowId in DataWindow Reference |
Long |
Gets the row number of a row in a DataWindow control from the unique row identifier associated with that row. |
GetRowIdFromRow in DataWindow Reference |
Long |
Gets the unique row identifier of a row in a DataWindow control from the row number associated with that row. |
GetSelectedRow in DataWindow Reference |
Integer |
Returns the number of the first selected row after the specified row number in the DataWindow control. |
GetSeriesLabelling in DataWindow Reference |
Integer |
Obtains the series labelling for a DirectX 3D graph. |
GetSeriesStyle in DataWindow Reference |
Integer |
Finds out the appearance of a series in a graph. There are several syntaxes, depending on what settings you want. |
GetSeriesTransparency in DataWindow Reference |
Integer |
Obtains the transparency percentage of a series in a DirectX 3D graph. |
GetSQLPreview in DataWindow Reference |
String |
Returns the current SQL statement the DataWindow control is submitting to the database. Obsolete function GetSQLPreview is an obsolete function and will be discontinued in a future release. SQL syntax is now available as an event argument. |
GetSQLSelect in DataWindow Reference |
String |
Returns the current SELECT statement for the DataWindow control. |
GetStateStatus in DataWindow Reference |
Long |
Retrieves the current status of the internal state flags for a DataWindow and places this information in a blob. This function is used primarily in distributed applications. |
GetText in DataWindow Reference |
String |
Returns the text in the edit control over the current row and column of the DataWindow control. |
GetTrans in DataWindow Reference |
Integer |
Returns the values in the DataWindow Transaction object. |
GetUpdateStatus in DataWindow Reference |
Integer |
Stores the number of the row that will be updated in a variable, and the dwBuffer enumerated datatype identifying the buffer containing the row in another variable. Obsolete function GetUpdateStatus is an obsolete function and will be discontinued in a future release. Update status is now available as an argument in the DataWindow control DBError and SQLPreview events. |
GetValidate in DataWindow Reference |
String |
Returns the validation rule used in the specified column of the DataWindow control. |
GetValue in DataWindow Reference |
String |
Returns the specified item in the value list for the specified column. |
GroupCalc in DataWindow Reference |
Integer |
Recalculates the breaks in the groups in the DataWindow control. |
Hide in DataWindow Reference |
Integer |
Makes the control invisible. |
ImportClipboard in DataWindow Reference |
Long |
Copies data from the clipboard to the DataWindow control. |
ImportFile in DataWindow Reference |
Long |
Copies data from a file to the DataWindow control. |
ImportString in DataWindow Reference |
Long |
Copies data from a string to the DataWindow control. |
InsertDocument in DataWindow Reference |
Integer |
Inserts a rich text format or plain text file into a DataWindow control. You use a function parameter to specify how the new content is added:
This function applies only to DataWindow controls whose content has the RichText presentation style. |
InsertRow in DataWindow Reference |
Long |
Inserts a new initialized row before the specified row in the DataWindow control. |
IsSelected in DataWindow Reference |
Boolean |
Returns true if the specified row in the DataWindow is selected; returns false if the row is not selected or is greater than the number of rows in the DataWindow control. |
LineCount in DataWindow Reference |
Integer |
Determines the number of lines in an edit control that allows multiple lines. |
ModifiedCount in DataWindow Reference |
Long |
Returns the number of rows that have been modified in the DataWindow control but have not yet been updated in the associated database table. |
Modify in DataWindow Reference |
String |
Uses the specification contained in a string to modify the DataWindow control. |
Move in DataWindow Reference |
Integer |
Moves the specified DataWindow control to a specified location. |
ObjectAtPointer in DataWindow Reference |
grObjectType |
Returns the number of the series the pointer is over and the number of the data point in the graph in the DataWindow control and identifies the object type. |
OLEActivate in DataWindow Reference |
Integer |
Activates OLE for the OLE object in the specified row and column of the DataWindow control. |
Paste in DataWindow Reference |
Integer |
Inserts the contents of the clipboard into the edit control over the current row and column in the DataWindow control. |
PasteRTF in DataWindow Reference |
Long |
Pastes rich text data from a string into a DataWindow control whose content has the RichText presentation style. |
PointerX in DataWindow Reference |
Integer |
Returns the distance of the pointer from the left edge of the DataWindow control. |
PointerY in DataWindow Reference |
Integer |
Returns the distance of the pointer from the top of the DataWindow control. |
Position in DataWindow Reference |
Integer |
Syntax 1: Reports the insertion point's position in the edit control over the current row and column of the DataWindow control. Syntax 2: Reports the line and column position of the insertion point or the start and end of selected text in a DataWindow control whose content has the RichText presentation style. |
PostEvent in DataWindow Reference |
Boolean |
Adds an event to the end of the message queue for the DataWindow control. |
Print in DataWindow Reference |
Integer |
Sends the content of the DataWindow control to the current printer. This function has several syntaxes. |
PrintCancel in DataWindow Reference |
Integer |
Cancels the print job and deletes the spool file (if any) when the content of the DataWindow control is sent to print. This function has two syntaxes. Use Syntax 1 when Syntax 1 of the Print function is used to send the content of the DataWindow control to the current printer. |
ReplaceText in DataWindow Reference |
Integer |
Replaces the selected text in the edit control with the specified string. |
ReselectRow in DataWindow Reference |
Integer |
Accesses the database to reselect all columns that can be updated and refreshes all timestamp columns in a row in the DataWindow control. |
Reset in DataWindow Reference |
Integer |
Clears all the data from a DataWindow control. |
Reset in DataWindow Reference |
Integer |
Deletes the data, the categories, or the series from a graph within a DataWindow object with an external data source. |
ResetDataColors in DataWindow Reference |
Integer |
Resets the color of a data point to the color specified for the series. |
ResetTransObject in DataWindow Reference |
Integer |
Stops the DataWindow control from using a programmer-defined Transaction object (thereafter, the DataWindow uses its internal Transaction object). |
ResetUpdate in DataWindow Reference |
Integer |
Resets the update flags for the DataWindow control. |
Resize in DataWindow Reference |
Integer |
Changes the width and height of the DataWindow control. |
Retrieve in DataWindow Reference |
Long |
Retrieves rows from the database for the DataWindow control. |
RowCount in DataWindow Reference |
Long |
Returns the number of rows currently available in the DataWindow control (all the rows retrieved minus any deleted rows plus any inserted rows minus any rows that have been filtered out). |
RowsCopy in DataWindow Reference |
Integer |
Copies a range of rows from one DataWindow control to another or from one buffer to another within a single DataWindow control. |
RowsDiscard in DataWindow Reference |
Integer |
Discards a range of rows. The rows cannot be restored unless retrieved from the database. |
RowsMove in DataWindow Reference |
Integer |
Clears a range of rows from a DataWindow control and inserts the rows in another DataWindow control or another buffer of the same DataWindow control. |
SaveAs in DataWindow Reference |
Integer |
Saves the data represented in the specified graph in the DataWindow control to the specified file, in the specified format. |
SaveAs in DataWindow Reference |
Integer |
Saves the content of the DataWindow control to the specified file, in the specified format, with or without column headings at the beginning. |
SaveAsAscii in DataWindow Reference |
Long |
Saves the content of a DataWindow into a standard ASCII text file. |
Scroll in DataWindow Reference |
Integer |
Scrolls the edit control of a DataWindow control in the specified direction the specified number of lines. |
ScrollNextPage in DataWindow Reference |
Long |
Syntax 1: Scrolls forward by the number of rows showing in the DataWindow (when the DataWindow control contents does not have the RichText presentation style). Syntax 2: Scrolls to the next page of the document in a DataWindow control whose content has the RichText presentation style. |
ScrollNextRow in DataWindow Reference |
Long |
Scrolls the DataWindow control to the next row. ScrollNextRow changes the current row but not the current column. |
ScrollPriorPage in DataWindow Reference |
Long |
Syntax 1: Scrolls backward by the number of rows showing in the DataWindow (when the DataWindow control content does not have the RichText presentation style). Syntax 2: Scrolls to the prior page of the document in a DataWindow control whose content has the RichText presentation style. |
ScrollPriorRow in DataWindow Reference |
Long |
Scrolls to the previous row. The ScrollPriorRow function changes the current row in the DataWindow control but does not change the current column. |
ScrollToRow in DataWindow Reference |
Integer |
Causes the control to scroll to the specified row. ScrollToRow changes the current row in the DataWindow control but does not change the current column. |
SelectedLength in DataWindow Reference |
Integer |
Reports the total number of characters and spaces (length) in the selected text in the edit control over the current row and column. |
SelectedLine in DataWindow Reference |
Integer |
Reports the line number in the edit control over the current row and column. |
SelectedStart in DataWindow Reference |
Integer |
Reports the starting position in the edit control over the current row and column. |
SelectedText in DataWindow Reference |
String |
Reports what text (if any) is selected in the edit control over the current row and column of the DataWindow control. |
SelectRow in DataWindow Reference |
Integer |
Selects or deselects the specified row in the DataWindow control. |
SelectText in DataWindow Reference |
Integer |
Syntax 1: Selects text in the edit control of a DataWindow control (other than one whose content is in the RichText presentation style). You specify where the selection begins and how many characters to select. Syntax 2: Selects text beginning and ending at the specified line and character positions in a DataWindow control whose content is in the RichText presentation style. |
SelectTextAll in DataWindow Reference |
Integer |
Selects all the content of a DataWindow control with the RichText presentation style. |
SelectTextLine in DataWindow Reference |
Integer |
Selects the line containing the insertion point in a DataWindow control with the RichText presentation style. |
SelectTextWord in DataWindow Reference |
Integer |
Selects the word containing the insertion point in a DataWindow control with the RichText presentation style. |
SeriesCount in DataWindow Reference |
Integer |
Returns the number of series in the specified graph in the DataWindow control. |
SeriesName in DataWindow Reference |
String |
Returns the name of the specified series in the specified graph in the DataWindow control. |
SetActionCode in DataWindow Reference |
Integer |
Defines the action a DataWindow control takes following an event. Obsolete function SetActionCode is an obsolete function and will be discontinued in a future release. You now set return codes in a return statement in the event script. |
SetBorderStyle in DataWindow Reference |
Integer |
Sets the border style of the specified column in the DataWindow control. |
SetChanges in DataWindow Reference |
Long |
Applies changes captured with GetChanges to a DataWindow. This function is used primarily in distributed applications. |
SetColumn in DataWindow Reference |
Integer |
Makes the specified column the current column in the DataWindow control. |
SetDataPieExplode in DataWindow Reference |
Integer |
Explodes a pie slice in a pie graph. |
SetDataLabelling in DataWindow Reference |
Integer |
Sets the series label for a DirectX 3D graph. |
SetDataStyle in DataWindow Reference |
Integer |
For the specified data point in the specified series in the specified graph in the DataWindow control: Syntax 1: Sets the data point's color. Syntax 2: Sets the line style and width for the data point. Syntax 3: Sets the fill pattern or symbol for the data point. |
SetDataTransparency in DataWindow Reference |
Integer |
Sets the transparency percentage for a data point in a series in a DirectX 3D graph. |
SetDetailHeight in DataWindow Reference |
Integer |
Sets the height of each row in a specified range. |
SetFilter in DataWindow Reference |
Integer |
Defines the filter criteria for the DataWindow control. The actual filtering is performed by the Filter function. |
SetFocus in PowerScript Reference |
Integer |
Sets focus to the DataWindow control. |
SetFormat in DataWindow Reference |
Integer |
Sets the display format for the specified column of the DataWindow control. |
SetFullState in DataWindow Reference |
Long |
Applies the contents of a DataWindow blob retrieved by GetFullState to a DataWindow. This function is used primarily in distributed applications. |
SetHTMLAction in DataWindow Reference |
Integer |
Accepts action and context information about user interaction with the Web DataWindow client control in a Web browser so that newly generated HTML can reflect any requested changes. Obsolete function SetHTMLAction is an obsolete function, because Web DataWindow technology is obsolete. |
SetItem in DataWindow Reference |
Integer |
Sets the value of the specified row and column of the specified DataWindow control. |
SetItemStatus in DataWindow Reference |
Integer |
Sets the status of a row in a specified column of the DataWindow control in the specified buffer. |
SetPosition in DataWindow Reference |
Integer |
Syntax 1: Specifies whether the DataWindow control always displays on top in the front-to-back order within the window. Syntax 2: Moves an object within the DataWindow to another band or changes the front-to-back order of objects within a band. |
SetRedraw in DataWindow Reference |
Integer |
Controls automatic redrawing of the DataWindow control after each change in its properties or contents. |
SetRow in DataWindow Reference |
Integer |
Makes the specified row the current row in the DataWindow control. |
SetRowFocusIndicator in DataWindow Reference |
Integer |
Sets the current row indicator for the DataWindow control. |
SetSeriesLabelling in DataWindow Reference |
Integer |
Sets the series label for a DirectX 3D graph. |
SetSeriesStyle in DataWindow Reference |
Integer |
For the specified series in the specified graph in the DataWindow control: Syntax 1: Sets the series color. Syntax 2: Sets the linestyle and width. Syntax 3: Sets the fill pattern or symbol for data markers in the series. Syntax 4: Specifies that the series is an overlay. |
SetSort in DataWindow Reference |
Integer |
Defines the sort criteria for the DataWindow control. The actual sorting is performed by the Sort function. |
SetSeriesTransparency in DataWindow Reference |
Integer |
Sets the transparency percentage of a series in a DirectX 3D type graph. |
SetSQLPreview in DataWindow Reference |
Integer |
Sets the current SQL statement for the DataWindow control. |
SetSQLSelect in DataWindow Reference |
Integer |
Changes the current SELECT statement for the DataWindow control. |
SetTabOrder in DataWindow Reference |
Integer |
Changes the tab value of the specified column in the DataWindow control. |
SetText in DataWindow Reference |
Integer |
Replaces the text in the edit control at the current row and column of the DataWindow control with the specified text. |
SetTrans in DataWindow Reference |
Integer |
Sets values in the DataWindow control's internal Transaction object. |
SetTransObject in DataWindow Reference |
Integer |
Sets the Transaction object for the DataWindow control and provides control over the transaction, including the ability to commit from a script. |
SetValidate in DataWindow Reference |
Integer |
Changes the validation rule used for the specified column of the DataWindow control. |
SetValue in DataWindow Reference |
Integer |
Sets the value of the specified item in the value list or the code table of the specified column of the DataWindow control. |
SetWSObject in DataWindow Reference |
Integer |
Causes a DataWindow control to use a programmer-specified connection object. The connection object provides the information necessary for communicating with a Web service data source. |
ShareData in DataWindow Reference |
Integer |
Shares data between a primary DataWindow control and a secondary DataWindow control. |
ShareDataOff in DataWindow Reference |
Integer |
Turns off sharing for the DataWindow control. If that control is the primary DataWindow control, all secondary DataWindow controls are disconnected and their DataWindow objects no longer contain data. |
Show in DataWindow Reference |
Integer |
Makes the DataWindow control visible. |
ShowHeadFoot in DataWindow Reference |
Integer |
In a RichText presentation style DataWindow control, displays the panels for editing the header and footer or hides the panels and returns to editing the main text. |
Sort in DataWindow Reference |
Integer |
Sorts the rows of the DataWindow control based on its current sort criteria. |
TextLine in DataWindow Reference |
String |
Reports information about the edit control over the current row and column. |
TriggerEvent in DataWindow Reference |
Integer |
Triggers a specified event in the DataWindow control and executes the script for the event. |
TypeOf in DataWindow Reference |
Object |
Returns the type of the control. |
Undo in DataWindow Reference |
Integer |
Cancels the last edit in the edit control over the current row and column. |
Update in DataWindow Reference |
Integer |
Sends to the database all inserts, deletes, and updates of the DataWindow control. |