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, delphi adaptreq tadapterrequestparamsimpl getparamname, zeos delphi, zreadonlyquery, zeos zquery, zeoslib delphi parameter, delphi ZConnection, zeos table, delphi zeos parameter, delphi zeos parameters, zeosdbo for delphi, Zreadonlyquery delphi, zeos connection with delphi, zeos mysql connect, zeos mysql delphi components, zeos connection, zeos one zconnection one zquery, zeos oracle parameters, zeos oracle TZConnection, Zeos application, zeos sql lock, zeos delphi grid editable, zeos create table, zeos delphi 6, zeos delphi 3 parameters, zeos delphi parameters, zeos DataSource, zeos delphi sql with parameter, zeos delphi ttable, zeos how to, zeos howto, zeos delphi sql sample, zeos ZConnection, zeoslib delphi oracle, zeoslib delphi select like%, zeoslib mysql delphi connect, zeoslib mysql return parameter, zeoslib parameters, zeoslib sql, Zeoslib SQL example, zeoslib tzconnection, zeoslib zquery properties, delphi configure zconnection oracle, zeoslib delphi 6, zeos zquery isinsert, zeos zquery syntax, Zeosdbo apply, zeosdbo mysql, zeosdbo oracle, zeoslib auto reconnect, zeoslib autoreconnect, zeoslib connection delphi, zeoslib connection params, zquery delphi, Zeos 6 delphi, autoreconnect zconnection delphi, delphi zeos create, delphi ZEOS mysql, delphi zeos mysql connection parameters, Delphi zeos mysql parameter, delphi zeos mysql reconnect, delphi zeos table append, delphi zeos where sql, delphi zeosdbo create table, delphi zeosdbo createtable, Delphi ZeosLib Parameters da SQL, delphi zeos connection params, delphi mysql ZConnection, borland delphi intra web, component Zeos Connection, configure ZConnection, connecting delphi 6 to zeos, connecting zeos to oracle, create an oracle connection with zeos, create delphi application with zeos mysql, create table zeosdbo, datasource zeoslib, dbgrid delphi zeos, delphi6 zeos, freepascal tdbgrid, use MySQL table zconnection delphi, using zconnection delphi, zconection di delphi, ZConnection, ZConnection delphi and MySQL database, zconnection delphi auto connect how to, zconnection get tables, Zconnection oracle, zconnection parameter oracle, zconnection params windows1251, TZConnection dephi, Table zeos, 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, parametros date zeos oracle
