Difference between revisions of "Data Controls tab"

From Lazarus wiki
Jump to navigationJump to search
(Add links to Online Documentation for components on the Data Controls palette. Add missing descriptions.)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{{Data_Controls_tab}}
 
{{Infobox databases}}
 
{{Infobox databases}}
 
The '''Data controls tab''' of the [[Component Palette]] contains database-related control components.
 
The '''Data controls tab''' of the [[Component Palette]] contains database-related control components.
Line 6: Line 7:
 
{| class = "wikitable sortable"
 
{| class = "wikitable sortable"
 
|-
 
|-
! Icon !! Component !! Description
+
! Icon !! Component !! Description !! Online Docs
 
|-
 
|-
 
| [[image:tdbnavigator.png]] || [[TDBNavigator]] || navigation control for use with a connected database
 
| [[image:tdbnavigator.png]] || [[TDBNavigator]] || navigation control for use with a connected database
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbnavigator.html Link]
 
|-
 
|-
| [[image:tdbtext.png]] || [[TDBText]] || text-contents for a database-field value
+
| [[image:tdbtext.png]] || [[TDBText]] || text contents for a [[TDataSet]] field value, not editable
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbtext.html Link]
 
|-
 
|-
| [[image:tdbedit.png]] || [[TDBEdit]] || edit field for a database-field value  
+
| [[image:tdbedit.png]] || [[TDBEdit]] || single-line edit control for a [[TDataSet]] field value  
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbedit.html Link]
 
|-
 
|-
| [[image:tdbmemo.png]] || [[TDBMemo]] || editable memo field for a database-field value
+
| [[image:tdbmemo.png]] || [[TDBMemo]] || multi-line edit control for a [[TDataSet]] field value
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbmemo.html Link]
 
|-
 
|-
| [[image:tdbimage.png]] || [[TDBImage]] || image from a database-field
+
| [[image:tdbimage.png]] || [[TDBImage]] || image stored in a field of a [[TDataSet]]
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbimage.html Link]
 
|-
 
|-
| [[image:tdblistbox.png]] || [[TDBListBox]] ||  
+
| [[image:tdblistbox.png]] || [[TDBListBox]] || list with several string items, the selected item corresponds to a [[TDataSet]] field
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdblistbox.html Link]
 
|-
 
|-
| [[image:tdblookuplistbox.png]] || [[TDBLookupListBox]] ||
+
| [[image:tdblookuplistbox.png]] || [[TDBLookupListBox]] || similar to [[TDBListBox]], but the string items are taken from a lookup [[TDataSet]]
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdblookuplistbox.html Link]
 
|-
 
|-
| [[image:tdbcombobox.png]] || [[TDBComboBox]] ||
+
| [[image:tdbcombobox.png]] || [[TDBComboBox]] || dropdown list with several options, the selected item corresponds to a [[TDataSet]].
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbcombobox.html Link]
 
|-
 
|-
| [[image:tdblookupcombobox.png]] || [[TDBLookupComboBox]] ||
+
| [[image:tdblookupcombobox.png]] || [[TDBLookupComboBox]] || similar to [[TDBComboBox]], but the string items are taken from a lookup [[TDataSet]]
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdblookupcombobox.html Link]
 
|-
 
|-
| [[image:tdbcheckbox.png]] || [[TDBCheckBox]] ||
+
| [[image:tdbcheckbox.png]] || [[TDBCheckBox]] || checkbox corresponding with a [[TDataSet]] field value
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbcheckbox.html Link]
 
|-
 
|-
| [[image:tdbradiogroup.png]] || [[TDBRadioGroup]] ||
+
| [[image:tdbradiogroup.png]] || [[TDBRadioGroup]] || group of [[TRadioButton]]s, the selected index corresponds to a [[TDataSet]] field.
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbradiogroup.html Link]
 
|-
 
|-
| [[image:tdbcalendar.png]] || [[TDBCalendar]] ||
+
| [[image:tdbcalendar.png]] || [[TDBCalendar]] || date from the [[TDataSet]] displayed in a month calendar
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbcalendar.html Link]
 
|-
 
|-
| [[image:tdbgroupbox.png]] || [[TDBGroupBox]] ||
+
| [[image:tdbgroupbox.png]] || [[TDBGroupBox]] || container for other controls. Data field information is displayed in header of the box.
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdbgroupbox.html Link]
 
|-
 
|-
| [[image:tdbgrid.png]] || [[TDBGrid]] ||
+
| [[image:tdbgrid.png]] || [[TDBGrid]] || grid displaying fields of several records of s [[TDataSet]]
 +
|| [http://lazarus-ccr.sourceforge.net/docs/lcl/dbgrids/tdbgrid.html Link]
 
|-
 
|-
| [[image:tdbdatetimepicker.png]] || [[TDBDateTimePicker]] ||
+
| [[image:tdbdatetimepicker.png]] || [[TDBDateTimePicker]] || date/time value editor for a [[TDataSet]] field
 +
|| (no LCL control)
 
|}
 
|}
 
<br clear="all"/>
 
<br clear="all"/>

Latest revision as of 21:16, 9 September 2018

English (en) français (fr) 日本語 (ja) русский (ru)

Databases portal

References:

Tutorials/practical articles:

Databases

Advantage - MySQL - MSSQL - Postgres - Interbase - Firebird - Oracle - ODBC - Paradox - SQLite - dBASE - MS Access - Zeos

The Data controls tab of the Component Palette contains database-related control components.

Component Palette Data Controls.png

Icon Component Description Online Docs
tdbnavigator.png TDBNavigator navigation control for use with a connected database Link
tdbtext.png TDBText text contents for a TDataSet field value, not editable Link
tdbedit.png TDBEdit single-line edit control for a TDataSet field value Link
tdbmemo.png TDBMemo multi-line edit control for a TDataSet field value Link
tdbimage.png TDBImage image stored in a field of a TDataSet Link
tdblistbox.png TDBListBox list with several string items, the selected item corresponds to a TDataSet field Link
tdblookuplistbox.png TDBLookupListBox similar to TDBListBox, but the string items are taken from a lookup TDataSet Link
tdbcombobox.png TDBComboBox dropdown list with several options, the selected item corresponds to a TDataSet. Link
tdblookupcombobox.png TDBLookupComboBox similar to TDBComboBox, but the string items are taken from a lookup TDataSet Link
tdbcheckbox.png TDBCheckBox checkbox corresponding with a TDataSet field value Link
tdbradiogroup.png TDBRadioGroup group of TRadioButtons, the selected index corresponds to a TDataSet field. Link
tdbcalendar.png TDBCalendar date from the TDataSet displayed in a month calendar Link
tdbgroupbox.png TDBGroupBox container for other controls. Data field information is displayed in header of the box. Link
tdbgrid.png TDBGrid grid displaying fields of several records of s TDataSet Link
tdbdatetimepicker.png TDBDateTimePicker date/time value editor for a TDataSet field (no LCL control)


Component Palette
Standard - Additional - Common Controls - Dialogs - Data Controls - Data Access - System - Misc - LazControls - RTTI - SQLdb - Pascal Script - SynEdit - Chart - IPro