I am trying to build an app using MySQL and of course Delphi with ZeosDBO components.
Drop a ZConnection.
- Set your User, Password, Host, Port and Protocol (and any other parameters if needed).
- Set Connected to True.
Drop a ZQuery (do not mistake with ZReadOnlyQuery).
- Set the Connection to your active ZConnection.
- Set the Sql property to something like SELECT * FROM MyTable.
- Set Active to True.
Drop a DataSource from the Data Access tab.
- Set the DataSet to your active ZQuery.
- Drop a DBGrid from the Data Controls tab.
- Set the Datasource to your DataSource.
If all is ok you should now be able to see the records from your table.
Incoming search terms for the article:
zconnection delphi, zeos delphi, zreadonlyquery, zeos zquery, zeosdbo for delphi, zeoslib delphi parameter, delphi ZConnection, zeos connection with delphi, zeos table, Zreadonlyquery delphi, zeos howto, zeos how to, zeos mysql connect, zeos delphi ttable, zeos delphi sql with parameter, zeos mysql delphi components, zeos delphi sql sample, zeos delphi parameters, ZConnection Properties, Zeos 6 delphi, Zeos application, zeos connection, zeos create table, zeos DataSource, zeos delphi 3 parameters, zeos delphi 6, zeos delphi grid editable, zeos one zconnection one zquery, zeos oracle parameters, zeoslib delphi oracle, zeoslib delphi select like%, zeoslib mysql delphi connect, zeoslib parameters, zeoslib sql, zeoslib tzconnection, zeoslib zquery properties, zquery delphi, zeoslib delphi 6, zeoslib connection params, zeoslib connection delphi, zeos oracle TZConnection, Zeoslib SQL example, zeos ZConnection, zeos zquery isinsert, zeos zquery syntax, Zeosdbo apply, zeosdbo mysql, zeosdbo oracle, zeos sql lock, borland delphi intra web, delphi zeos create, delphi ZEOS mysql, delphi zeos mysql connection parameters, Delphi zeos mysql parameter, delphi zeos mysql reconnect, delphi zeos parameter, delphi zeos parameters, delphi zeos table append, delphi zeos where sql, delphi zeos connection params, autoreconnect zconnection delphi, delphi mysql ZConnection, component Zeos Connection, configure ZConnection, connecting delphi 6 to zeos, connecting zeos to oracle, create delphi application with zeos mysql, create table zeosdbo, datasource zeoslib, dbgrid delphi zeos, delphi configure zconnection oracle, delphi zeosdbo create table, delphi zeosdbo createtable, Delphi ZeosLib Parameters da SQL, TZConnection dephi, use MySQL table zconnection delphi, using zconnection delphi, zconection di delphi, ZConnection, ZConnection delphi and MySQL database, zconnection get tables, Zconnection oracle, zconnection parameter oracle, Table zeos, select zeos delphi, retrieve data from zquery, delphi6 zeos, freepascal tdbgrid, grid dan zeos, How to configure ZConnection, how to connect delphi with zeosdbo, How to fetch data using zeosdbo, how to get data from table zeoslib, mysql ZConnection autoreconnect, oracle delphi zeos, zconnection params windows1251
