Back

Editing, Updating and Creating Records
saveOptions
Additional save options when editing or creating records NEW $lens->saveOptions = "NEW", a new icon is displayed when editing, allowing you to create new records from the edit form. DELETE $lens->saveOptions = "DELETE", a delete icon is displayed when editing, allowing to delete the current record. HIDETOPBTNS $lens->saveOptions = "HIDETOPBTNS", will hide the Save and Cancel buttons that appear at the top of the form. SAMEROW1COLOR $lens->saveOptions="SAMEROW1COLOR", and if the sameRowLens property is used to force two fields in the edit/new form to share the same row, then the title caption background of the 2nd field are also colored with the detailColor. This makes the color scheme simpler. OCISEQUENCE $lens->saveOptions = "OCISEQUENCE^seqname" allows you to name the oracle sequence you are using within a trigger to set the integer serial id column of the table. The following feature is experimental, and not supported: $lens->saveOptions = "COLLECTIONS" will cause all checkbox/multi-select fields to be mirrored in another table. For example, if $lens->keyTable = 'master', then the mirroring table will be called "master_collection", and the fields of the table will be all fields that allow multiple values to be entered, plus the column containing the primary key. From 3.3.2 onwards, you can define the table to save in, eg. $lens->saveOptions = "COLLECTIONS^NameOfTable" Syntax `#All saveOptions can be combined, eg. $lens->saveOptions = 'NEW;DELETE;OCISEQUENCE^seqgeneral';` Basic:Yes Advanced/Enterprise:Yes DynamicEdit:No [Version 3.1]