GetItemNumber – PB Docs 126

GetItemNumber method (DataWindows)


Gets numeric data from the specified buffer of a DataWindow
control or DataStore object. You can obtain the data that was originally
retrieved and stored in the database from the original buffer, as
well as the current value in the primary, delete, or filter buffers.

note.png Separate method names for the Web DataWindow server

Separate method names, GetItemNumberEx, GetItemNumberByColNumEx, and GetItemNumberByColNum,
are provided as alternative syntaxes for the Web DataWindow server
component, which cannot use overloaded methods.


DataWindow type

Method applies to


DataWindow control, DataWindowChild object, DataStore


Server component

Web ActiveX

DataWindow control, DataWindowChild object



[Web DataWindow server component]

[Web ActiveX]




A reference to a DataWindow control,
DataStore, or child DataWindow.


A value identifying the row location
of the numeric data.


The column location of the numeric data.
The datatype of the column must be one of a numeric datatype. Column can be
a column number or a column name. The column number is the number
of the column as it is listed in the Column Specification view of
the DataWindow painter—not necessarily
the number of the column in the Design view.

To get the contents of a computed field, specify the name
of the computed field for column. Computed
fields do not have numbers.


A value identifying the DataWindow buffer
from which you want to get the data. For a list of valid values,
see DWBuffer.

originalvalue (optional)

A boolean indicating whether you want
the original or current values for row and column:

  • True – Return
    the original values (the values initially retrieved from the database).

  • False – (Default) Return
    the current values.

If you specify dwbuffer, you must also
specify originalvalue.

Return Values

Returns the numeric value in the specified row and column
(decimal, double, integer, long, or real). Returns null if the column
value is null or if there is no DataWindow object assigned to the
DataWindow control or DataStore. Triggers the SystemError event
and returns –1 if any other error occurs (see “Handling errors”).

If any argument value is null, in PowerBuilder and JavaScript
the method returns null.


Use GetItemNumber to get information from
the DataWindow’s buffers. To find out what the user entered
in the current column before that data is accepted, use GetText.
In the ItemChanged or ItemError events, use the data argument.

To access a row in the original buffer, specify the buffer
that the row currently occupies (primary, delete, or filter) and
the number of the row in that buffer. When you specify true for originalvalue,
the method gets the original data for that row from the original

Handling errors

The return value is a valid value from the database unless
the SystemError event is triggered. When the value cannot be converted
because the column’s datatype does not match the method’s datatype,
an execution error occurs, which triggers the SystemError event. The
default error processing halts the application. If you write a script
for the SystemError event, it should also halt the application.
Therefore, the error return value is seldom used.


These statements set EmpNbr to the current numeric
data in the primary buffer for row 4 of the column named emp_nbr
in dw_employee:

These statements set EmpNbr to the current numeric
data in the filter buffer for row 4 of the column named salary of

These statements set EmpNbr to the original numeric
data in the primary buffer for row 4 of the column named salary
of dw_Employee:

See Also

Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x