Stack Overflow
Stack Overflow

Questions tagged [zeos]

Database-components for encapsulating access to several databases at once for software development environments.

Zeos aka Zeoslib aka ZeosDBO (Zeos Database Objects) is a set of Delphi/Fpc multiprotocol database connectivity components.

Among others it allows to use remote databases using the lower Delphi SKUs, and it provided MySql support before Borland did.

The site and forum is at http://zeos.firmos.at/portal.php.

120 questions
0
votes
0 answers

Delphi + Firebird + ZEOS - Update on real-time data

Necessary that the two systems networked, open on different computers, update the information among themselves semque I need to close and re-open the executable. I'm using Firebird + ZEOS and even if I refresh the tables one does not see the update…
Anderson Nunes
  • 201
  • 3
  • 18
0
votes
1 answer

Zeoslib in Delphi xe5 installation

I am trying to install zeoslib in Delphi xe5 with no success. I keep getting a Ambiguous overloaded call to Char Inset error when I try to compile or build the project. I use zeoslib to connect to remote MySQL databases with my desktop…
user3271392
  • 149
  • 2
  • 12
0
votes
1 answer

How to run a Zeos filter code for multiple TZquery?

I used to use a single code for my filter queries, and tried it using multiple TZquery but it won't work. All the tables contain the client_id column, and I wanted for the code to search for the infos with the client id on the TEdit, it works for a…
code8888
  • 15
  • 3
0
votes
1 answer

Disable MySQL secure_auth client option with ZeosLib

I'm trying to connect to a remote MySQL server and i get this exception error: *Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)* I'm tried to disable the "secure_auth" option by adding the…
fjesteban
  • 11
  • 1
  • 2
0
votes
0 answers

????? result when INSERTing with parameters(value directly inside query is fine)

I have a query that is just a simple INSERT into MySQL. When I use DBQuery.Params to add my value to query I get ??????(or E?? E?E???) in the MySQL side(if I perform a SELECT I get this results too ). But when I directly add my value to query…
SAMPro
  • 1,068
  • 1
  • 15
  • 39
0
votes
1 answer

Delphi ZEOSlib: read from a table and write it to another database

Is it possible to read a table from a database with delphi zeoslib and write it back to another server? I think it, to read the table and write back the resultset, but i don't know how, is it possible? I thought for the following: I made an zquery:…
Woodyka
  • 51
  • 2
  • 9
0
votes
1 answer

sqlite3 delete on cascade with Delphi XE Zeosdb Tztable

I have two tables Client , Commande The DDL in sqlite3 is the following , CREATE TABLE Client ( id_client INT NOT NULL, nom varchar(10), PRIMARY KEY ( id_client ) ); CREATE TABLE Commande ( id_commande …
Bessoufi Mounir
  • 1,368
  • 1
  • 8
  • 7
0
votes
0 answers

Updates getting retained Firebird 1 with ZeosLib

Delphi Xe2 + ZeosLib 7.0.3 Stable + Firebird 1.0 I am doing updates to the several tables and data is retaining on memory. It is not reflected on the database in a way that other applications can see it. I have tried using auto-commit only and did…
Eduardo Elias
  • 1,742
  • 1
  • 22
  • 49
0
votes
0 answers

Auto Calculated Field on Firebird 1 with ZeosLib does not get calculated

Delphi XE2 + Zeos 7.0.3 Stable + Firebird 1.0 I am porting an old app from Delphi 5 + IBX and got this problem: I have a table that one for the fields is auto calculated: NUMERIC(18,2) COMPUTED BY (( (VAL_ITENS + VAL_SERVICO + …
Eduardo Elias
  • 1,742
  • 1
  • 22
  • 49
0
votes
4 answers

Postgresql with Zeos: libpq is not found or not loadable on win 7 64

I have PostgreSQL 9.2 installed on win 7 64 and can connect to it with ODBC from my delphi IDE using dbexpress with no problem. When I try to connect using Zeos, and although I have provided the path to the libpq.dll, I still get the error (libpq…
user2441588
  • 45
  • 1
  • 6
0
votes
2 answers

How to select columns from 2 tables in a Firebird database using zquery?

I would like to display on a TDbgrid data from 2 tables on a single database file. I have tried to write sql statements like: select "Client", "Address", "Balance" from "table1" and "Payment" from "table2" But it always shows this error SQL Error:…
Chunk Chunk
  • 143
  • 6
  • 17
0
votes
1 answer

how to display to a dbgrid my query in this code?

hello is it possible for this code to display to a tdbgrid the search results in a list like style? (e.g. if i searched for john, all the data conataining john on a certain field will be displayed to the tdbgrid) procedure…
Chunk Chunk
  • 143
  • 6
  • 17
0
votes
1 answer

how can i make my search box jump from one keyword to another without it check every row of the database?

I got this code working for my app's search box, unfortunately when it search or filters, it checks every row on the database and then when the searched word is found, it will display it on the tlabels, procedure Tspcb.dccolbtnClick(Sender:…
Chunk Chunk
  • 143
  • 6
  • 17
0
votes
1 answer

BDS2006 and Zeos installation

I recently installed Zeos 6.6 stable on BDS2006 for both the Delphi and C++ personalities. In order to do so, and since Zeos is written in Delphi, I checked the "Generate all C++ Builder files" when building the packages. The problem I found was…
Guillem Vicens
  • 3,936
  • 30
  • 44
0
votes
3 answers

how to connect to a firebird database in delphi 7 through a local network?

how do i connect my delphi 7 app to a local network? i am using zeos and have set up the ZConnection1 hostname setting to the ip of my server in the object inspector, i can connect on the computer i am coding right now but cant connect to the…
Chunk Chunk
  • 143
  • 6
  • 17
1 2 3 4 5 6
7
8