Difference between revisions of "TSQLConnector/ja"

From Free Pascal wiki
Jump to navigationJump to search
(Created page with "{{TSQLConnector}} {{Infobox databases}} '''TSQLConnector''' image:tsqlconnector.png is a versatile database connector component for use with any supported database. The co...")
 
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{TSQLConnector}}
 
{{TSQLConnector}}
{{Infobox databases}}
+
{{Infobox databases/ja}}のにある。
'''TSQLConnector''' [[image:tsqlconnector.png]] is a versatile database connector component for use with any supported database. The component is found on [[SQLdb tab]] of the [[Component Palette]].
+
'''TSQLConnector''' [[image:tsqlconnector.png]] はサポートするどのデータベースにも用いられる多機能のデータベースコネクタコンポーネントである。このコンポーネントは[[Component Palette/ja]][[SQLdb tab/ja]]にある。
  
To configure database access, most important properties are:
+
データベースアクセスを設定するために、最も重要なプロパティは:
 
* ConnectorType:
 
* ConnectorType:
 
::{|
 
::{|
Line 33: Line 33:
 
| [[TPQConnection]] || <tt>Postgres</tt>   
 
| [[TPQConnection]] || <tt>Postgres</tt>   
 
|-
 
|-
| [[TSQLite3Connection]] || <tt>SQLite3</tt>  
+
| [[TSQLite3Connection/ja]] || <tt>SQLite3</tt>  
 
|-
 
|-
 
| [[TSybaseConnection]] || <tt>Sybase</tt>  
 
| [[TSybaseConnection]] || <tt>Sybase</tt>  
Line 40: Line 40:
 
* Hostname
 
* Hostname
 
* Password
 
* Password
* [[TSQLTransaction|Transaction]]
+
* [[TSQLTransaction/ja]]
  
 
For any connector to function, it should be able to load the right drivers. *.dll style drivers are found if they are located in the same directory as the corresponding *.exe file.
 
For any connector to function, it should be able to load the right drivers. *.dll style drivers are found if they are located in the same directory as the corresponding *.exe file.
  
==See also==
+
== 以下も参照のこと ==
 
* [http://www.freepascal.org/docs-html/fcl/sqldb/tsqlconnector.html TSQLConnector doc]
 
* [http://www.freepascal.org/docs-html/fcl/sqldb/tsqlconnector.html TSQLConnector doc]
 
* [http://www.freepascal.org/docs-html/fcl/sqldb/universalconnectors.html Using universal database connectors]
 
* [http://www.freepascal.org/docs-html/fcl/sqldb/universalconnectors.html Using universal database connectors]
  
 
{{LCL Components}}
 
{{LCL Components}}

Latest revision as of 12:54, 1 April 2024

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

データベースのポータル

参照:

チュートリアル/練習となる記事:

各種データベース

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

のにある。

TSQLConnector tsqlconnector.png はサポートするどのデータベースにも用いられる多機能のデータベースコネクタコンポーネントである。このコンポーネントはComponent Palette/jaSQLdb tab/jaにある。

データベースアクセスを設定するために、最も重要なプロパティは:

  • ConnectorType:
TIBConnection Firebird
TMSSQLConnection MSSQLServer
TMySQL40Connection MySQL 4.0
TMySQL41Connection MySQL 4.1
TMySQL50Connection MySQL 5.0
TMySQL51Connection MySQL 5.1
TMySQL55Connection MySQL 5.5
TMySQL56Connection MySQL 5.6
TMySQL57Connection MySQL 5.7
TMySQL80Connection MySQL 8.0
TODBCConnection ODBC
TOracleConnection Oracle
TPQConnection Postgres
TSQLite3Connection/ja SQLite3
TSybaseConnection Sybase

For any connector to function, it should be able to load the right drivers. *.dll style drivers are found if they are located in the same directory as the corresponding *.exe file.

以下も参照のこと


LCL Components
Component Tab Components
Standard TMainMenu • TPopupMenu • TButton • TLabel • TEdit • TMemo • TToggleBox • TCheckBox • TRadioButton • TListBox • TComboBox • TScrollBar • TGroupBox • TRadioGroup • TCheckGroup • TPanel • TFrame • TActionList
Additional TBitBtn • TSpeedButton • TStaticText • TImage • TShape • TBevel • TPaintBox • TNotebook • TLabeledEdit • TSplitter • TTrayIcon • TControlBar • TFlowPanel • TMaskEdit • TCheckListBox • TScrollBox • TApplicationProperties • TStringGrid • TDrawGrid • TPairSplitter • TColorBox • TColorListBox • TValueListEditor
Common Controls TTrackBar • TProgressBar • TTreeView • TListView • TStatusBar • TToolBar • TCoolBar • TUpDown • TPageControl • TTabControl • THeaderControl • TImageList • TPopupNotifier • TDateTimePicker
Dialogs TOpenDialog • TSaveDialog • TSelectDirectoryDialog • TColorDialog • TFontDialog • TFindDialog • TReplaceDialog • TTaskDialog • TOpenPictureDialog • TSavePictureDialog • TCalendarDialog • TCalculatorDialog • TPrinterSetupDialog • TPrintDialog • TPageSetupDialog
Data Controls TDBNavigator • TDBText • TDBEdit • TDBMemo • TDBImage • TDBListBox • TDBLookupListBox • TDBComboBox • TDBLookupComboBox • TDBCheckBox • TDBRadioGroup • TDBCalendar • TDBGroupBox • TDBGrid • TDBDateTimePicker
Data Access TDataSource • TCSVDataSet • TSdfDataSet • TBufDataset • TFixedFormatDataSet • TDbf • TMemDataset
System TTimer • TIdleTimer • TLazComponentQueue • THTMLHelpDatabase • THTMLBrowserHelpViewer • TAsyncProcess • TProcessUTF8 • TProcess • TSimpleIPCClient • TSimpleIPCServer • TXMLConfig • TEventLog • TServiceManager • TCHMHelpDatabase • TLHelpConnector
Misc TColorButton • TSpinEdit • TFloatSpinEdit • TArrow • TCalendar • TEditButton • TFileNameEdit • TDirectoryEdit • TDateEdit • TTimeEdit • TCalcEdit • TFileListBox • TFilterComboBox • TComboBoxEx • TCheckComboBox • TButtonPanel • TShellTreeView • TShellListView • TXMLPropStorage • TINIPropStorage • TJSONPropStorage • TIDEDialogLayoutStorage • TMRUManager • TStrHolder
LazControls TCheckBoxThemed • TDividerBevel • TExtendedNotebook • TListFilterEdit • TListViewFilterEdit • TLvlGraphControl • TShortPathEdit • TSpinEditEx • TFloatSpinEditEx • TTreeFilterEdit • TExtendedTabControl •
RTTI TTIEdit • TTIComboBox • TTIButton • TTICheckBox • TTILabel • TTIGroupBox • TTIRadioGroup • TTICheckGroup • TTICheckListBox • TTIListBox • TTIMemo • TTICalendar • TTIImage • TTIFloatSpinEdit • TTISpinEdit • TTITrackBar • TTIProgressBar • TTIMaskEdit • TTIColorButton • TMultiPropertyLink • TTIPropertyGrid • TTIGrid
SQLdb TSQLQuery • TSQLTransaction • TSQLScript • TSQLConnector • TMSSQLConnection • TSybaseConnection • TPQConnection • TPQTEventMonitor • TOracleConnection • TODBCConnection • TMySQL40Connection • TMySQL41Connection • TMySQL50Connection • TMySQL51Connection • TMySQL55Connection • TMySQL56Connection • TMySQL57Connection • TSQLite3Connection • TIBConnection • TFBAdmin • TFBEventMonitor • TSQLDBLibraryLoader
Pascal Script TPSScript • TPSScriptDebugger • TPSDllPlugin • TPSImport_Classes • TPSImport_DateUtils • TPSImport_ComObj • TPSImport_DB • TPSImport_Forms • TPSImport_Controls • TPSImport_StdCtrls • TPSCustomPlugin
SynEdit TSynEdit • TSynCompletion • TSynAutoComplete • TSynMacroRecorder • TSynExporterHTML • TSynPluginSyncroEdit • TSynPasSyn • TSynFreePascalSyn • TSynCppSyn • TSynJavaSyn • TSynPerlSyn • TSynHTMLSyn • TSynXMLSyn • TSynLFMSyn • TSynDiffSyn • TSynUNIXShellScriptSyn • TSynCssSyn • TSynPHPSyn • TSynTeXSyn • TSynSQLSyn • TSynPythonSyn • TSynVBSyn • TSynAnySyn • TSynMultiSyn • TSynBatSyn • TSynIniSyn • TSynPoSyn
Chart TChart • TListChartSource • TRandomChartSource • TUserDefinedChartSource • TCalculatedChartSource • TDbChartSource • TChartToolset • TChartAxisTransformations • TChartStyles • TChartLegendPanel • TChartNavScrollBar • TChartNavPanel • TIntervalChartSource • TDateTimeIntervalChartSource • TChartListBox • TChartExtentLink • TChartImageList
IPro TIpFileDataProvider • TIpHtmlDataProvider • TIpHttpDataProvider • TIpHtmlPanel
Virtual Controls TVirtualDrawTree • TVirtualStringTree • TVTHeaderPopupMenu