DataWindowChild object

A DataWindowChild object is a nested report or a DropDownDataWindow
within a DataWindow object. For example, a DataWindow object that
populates a column having the DropDownDataWindow edit style is a
DataWindowChild object.

The DataWindowChild object is used for accessing DataWindow objects
independently from DataWindow functionality, and it inherits from the
system Structure object because it needs storage and
autoinstantiation.

A DataWindowChild object has no events.

Obsolete functions

Several DataWindowChild functions are described as obsolete, which
means that although the functions operate as usual in this release, they
will be removed in a future release. You should replace all use of these
functions as soon as possible.

Properties

DataWindowChild property	Datatype	Description
ClassDefinition	PowerObject	An object of type PowerObject containing information about the class definition of the object or control.

Functions

DataWindowChild function	Datatype returned	Description
AcceptText	Integer	Applies the contents of the edit control to the current item in the DataWindowChild buffer.
ClassName	String	Returns the name assigned to the DataWindowChild.
ClearValues	String	Deletes all the items from a value list or code table associated with a DataWindow column.
CrosstabDialog	Integer	Displays the Crosstab Definition dialog box so that the user can modify the definition of a crosstab DataWindow object during execution.
DBCancel	Integer	Cancels a database retrieval in progress.
DBErrorCode	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	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	Long	Returns the number of rows that have been deleted from the DataWindowChild but have not yet been updated in the associated database table.
DeleteRow	Integer	Deletes the specified row from the DataWindowChild.
Describe	String	Returns requested information about the structure of the DataWindowChild.
ExportJson	String	Exports data from the DataWindow control, DataStore object, or DataWindowChild object to the JSON string.
ExportRowAsJson	String	Exports a data row from the DataWindow control, DataStore object, or DataWindowChild object to the JSON string.
Filter	Integer	Displays specific rows of the DataWindowChild based on its current filter.
FilteredCount	Integer	Returns the number of rows that are not visible because of the DataWindowChild’s current filter.
Find	Long	Returns the number of the first row that meets the search criteria within a specified search range in the detail area of a DataWindowChild.
FindGroupChange	Long	Searches starting at a specified row for the first break for the specified group in the DataWindowChild.
GetBandAtPointer	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	Border (enumerated)	Returns a Border enumerated datatype indicating the border style of the specified column in the DataWindowChild. Values are: Box! Lowered! NoBorder! Raised! ResizeBorder! ShadowBox! Underline!
GetChanges	Long	Retrieves changes made to a DataWindow into a blob. This function is used primarily in distributed applications.
GetChild	Integer	Provides a reference to a child DataWindow or to a report in a composite DataWindow, which you can use in DataWindow functions to manipulate that DataWindow or report.
GetClickedColumn	Integer	Returns the number of the column in the DataWindowChild that the user clicked or double-clicked.
GetClickedRow	Long	Returns the number of the row in the DataWindowChild that the user clicked or double-clicked.
GetColumn	Integer	Returns the number of the current column in the DataWindowChild.
GetColumnName	String	Returns the name of the current column in the DataWindowChild.
GetContextService	Integer	Creates a reference to a context-specific instance of the specified service.
GetFormat	String	Returns the format used for display in the specified column of the DataWindowChild.
GetItemDate	Date	Returns the date data in the specified row and column of the DataWindowChild.
GetItemDateTime	DateTime	Returns the datetime data in the specified row and column of the DataWindowChild.
GetItemDecimal	Decimal	Returns the decimal data in the specified row and column of the DataWindowChild.
GetItemNumber	Double	Returns the numeric data in the specified row and column of the DataWindowChild.
GetItemStatus	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	String	Returns the string data in the specified row and column of the DataWindowChild.
GetItemTime	Time	Returns the time data in the specified row and column of the DataWindowChild.
GetNextModified	Long	Returns the number of the first row that was modified in the specified buffer in the specified DataWindowChild after the specified row.
GetObjectAtPointer	String	Returns the string containing the name of the DataWindowChild column or graphic control under the pointer in the DataWindowChild, then a tab character (~t), and then the row number.
GetParent	PowerObject	Returns a reference to the name of the parent object.
GetRow	Long	Returns an integer containing the number of the current row in the DataWindowChild.
GetRowFromRowId	Long	Gets the row number of a row in a DataWindow control from the unique row identifier associated with that row.
GetRowIdFromRow	Long	Gets the unique row identifier of a row in a DataWindow control from the row number associated with that row.
GetSelectedRow	Integer	Returns the number of the first selected row after the specified row number in the DataWindowChild.
GetSQLPreview	String	Returns the current SQL statement the DataWindowChild 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	String	Returns the current SELECT statement for the DataWindowChild.
GetText	String	Returns the text in the edit control over the current row and column of the DataWindowChild.
GetTrans	Integer	Returns the values in the DataWindowChild Transaction object.
GetUpdateStatus	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 DBError and SQLPreview events.
GetValidate	String	Returns the validation rule used in the specified column of the DataWindowChild.
GetValue	String	Returns the specified item in the value list for the specified column.
GroupCalc	Integer	Recalculates the breaks in the groups in the DataWindowChild.
ImportClipboard	Long	Copies data from the clipboard to the DataWindowChild.
ImportFile	Long	Copies data from a file to the DataWindowChild.
ImportJson	Long	Inserts data from a JSON string into the DataWindowChild.
ImportJsonByKey	Long	Inserts data from a JSON string into the DataWindowChild according to the JSON key name.
ImportRowFromJson	Long	Inserts a data row from a JSON string into a DataWindow control, DataStore object, or DataWindowChild object.
ImportString	Long	Copies data from a string to the DataWindowChild.
InsertRow	Long	Inserts a new initialized row before the specified row in the DataWindowChild.
IsSelected	Boolean	Returns true if the specified row in the DataWindowChild is selected; returns false if the row is not selected or is greater than the number of rows in the DataWindowChild.
ModifiedCount	Long	Returns the number of rows that have been modified in the DataWindowChild but have not yet been updated in the associated database table.
Modify	String	Uses the specification contained in a string to modify the DataWindowChild.
OLEActivate	Integer	Activates OLE for the OLE object in the specified row and column of the DataWindowChild.
ReselectRow	Integer	Accesses the database to reselect all columns that can be updated and refreshes all timestamp columns in a row in the DataWindowChild.
Reset	Integer	Clears all the data from a DataWindowChild.
ResetTransObject	Integer	Stops the DataWindowChild from using a programmer-defined Transaction object (thereafter, the DataWindow uses its internal Transaction object).
ResetUpdate	Integer	Resets the update flags for the DataWindowChild.
Retrieve	Long	Causes the DataWindowChild to retrieve rows from the database.
RowCount	Long	Returns the number of rows currently available in the DataWindowChild (all the rows retrieved minus any deleted rows plus any inserted rows minus any rows that have been filtered out).
RowsCopy	Integer	Copies a range of rows from one DataWindowChild to another or from one buffer to another within a single DataWindowChild.
RowsDiscard	Integer	Discards a range of rows. The rows cannot be restored unless retrieved from the database.
RowsMove	Integer	Clears a range of rows from a DataWindowChild and inserts the rows in another DataWindowChild or another buffer of the same DataWindowChild.
SaveAs	Integer	Saves the contents of the DataWindowChild control to the specified file, in the specified format, with or without column headings at the beginning.
SaveNativePDFToBlob	Integer	Saves the PDF file into a blob variable when you use the PDFlib method to save data from a DataWindow object to a PDF file.
ScrollNextPage	Long	Scrolls forward by the number of rows showing in the DataWindowChild.
ScrollNextRow	Long	Scrolls the DataWindowChild to the next row. ScrollNextRow changes the current row but does not change the current column.
ScrollPriorPage	Long	Scrolls backward by the number of rows showing in the DataWindowChild.
ScrollPriorRow	Long	Scrolls to the previous row. The ScrollPriorRow function changes the current row in the DataWindowChild but does not change the current column.
ScrollToRow	Integer	Causes the control to scroll to the specified row. ScrollToRow changes the current row in the DataWindowChild but does not change the current column.
SelectRow	Integer	Selects or deselects the specified row of the DataWindowChild.
SetBorderStyle	Integer	Sets the border style of the specified column in the DataWindowChild.
SetChanges	Long	Applies changes captured with GetChanges to a DataWindow. This function is used primarily in distributed applications.
SetColumn	Integer	Makes the specified column the current column in the DataWindowChild.
SetDetailHeight	Integer	Sets the height of each row in a specified range.
SetFilter	Integer	Defines the filter criteria for the DataWindowChild. The actual filtering is performed by the Filter function.
SetFormat	Integer	Sets the display format for the specified column of the DataWindowChild.
SetItem	Integer	Sets the value of the specified row and column of the specified DataWindowChild.
SetItemStatus	Integer	Sets the status of a row in a specified column of the DataWindowChild in the specified buffer.
SetPosition	Integer	Moves an object within the DataWindowChild to another band or changes the front-to-back order of objects within a band.
SetRedraw	Integer	Controls automatic redrawing of the DataWindowChild after each change in its properties or contents.
SetRow	Integer	Makes the specified row the current row in the DataWindowChild.
SetRowFocusIndicator	Integer	Sets the current row indicator for the DataWindowChild.
SetSort	Integer	Defines the sort criteria for the DataWindowChild. The actual sorting is performed by the Sort function.
SetSQLPreview	Integer	Sets the current SQL statement for the DataWindowChild.
SetSQLSelect	Integer	Changes the current SELECT statement for the DataWindowChild.
SetTabOrder	Integer	Changes the tab value of the specified column in the DataWindowChild.
SetText	Integer	Replaces the text in the edit control at the current row and column of the DataWindowChild with the specified text.
SetTrans	Integer	Sets values in the DataWindowChild’s internal Transaction object.
SetTransObject	Integer	Sets the Transaction object for the DataWindowChild and provides control over the transaction, including the ability to commit from a script.
SetValidate	Integer	Changes the validation rule used for the specified column of the DataWindowChild.
SetValue	Integer	Sets the value of the specified item in the value list or the code table of the specified column of the DataWindowChild.
SetWSObject	Integer	Causes a DataWindowChild to use a programmer-specified connection object. The connection object provides the information necessary for communicating with a Web service data source.
ShareData	Integer	Shares data between a primary DataWindowChild and a secondary DataWindowChild.
ShareDataOff	Integer	Turns off sharing for the DataWindowChild. If that object is the primary DataWindowChild, all secondary DataWindowChild objects are disconnected and their DataWindow objects no longer contain data.
Sort	Integer	Sorts the rows of the DataWindowChild based on its current sort criteria.
TypeOf	Object	Returns the type of the control.
Update	Integer	Sends to the database all inserts, deletes, and updates of the DataWindowChild.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2021

August 21, 2023

Was this article helpful?

Connection Information

DataWindowChild object – PB Docs 2021