GetItemString – PB Docs 126

GetItemString method (DataWindows)


Gets data whose type is String 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, GetItemStringEx, GetItemStringByColNumEx,
and GetItemStringByColNum, 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 string data.


The column location of the data. The
datatype of the column must be String. 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.

dwbuffer (optional)

A value of the dwBuffer enumerated datatype
(PowerBuilder) or an integer (Web ActiveX) or a string (Web DataWindow) 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 – Returns
    the original values (the values initially retrieved from the database).

  • False – (Default) Returns
    the current values.

If you specify dwbuffer, you must also
specify originalvalue.

Return Values

Returns the string value in the specified row and column.
Returns the empty string (” “) if there is no
DataWindow object assigned to the DataWindow control or DataStore
or if any other error occurs.

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


Use GetItemString 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

GetItemString returns a formatted value
in the case of a computed column, and an unformatted value in the
case of a noncomputed column. For PowerBuilder DataWindows, you
can use the GetItemFormattedString method to
return a formatted value, or the GetItemUnformattedString method
to return an unformatted value, for any type of column.

note.png Mismatched datatypes

An execution error occurs when the datatype of the DataWindow
column does not match the datatype of the method—in this
case, String.


These statements set LName to the current string
in the primary buffer for row 3 of the column named emp_name
in the DataWindow dw_employee:

These statements set LName to the current string
in the delete buffer for row 3 of the column named emp_name
of dw_employee:

The following statements set LName to the original
string in the delete buffer for row 3 of the column named emp_name
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