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

GetItemTime – PB Docs 2017 – PowerBuilder Library

GetItemTime – PB Docs 2017

GetItemTime

method (DataWindows)

Description

Gets data whose type is Time 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, DataStore, or
child DataWindow.

row

A value identifying the row location of the
data.

column

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

Returns the time 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. Returns 00:00:00.000000 if an
error occurs.

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

Usage

Use GetItemTime 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.

Datatypes of columns and computed fields

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

There is a difference in datatypes between computed columns
retrieved from the database and computed fields defined in the
DataWindow painter. Computed columns from the database can have a
datatype of time, but a time computed field always has a datatype of
DateTime, not time. Use the GetItemDateTime method instead.

PowerBuilder only: using GetItemTime in a String function

When you call GetItemTime as an argument for the String function
and do not specify a display format, the value is formatted as a
DateTime value. This statement returns a string like “2/26/06
00:00:00”:

To get a simple time string, you can specify a display format for
the String function or you can assign the value to a time variable
before calling the String function (see GetItemDate for examples).

Examples

These statements set Start to the current Time data in the primary
buffer for row 3 of the column named title in dw_employee:

These statements set Start to the current Time data in the filter
buffer for row 3 of the column named start_time of dw_employee:

These statements set Start to the original Time data in the primary
buffer for row 3 of the column named start_time of dw_employee:

See also

GetItemDate

GetItemDateTime

GetItemDecimal

GetItemNumber

GetItemString

GetText

SetItem

SetText


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