DF_FIELD_TIME_ON¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
Assign a field to retrieve Time Stamp value from a DATETIME column in a table.
This option was implemented because some versions of DataFlex do not support DATETIME fields normally supported by SQL databases.
To use this: Change the type of a date field in your FD to string type, Set the attribute DF_FIELD_TIME_ON of this field to TRUE and recompile your program.
Syntax
Set_Attribute DF_FIELD_TIME_ON of <FileNumber|FileName FieldNumber> to DFTRUE | DFFALSE
Parameter |
Description |
|---|---|
FileNumber |
Number of the file |
FileName |
Name of the file |
FieldNumber |
Number of the field |
Example
#INCLUDE MERTECH.INC
string sDateTime sDatabaseName
open ORDERHEA
Set_Attribute DF_FIELD_TIME_ON of 30 3 to dfTrue
find GE ORDERHEA by recnum
move ORDERHEA.ORDER_DATE to sDateTime
showln "sDateTime: " sDateTime