 |
 |
|
|
       |
|||
|
||||||||||
|
|
||||||||||
| Other Library Functions | ||||||||||
| function | dbFieldValue |
|
Library: omdb - high level database access
Include: omdb.xin |
Return type: String Returns: Requested field data as a source. |
define external source function dbFieldValue
value dbField field
null value stream null optional
Where:
field
null
The dbFieldValue function returns the requested field data as a source. An exception is raised if you attempt to retrieve a field value when the data cursor is not positioned on an existing row. To avoid this exception, use the dbRecordExists function to verify that the row exists prior to retrieving a field value.
Date and time fields
If the record has a date, time, or timestamp field, the field's value will be formatted in the OmniMark Date and Time library format. (This format returns the time with a time zone offset from UTC time, which most databases do not provide.)
If the field value is NULL, this function returns either an empty string or a string you specify within the function call. For example:
repeat
exit unless dbRecordExists my-query
repeat over my-query
output dbFieldValue my-query null '-dnf-'
output '%t' when ! #last
again
output '%n'
dbRecordMove my-query
again
| ---- |
