constraint failed virutalquery
Hi,
With the code below :
//---- Ouverture de la tables des paramètres (L_PARAM_AS is a TUniTable component on L_PARAM_AS table in attach file)
L_PARAM_AS.Open;
//---- RequeteParametreDispo is a TVirtualQuery with L_PARAM_AS in source dataset
RequeteParametreDispo.Sql.Text := 'SELECT CODE,LIB_LONG,SUBENTREE,SUBSORTIE,FAMILLE,SUBSTANCES,SUBDOM' + ',S971,S972,S973,S974 FROM L_PARAM_AS WHERE (FAMILLE <> ''HAP'') AND (FAMILLE <> ''HAP 1'') AND (SUBSTANCES <> '''') AND (STATUT <> ''Gelé'')';
RequeteParametreDispo.Open; //---- Error here "constraint failed"
The error occur in Oracle (23) et Postgres (16.2), I use Deplhi XE8 en unidac 10.1, It was working with previous version of unidac
Regards,