Back

Programming
forceType
Change the type of a column This is useful for changing datetime/timestamp columns to type date, or logical to integer. We use the ADODB type codes. If a number or integer is forced to date or timestamp, then we assume that the number is a Unix timestamp. C: character and varchar types X: text or long character (eg. more than 255 bytes wide). B: blob or binary image D: date T: timestamp L: logical (boolean) I: integer J: positive integer (>= 0) N: numeric (float, double, money) P: positive numeric (>= 0.0) Note that we do not modify the field types in your database. This property is for display and data entry type checking purposes only. Syntax `# change col1 to type 'D' for date $lens->forceType = 'col1^D';` Basic:No Advanced/Enterprise:Yes DynamicEdit:No [Version 1.3]