OCIDefineDateByPos

Home

4D v19

OCIDefineDateByPos


OCIDefineDateByPos ( stmtp ; defnnpp ; errhp ; position ; valuep ; valuep2 ; dty ; indp ; rlenp ; rcodep ; mode ) -> Function result

Parameter	Type	Description
stmtp	Longint	Handle to requested SQL query operation

defnnpp	Longint	Define handle

errhp	Longint	Error handle

position	Longint	Position of value in list
valuep	Pointer	Buffer(s) of type specified in dty parameter

valuep2	Pointer	Buffer(s) of type specified in dty parameter

dty	Longint	Datatype
indp	Pointer	Indicator variable or array
rlenp	Pointer	Array of length of data fetched

rcodep	Pointer	Array of column-level return codes
mode	Longint	Specifies mode of operation
Function result	Longint	Status

Description

Please refer to the OCIDefineDateByPos command in the OCI documentation provided by Oracle for more information.

Note: The OCIDefineDateByPos command is similar to the OCIDefineByPos command except that there is an additional valuep2 parameter to adapt it for working with Oracle columns of the TIMESTAMP type. For this command, the valuep parameter is a pointer to a date (C_DATE) and valuep2 is a pointer to a time (C_TIME). When both parameters are used, the command takes the date (day/month/year) from the valuep parameter and the time (hour:minute:second) from the valuep2 parameter.

Example

See the example for Working with Oracle Date types.