Hi to all!
I have an error with AJAX Validation, and I´m sure the problem is that the query that yii biulds is not supported by Informix (DB that I use). Becouse I test it with MySQL and works.
public function rules()
{
return [
[['wk_liq_ana_cli_liq_fecha'], 'safe'],
[['wk_liq_ana_cli_liq_estado'], 'string', 'max' => 1],
['wk_liq_ana_cli_liq_fecha', 'unique']
];
}
<?php $form = ActiveForm::begin(['id' => 'liquidacion-form',
'enableClientValidation' => true,
'enableAjaxValidation' => true
]); ?>
<div class="well well-sm" style="background-color: #fff; width:245px">
<?= $form->field($model, 'wk_liq_ana_cli_liq_fecha') -> widget(DatePicker::className(),[
'name' => 'check_issue_date',
'value' => date('d-mm-yyyy', strtotime('+0 days')),
'type' => DatePicker::TYPE_INLINE,
'options' => ['placeholder' => 'Seleccione una fecha...'],
'pluginOptions' => [
'autoclose' => true,
'format' => 'dd-mm-yyyy',
'startView' => "year",
'todayHighlight' => true
]
]); ?>
</div>
public function actionCreate()
{
$model = new Liquidacion();
$model -> wk_liq_ana_cli_liq_estado = 'V';
if(Yii::$app->request->isAjax && $model->load(Yii::$app->request->post())) {
Yii::$app->response->format = Response::FORMAT_JSON;
return ActiveForm::validate($model);
}
if ($model->load(Yii::$app->request->post()) && $model->save()) {
LaboratorioController::nuevoLaboratorioAlfa($model -> wk_liq_ana_cli_liq_id);
LaboratorioController::nuevoLaboratorioBianchi($model -> wk_liq_ana_cli_liq_id);
LaboratorioController::nuevoLaboratorioDiez($model -> wk_liq_ana_cli_liq_id);
return $this->redirect(['index']);
} else {
return $this->renderAjax('create', [
'model' => $model,
]);
}
}
Anyone has a solution for that?
"SQLSTATE[42000]: Syntax error or access violation: -201 [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. (SQLPrepare[-201] at /software/PDO_INFORMIX-1.3.1/informix_driver.c:131)↵Failed to prepare SQL: SELECT EXISTS(SELECT * FROM wk_liq_analisis_clinicos_liquidacion WHERE wk_liq_ana_cli_liq_fecha=:qp0)"