OCIDefineDateByPos

4D v16

OCIDefineDateByPos


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

Parámetro	Tipo	Descripción
stmtp	Entero largo	Handle to requested SQL query operation

defnnpp	Entero largo	Define handle

errhp	Entero largo	Error handle

position	Entero largo	Position of value in list
valuep	Puntero	Buffer(s) of type specified in dty parameter

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

dty	Entero largo	Datatype
indp	Puntero	Indicator variable or array
rlenp	Puntero	Array of length of data fetched

rcodep	Puntero	Array of column-level return codes
mode	Entero largo	Specifies mode of operation
Resultado	Entero largo	Status

Descripción

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.

Ejemplo

See the example for Working with Oracle Date types.