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
1
vote
1 answer

Rebuild Lazarus failed after ZEOS database lib installation

Try to install ZEOS database components, but I failed at the install step: Error message: PPU Loading C:\ProgramData\lazarus\ideintf\units\x86_64-win64\win32\componenttreeview.ppu PPU Source: componenttreeview.pas not found PPU Source:…
Franz
  • 1,883
  • 26
  • 47
1
vote
1 answer

List values from stored procedure function

I'm new to Delphi, but im a old PHP and MySQL programmer. I have a system that needs to be used on a desktop too, so I've created some stored procedures to list the queries from the database. The stored procedures just select and join tables to show…
talles_jp
  • 143
  • 3
  • 13
0
votes
0 answers

ZeosDBO SQL Logic Errors

Trying to solve my issue and I noticed that there are not much info about the possible errors regarding SQL Logic error on ZeosDBO, most errors are regarding SQLite, that's not my case. So I decided to start this thread hopefully it'll be used by…
Mobius one
  • 171
  • 3
  • 12
0
votes
0 answers

ZEOSLib: Error Message from TZReadOnlyQuery

I have been using ZeosLib Components with Delphi and Lazarus for the past 10 years or so. I'm mostly using it to access MySQL Databases. Now I have run into a strange Problem with TZReadOnlyQuery. In my MariaDB database I have a pretty complex…
Heinzi Tuberkel
  • 75
  • 9
0
votes
0 answers

libmysql.dll error - works on number of machines, except new machine

I have written a db app using Delphi 10.4 Community and Zeos db components, client server using MySQL 8.0.27 server. I have this app running on 5 computers as clients on the same local network. The issue is I have set up a new computer which I set…
svtdoug
  • 15
  • 3
0
votes
0 answers

Client-Library sfound but could not be loaded. Check compile-target and library compatibility! - happens when want to connect to the database Lazarus

i just installed zeos on lazarus on linux mint device, and created database in phpmyadmin. when I enable Zquery to true, an error like this occurs enter image description here does anyone know why this is happening, did I write the LibraryLocation…
Rama Can
  • 1
  • 2
0
votes
0 answers

Error ZeosLib Open Query character $ in string query

When executing a query string with the $ character, example 'select id from table where fieldname = 'abc$', it is giving error , preparade statament does not exists Zeos Lib 7.2 Postgresql 9.6
Rogerio de Jesus
  • 1
0
votes
0 answers

Delphi and ZEOS access components returning just a single record from Oracle database

I am using Delphi 10.3 and ZEOS 7.2.14 to access an Oracle Database. One of my queries is only returning 1 record while the same query returns a lot of rows when run in Oracle SQL Developer. I have so far narrowed down the problem to a JOIN using a…
Marian Aldenhövel
  • 677
  • 1
  • 6
  • 24
0
votes
0 answers

Delphi 10.3 Android problem dll fbclient not found (Db firebird,Using Zeos)

I create Android apps with Delphi Rio 10.3, connection with Zeos, and database is Firebird. On Windows my apps work well, now I want make it to Android. When I finish compiled into my android cellphone, I get error: none of the dynamic libraries…
agung budi
  • 1
0
votes
0 answers

Delphi7, Zeos DB et Postgres

I'm working on an application in Delphi using PostgreSQL as a database. I'm actually getting a problem with the connection in design-time: when I try to run a simple query like : select * from article; I get a message which says that the table…
tanina
  • 1
  • 1
0
votes
1 answer

Install of Zeos Lib for Delphi 7 connectivity to PostgreSQL - can't build Example projects

I saw this post about Delphi databases. I'm in a similar situation to the OP with years of occasional use of Delphi, but never using the database features. I have both Delphi 7 and Delphi 2010, but for this purpose, I'm using Delphi 7 to add…
tim11g
  • 1,935
  • 5
  • 27
  • 41
0
votes
0 answers

Zeoslib new version encoding problem, strange charaters

I have installed Zeoslib 7.2.4 because of updating to Delphi 10.2 and after testing my projects the result of SELECT isn't expected. The previous version 7.1.4 Works fine. The results after updating to 7.2.4: Connection ClientCodePage is binary. If…
SAMPro
  • 1,068
  • 1
  • 15
  • 39
0
votes
0 answers

Oracle doesn't return all rows

I created a simple application for getting some data from Oracle. The application is written in Lazarus and uses ZeosLib and Oracle client (oci.dll) for connecting to the server. Oracle admin prepared me a View for getting my data. i don't knot how…
Stefan Batory
  • 1
0
votes
2 answers

Can't find libmysql.dll and others connecting to MYSQL from ZeosLib in Delphi

Excuse me, I would like to ask about how can I connect Delphi with MYSQL with ZeosLib. I already know the steps but I can't get it yet cause when I change the Properties in ZConnection where Connection = True, it can't. And this is the message By…
agawmd
  • 33
  • 3
  • 9
0
votes
0 answers

Write value on subselect SQL query column in dbgrid

I need a join table from table 1 and table 2 and be able to apply updates on it so here's my SQL: select table1.ackode, tabble1.ket, table1.debet, table1.kredit, (select table2.ket from table2 where table2.kode = table1.ackode …
mizkyd
  • 75
  • 1
  • 11
1 2 3 4
5
6 7 8