- Viewed 53k times
27
answered May 27, 2010 at 6:02@mawg, i wrote an simple program for you to ilustrate how work with ADO and Delphi. this is an console application, but explains the basics.
before you execute this code you must download and install the odbc connector from this location.
You can impro...
program ProjectMysqlADO;{$APPTYPE CONSOLE}usesActiveX,DB,ADODB,SysUtils;const//the connection stringStrConnection='Driver={MySQL ODBC 3.51 Driver};Server=%s;Database=%s;User=%s; Password=%s;Option=3;';varAdoConnection : TADOConnection;procedure SetupConnection(DataBase:String);//Open a connectionContent Under CC-BY-SA license WEBMay 2, 2012 · @mawg, i wrote an simple program for you to ilustrate how work with ADO and Delphi. this is an console application, but explains the basics. before you execute …
Explore further
- To see some ADOQuery action we'll code a small example. Let's make a query that can be used to fetch the rows from various tables in a database. To show the list of all the tables in a database we can use the GetTableNamesmethod of the ADOConnectioncomponent. The GetTableNames in the OnCreate event of the form fills the ComboBox with the table name...
- Estimated Reading Time: 5 mins
WEBNov 3, 2011 · Description. This example demostrates the use of ADO for database conectivity. The example assumes that a TDBGrid is placed on the form.
WEBAug 6, 2023 · In this chapter of the free database course for Delphi beginners - focus on ADO, we'll look at how you can take advantage of the TADOQuery component to boost …
WEBFrom the first version, Delphi provides database developers with the BDE (Borland Database Engine). Beside the BDE, Delphi from the fifth version supports Microsoft …
WEBNov 30, 2017 · The dbGo components provide data access through the ADO framework. ADO, (Microsoft ActiveX Data Objects) is a set of COM objects that access data through …
Transaction Processing :: Chapter 15: Working with ADO :: Part III ...
WEBMastering Delphi 7. Transaction Processing. As we saw in section "Using Transactions" of Chapter 14, transaction processing allows developers to group individual updates to a …
Working with ADO | Part III - Delphi Database-Oriented ... - Flylib
WEBActiveX Data Objects (ADO) is a layer on top of OLE DB and is referred to as an application-level interface. It is considerably simpler than OLE DB and more forgiving. In …
Filtering, Searching/Finding and Sorting records in ADO ... - Blogger
WEBAug 26, 2016 · A Adoquery dataset provides following mechanisms to filter existing records... Filter - String Property that can contain Filter string like SQL WHERE clause …
- Some results have been removed
Skip to content
