Difference between revisions of "TSQLQuery"
From Free Pascal wiki
Jump to navigationJump to searchGeoffState (talk | contribs) m (→Select) |
GeoffState (talk | contribs) (→Select) |
||
Line 13: | Line 13: | ||
<syntaxhighlight> | <syntaxhighlight> | ||
SQLQuery1.SQL.Text := 'SELECT * FROM somelist'; | SQLQuery1.SQL.Text := 'SELECT * FROM somelist'; | ||
− | + | SQLQuery1.Open(); | |
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 00:50, 11 March 2019
│
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