( )
ᒺ ADOQuery DataSource, DataSet (ADOTabe ADOQuery)
:
2- ORDERS CUSTOMERS, , , .
:
Select*from Orders where SustNo=:CustNo
:CustNo , . ADOQuery.DataSource, DataSet ( ).
Delphi DataSoure, , , Parameters.
: ()
1. ADOTable1, DataSoure1 TDBGrid1 CUSTOMERS;
2. ADOTable2 ORDERS
3. ADOQuery1, DataSourse2, TDBGrid2 ;
4. ADOQuery1.SQL :
Select*from Orders where CustNo:CustNo
4 DataSoure2 ADOQuery1 DataSoure1;
5 Active=True.
:
ORDERS ITEMS
select
O.CustNo, O.OrderNo, O.SaleDate, I.PartNo, I.Qty
from Orders O, Items I
where O.OrderNo=I.OrderNo
where .
Open Exec SQL
( ), Open. , , SELECT. (INSERT, DELETE, UPDATE), ExecSQL.
:
SQL delete from Country where Name=Argentina;
:
Delete from Country where Name=:CountryName
ADOQuery2.Prepare;
ADOQuery2.Parammeters[0]:=Argentina;
ADOQuery2.ExecSQL;
Insert into Country(Name):Val(Argentina)
1. Delphi SQL?
2. Delphi?
3. ?
4. Delphi?
5. ?
6. , ?
6
: .
: .
:
1. , QuickReport.
2. .
Quick Reports
, bq Delphi TQuick Reports. ³ , Internet , , . Quick Reports Delphi .
|
|
Quick Reports QReport .
Quick Reports TQuickRep. - . ³ .
. , . , .
' :
Bands () , , :
HasColumnHeader . , , . . , true.
HasDetail , .
HasSubDetail .
HasPageFooter .
HasPageHeader .
HasSummary ( ).
HasTitle .
, , QuickRep1. - () (.8).
. 8. QuickRep
DataSet ()
.
Font , .
Frame .
Options . FirstPageHeader true, . LastPageFooter true, . Compression true, .
Page
. , .
PrinterSettings .
ReportTitle .
ShowProgress true, .
SnapToGrid .
Zoom .
QuickRep, , . .
QuickRep1, HasPageHeader HasDetail true, DataSet ADOTable1.
HasPageHeader ᑺ QRLabel1, QRLabel2, QRLabel3, QRLabel4, Caption ϲ, ², , .
HasDetail ᑺ QRDBText1, QRDBText2, QRDBText3, QRDBText4, ¢ . DataSet ADOTable1, DataFields .(.9).
|
|
9.
, Preview.
9.
, form2.QuickRep1.Preview, form2.QuickRep1.Prnt.
1. Delphi ?
2. ?
3. ?
4. ?
5. ?
6. ?
˳
1. . Delphi7: . .: , 2005. 1101.
2. .. ALLFusion Modeling Suite. .: , 2005 432 .
3. ̒ .., .. ᑺ : 6.080400 㳿 ., 2002. 15 .
4. ̑ .. 7.080401 0804 . : , 2007. 67.
5. .. Delphi 6. . .: , 2002, - 464 ., .