GetItemStatus
method (DataWindows)
Description
Reports the modification status of a row or a column within a row.
The modification status determines the type of SQL statement the Update
method will generate for the row or column.
Applies to
|
DataWindow type |
Method applies to |
|---|---|
|
PowerBuilder |
DataWindow control, DataWindowChild object, DataStore |
Syntax
PowerBuilder
|
1 2 |
DWItemStatus dwcontrol.GetItemStatus ( long row, integer column, DWBuffer dwbuffer ) DWItemStatus dwcontrol.GetItemStatus ( long row, string column, DWBuffer dwbuffer ) |
|
Argument |
Description |
|---|---|
|
dwcontrol |
A reference to a DataWindow control, DataStore, or |
|
row |
A value identifying the row for which you want the |
|
column |
The column for which you want the status. Column can Specify 0 to get the |
|
dwbuffer |
A value identifying the DataWindow buffer containing |
Return value
A value of the dwItemStatus enumerated datatype. The return value
identifies the status of the item at row, column of dwcontrol in dwbuffer.
For a list of status values, see DWItemStatus.
If column is 0, GetItemStatus returns the status of row. If there is
no DataWindow object assigned to the DataWindow control or DataStore,
GetItemStatus returns null.
If any argument value is null, in PowerBuilder and JavaScript the
method returns null.
Usage
Use GetItemStatus to understand what SQL statements will be
generated for new and changed information when you update the
database.
For rows in the primary and filter buffers, Update generates an
INSERT statement for rows with NewModified! status. It generates an UPDATE
statement for rows with DataModified! status and references the columns
that have been affected.
For rows in the delete buffer, Update does not generate a DELETE
statement for rows whose status was New! or NewModified! before being
moved to the delete buffer.
Examples
These statements store in the variable l_status the status of the
column named emp_status in row 5 in the filter buffer of dw_1:
|
1 2 3 |
dwItemStatus l_status l_status = dw_1.GetItemStatus(5, "emp_status", & Filter!) |
These statements store in the variable l_status the status of the
column named Salary in the current row in the primary buffer of
dw_emp:
|
1 2 3 |
dwItemStatus l_status l_status = dw_emp.GetItemStatus( & dw_emp.GetRow(), "Salary", Primary!) |
See also