1 2 3 4 5 6 7
| ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("insert into venteterrain(reference,adressebien,...........,section,superficie) values('klmkjml','kmjklm',..................'ipiop',70)");
ADOQuery1->SQL->Add("insert into venteterrain(prixm2,superficie_mor,prixm2_mor,.............,repere,conseil_jur,conseil_tec) values(70,70,70,...............,'','')");//les champs conseil_jur,conseil_tec sont des Mémo
ADOQuery1->SQL->Add("insert into venteterrain(prestation,plat_p,..................,voisinage_nb,limitation_nb,autres_nb) values('','',..............,50,50,50)");//le premier champ est un Mémo
ADOQuery1->SQL->Add("insert into venteterrain(remblaye_nb,acces_nb,arbore_nb,eau_elec_nb,cloture_nb,pente_nb) values(50,50,50,50,50,50)");
ADOQuery1->ExecSQL(); |
Partager