Difference between revisions of "TSQLQuery"
From Free Pascal wiki
Jump to navigationJump to searchm (Fixed syntax highlighting) |
|||
(19 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{TSQLQuery}} | |
+ | {{Infobox databases}} | ||
− | Typical | + | '''TSQLQuery''' [[image:tsqlquery.png]] is a fundamental database query component for use with any supported database. The component is found on [[SQLdb tab]] of the [[Component Palette]]. |
+ | |||
+ | Typical use of a TSQLQuery: | ||
SQLTransaction1.Database := SQLConnection1; | SQLTransaction1.Database := SQLConnection1; | ||
SQLQuery1.Transaction := SQLTransaction1; | SQLQuery1.Transaction := SQLTransaction1; | ||
− | ''' | + | DataSource1.DataSet := '''SQLQuery1'''; |
− | DBGrid1.DataSource := | + | DBGrid1.DataSource := DataSource1; |
+ | |||
+ | ===Select=== | ||
+ | |||
+ | Select all columns from table somelist: | ||
+ | <syntaxhighlight lang=pascal> | ||
+ | SQLQuery1.SQL.Text := 'SELECT * FROM somelist'; | ||
+ | SQLQuery1.Open(); | ||
+ | </syntaxhighlight> | ||
+ | |||
+ | ===Insert=== | ||
+ | |||
+ | Insert a new record into table somelist: | ||
+ | |||
+ | <syntaxhighlight lang=pascal> | ||
+ | SQLQuery1.SQL.Text := 'INSERT INTO somelist (ItemNr,ItemCount) VALUES (1231,2)'; | ||
+ | SQLQuery1.ExecSQL(); | ||
+ | SQLTransaction1.Commit(); | ||
+ | </syntaxhighlight> | ||
==See also== | ==See also== | ||
− | * [ | + | |
− | * [ | + | * [http://www.freepascal.org/docs-html/fcl/sqldb/tsqlquery.html TSQLQuery doc] |
+ | * [http://www.freepascal.org/docs-html/fcl/sqldb/usingsqldb.html Using SQLdb] | ||
{{LCL Components}} | {{LCL Components}} |
Revision as of 01:36, 2 March 2020
│
English (en) │
français (fr) │
日本語 (ja) │
русский (ru) │
References:
Tutorials/practical articles:
Databases |
TSQLQuery is a fundamental database query component for use with any supported database. The component is found on SQLdb tab of the Component Palette.
Typical use of a TSQLQuery:
SQLTransaction1.Database := SQLConnection1; SQLQuery1.Transaction := SQLTransaction1; DataSource1.DataSet := SQLQuery1; DBGrid1.DataSource := DataSource1;
Select
Select all columns from table somelist:
SQLQuery1.SQL.Text := 'SELECT * FROM somelist';
SQLQuery1.Open();
Insert
Insert a new record into table somelist:
SQLQuery1.SQL.Text := 'INSERT INTO somelist (ItemNr,ItemCount) VALUES (1231,2)';
SQLQuery1.ExecSQL();
SQLTransaction1.Commit();
See also