adoquery1.SQL.Add('SELECT A.code_article, A.libelle_long, A.code_modele, P.prix_courant, R.libelle_rayon, F.libelle_famille');
adoquery1.SQL.Add('FROM Article A, Prix_courant P, Rayon R,Famille F');
adoquery1.SQL.Add('WHERE A.code_article = P.code_article');
adoquery1.SQL.Add('AND A.circuitapproaffiche = ''S''');
adoquery1.SQL.Add('AND A.status_article = ''AC''');
adoquery1.SQL.Add('AND A.code_rayon = R.code_rayon');
adoquery1.SQL.Add('AND A.code_rayon = F.code_rayon');
adoquery1.SQL.Add('AND A.code_famille = F.code_famille');
if combobox1.Text <> '' then
adoquery1.SQL.Add('AND R.libelle_rayon = '+QuotedStr(combobox1.text+'%'));
if combobox2.Text <> '' then
adoquery1.SQL.Add('AND F.libelle_famille = '+QuotedStr(combobox2.text+'%'));
adoquery1.SQL.Add('AND A.libelle_long = '+QuotedStr(edit3.Text+'%'));
adoquery1.SQL.Add('AND A.libelle_long = %'+QuotedStr(edit2.Text+'%'));
adoquery1.SQL.Add('ORDER BY '+colonne+' '+sens);
ADOQuery1.Open;
Partager