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.
Separate method names for the Web DataWindow servercomponent
Separate method names, GetItemTimeByColNum, GetItemTimeByColNumEx,
and GetItemTimeEx are provided as alternative syntaxes
for the Web DataWindow server component, which cannot use overloaded
methods.
Controls
|
DataWindow type |
Method applies to |
|---|---|
|
PowerBuilder |
DataWindow control, DataWindowChild object, DataStore |
|
Web |
Server component |
Syntax
[PowerBuilder]
|
1 |
time <span>dwcontrol</span>.<span>GetItemTime</span> ( long <span>row</span>, string <span>column</span> <br> {, DWBuffer <span>dwbuffer</span>, boolean <span>originalvalue</span> } )<br>time <span>dwcontrol</span>.<span>GetItemTime</span> ( long <span>row</span>, integer <span>column</span> <br> {, DWBuffer<span> dwbuffer</span>, boolean <span>originalvalue</span> } ) |
[Web DataWindow server component]
|
1 |
string <span>dwcontrol</span>.<span>GetItemTime</span> ( long <span>row</span>, string <span>column</span> )<br>string <span>dwcontrol</span>.<span>GetItemTimeByColNum</span> ( long <span>row</span>, short <span>column</span> )<br>string <span>dwcontrol</span>.<span>GetItemTimeByColNumEx</span> ( long <span>row</span>, short <span>column</span>,<br> string <span>dwbuffer</span>, boolean <span>originalvalue</span> )<br>string <span>dwcontrol</span>.<span>GetItemTimeEx</span> ( long <span>row</span>, string <span>column</span>, <br> string <span>dwbuffer</span>, boolean <span>originalvalue</span> ) |
|
Argument |
Description |
|---|---|
|
dwcontrol |
A reference to a DataWindow control, |
|
row |
A value identifying the row location |
|
column |
The column location of the data. The To get the contents of a computed field, specify the name |
|
dwbuffer (optional) |
A value of the dwBuffer enumerated datatype |
|
originalvalue (optional) |
A boolean indicating whether you want
If you specify dwbuffer, you must also |
Return Values
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”:
|
1 |
String(dw_1.GetItemTime(1, "start_date")) |
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:
|
1 |
Time Start |
|
1 |
Start = dw_employee.<span>GetItemTime</span>(3, "title") |
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:
|
1 |
Time Start |
|
1 |
Start = dw_employee.<span>GetItemTime</span>(3, & |
|
1 |
"start_time", Filter!, false) |
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:
|
1 |
Time Start |
|
1 |
Start = dw_employee.<span>GetItemTime</span>(3, & |
|
1 |
"start_time", Primary!, true) |