OCIDefineDateByPos

4D v16

OCIDefineDateByPos


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

Paramètre	Type	Description
stmtp	Entier long	Handle to requested SQL query operation

defnnpp	Entier long	Define handle

errhp	Entier long	Error handle

position	Entier long	Position of value in list
valuep	Pointeur	Buffer(s) of type specified in dty parameter

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

dty	Entier long	Datatype
indp	Pointeur	Indicator variable or array
rlenp	Pointeur	Array of length of data fetched

rcodep	Pointeur	Array of column-level return codes
mode	Entier long	Specifies mode of operation
Résultat	Entier long	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.

Exemple

See the example for Working with Oracle Date types.