I have been trying to validate a date when is empty before send it to the db but always is generated as ‘’, i even try with a default 1900-01-01 date, but the attach-event never fire up i also tried to use an updated conector from another post but it give an license error, i have a 3.0 license so can’t see what is the error here, can anyone help me to catch the error.
[code]<?php
require_once(“…/…/codebase/connector/config.php”);
require_once("../../codebase/connector/dataprocessor.php");
require("../../codebase/connector/form_connector.php");
require("../../codebase/connector/db_postgre.php");
$res=pg_connect($postrgre_connection);
$formConn = new FormConnector($res,"Postgre");
$formConn->enable_log("../../logs/logs.txt",true);
$formConn->set_encoding("iso-8859-1");
function myIUpdate($action) {
$fecha_fundacion = $action->get_value("fecha_fundacion");
if( $action->get_value("fecha_fundacion") == "" || $action->get_value("fecha_fundacion") == 0){
$action->set_value("fecha_fundacion",NULL);
}
//$action->set_value("fecha_fundacion","1900-01-01");
}
$formConn->event->attach("beforeProcessing","myIUpdate");
$formConn->render_table("public.clientescredito","cuentacredito","cuenta_activa,cuentacredito,codigocliente,nombre_comercial,nombre_legal,representante_legal_contactoid,fecha_fundacion,rtn,subsectorid,sitioweb,estimado_compra_anual,limite_credito_solicitado,credito_habilitado,limite_credito_autorizado,dias_credito,dias_tiempo_gracia_saldos_vencidos,tipoentrega,sucursal_cuenta");
?>[/code]