Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. ComboBox1->Clear();
  2. ADOQuery1->SQL->Clear();
  3. ADOQuery1->SQL->Add("select productionprocess from contract \
  4. group by productionprocess \
  5. order by productionprocess desc;");
  6. ADOQuery1->Open();
  7. while (!ADOQuery1->Eof)
  8. {
  9. ComboBox1->Items->Add(ADOQuery1->FieldByName("productionprocess")->AsString);
  10. ADOQuery1->Next();
  11. }
  12.  
  13. ADOQuery1->SQL->Clear();
  14. ADOQuery1->SQL->Add("select idOrder 'Order id', `date` 'Date', \
  15. DepositPayed 'Payed deposit', ContractTotalPrice 'Total price',\
  16. ContracTotalPrice_inclVAT 'Total price+18%',\
  17. productionprocess 'Production process' from contract;");
  18. ADOQuery1->Open();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement