constraint failed virutalquery

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,