Back

Editing, Updating and Creating Records
eventPreInsertField
Name of function to call before every field is processed for new records This function should have 3 parameters. $colname is the field name, &$data is the data and $type is the ADODB data type (not the native type). For $data, dates are passed as strings in 'Y-m-d h:i:s' format, eg. 4pm 23rd February 2002 is '2002-02-23 16:00:00'. Strings are passed without quoting. Do not quote strings yourself because phpLens does it for you. For $type, legal values are X (long text), B (blob/image), D (date), T (timestamp), C (char), N (numeric), I (integer). See ADODB readme.htm documentation. Return a value of -2 to cancel the insert, show the New Record form, and clear all fields -1 to skip this field when inserting, 0 to cancel the insert, show the New Record form, leaving all fields unchanged 1 to continue inserting. There is no eventPostInsertField property. ### Example `//I want to cancel the insert if one //specific column has one specific value... $lens->eventPreInsertField = 'CheckField'; // return -1 = skip processing this field // return 0 = cancel INSERT sql // return 1 = process this field and continue INSERT sql function CheckField($colname, $data, $type) { // $colname is uppercase if ($colname == 'FIELDTOCANCEL' and $data == 'datatocancel') return 0; // cancel return 1; // normal }` Basic:No Advanced/Enterprise:Yes DynamicEdit:No [Version 1.0]