Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

GetItemDecimal – PB Docs 2019 – PowerBuilder Library

GetItemDecimal – PB Docs 2019

GetItemDecimal

method (DataWindows)

Description

Gets data whose type is decimal 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.

Applies to

DataWindow type

Method applies to

PowerBuilder

DataWindow control, DataWindowChild object, DataStore
object

Syntax

PowerBuilder

Argument

Description

dwcontrol

A reference to a DataWindow control or
DataStore.

row

A value identifying the row location of the decimal
data.

column

The column location of the data. The datatype of the
column must be one of type decimal. 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
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, that is, the
    values initially retrieved from the database.

  • False — (Default) Returns the current values.

If you specify dwbuffer, you must also
specify originalvalue.

Return value

Returns the decimal value in the specified row and column. 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, the method returns null.

Usage

Use GetItemDecimal when you want 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 buffer.

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.

Examples

These statements set salary_amt to the current decimal data in the
primary buffer for row 4 of the column named emp_salary of
dw_employee:

These statements set salary_amt to the current decimal data in the
filter buffer for row 4 of the column named emp_salary of
dw_employee:

These statements set salary_amt to the original decimal data in the
primary buffer for row 4 of the column named emp_salary of
dw_employee:

See also

GetItemDate

GetItemDateTime

GetItemNumber

GetItemString

GetItemTime

SetItem


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x