Back

Editing, Updating and Creating Records
toUpper
Convert all strings in text boxes to uppercase (when saving and searching) Default: `false` Useful for databases that require fields to be in uppercase for indexing purposes such as Oracle. Fields that are longer than 64 chars long are not converted to uppercase. Text entered in search screens is also uppercased. You can change this 64 character setting in phplens/adodb/adodb-recordset.inc.php, class ADORecordSet->blobSize property. Also see upperCase. In the most general case, you need to set $lens->upperCase = true; $lens->toUpper = true; because when you have COL = 'somevalue', you need to uppercase both sides like this: UPPER(COL) = UPPER('somevalue') Now upperCase does this for the left hand side(COL) and toUpper does it for the right hand side ('somevalue'). Basic:No Advanced/Enterprise:Yes DynamicEdit:No [Version 1.0]