procedure TForm1.Button9Click(Sender: TObject);
var help1, help2:string;
begin
help1:='%'+datetostr(Form1.DateTimePicker1.DateTime)+ '%';
help2:= QuotedStr(help1);
with form1.ADOQuery2 do
begin
close;
SQL.Clear;
Sql.Add('Select cars.*, uslugi.* from cars inner join uslugi on cars.код = uslugi.idcars AND uslugi.Data =' + help2 + ' order by Data');
Open;
end;
end;
SELECT members.firstname || ' ' || members.lastname
AS "Full Name"
FROM borrowings
INNER JOIN members
ON members.memberid=borrowings.memberid
INNER JOIN books
ON books.bookid=borrowings.bookid
WHERE borrowings.bookid IN (SELECT bookid
FROM books
WHERE stock>(SELECT avg(stock)
FROM books))
GROUP BY members.firstname, members.lastname;SELECT members.firstname || ' ' || members.lastname
AS "Full Name"
FROM borrowings
INNER JOIN members
ON members.memberid=borrowings.memberid
INNER JOIN books
ON books.bookid=borrowings.bookid
WHERE borrowings.bookid IN (SELECT bookid
FROM books
WHERE stock>(SELECT avg(stock)
FROM books))
GROUP BY members.firstname, members.lastname;
var d1,d2:String;
begin
d1:= Datetostr(Form1.DateTimePicker1.Date); ;
d2:=QuotedStr('%'+d1+ '%');
with Form1.ADOQueryRep do
begin
Close;
SQL.Clear;
Sql.Add('Select Cars.*, Uslugi.* from Cars inner join Uslugi on Cars.код=Uslugi.id_cars where Uslugi.data like' + d2+' order by Marka');
// Open;
end;
Form5.Show;
Form5.frxReport1.ShowReport();
end;
Если Вы уже зарегистрированы на Портале - войдите в систему, если Вы еще не регистрировались - пройдите простую процедуру регистрации.