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

Migrating ZSQLProcessor.Script.Text from ZeosLib to FireDAC for MySQL

Was trying to migrate app to FireDAC usage on Delphi 10.2 and stuck only with this function: Source on github procedure TMainForm.ExecuteScript(script: string; memo: TMemo); var Log: TStringList; FN: string; begin ShowHourGlassCursor; …
Goaul
  • 943
  • 11
  • 13
0
votes
1 answer

Delphi 7 + Zeos 7.1.4 + libmysql55.dll connect with PostgreSQL move to MySQL

I'm trying to get data from PostgreSQL from another computer and move to MySQL on my local computer. I got libmysql55.dll from Zeos repository. I had to create a program to fix a lot of mistakes over database. One error is happening: SQL Error:…
Wellington Telles Cunha
  • 326
  • 2
  • 16
0
votes
1 answer

TADOBlobStream rewrite this class to ZEOS DB components and many more

Whenever ADO (DBgo) will be disontinued or someone wants to bring an ADO-Windows based application to the UNIX world withourt rewritting the application a translation of the ADO classes given in the unit unit Data.Win.ADODB; to new…
user9044066
  • 107
  • 2
  • 11
0
votes
0 answers

delphi - setting up database connection without connected to it

So, I am currently doing project for my branch office. I was making it there but right now I am away from office. I have set db connection with zeos which connected to local server of branch office that has database in it. However, right now I need…
mizkyd
  • 75
  • 1
  • 11
0
votes
2 answers

update multiple rows using dbgrid

I'm super new at coding and I'm making a simple apps now. So as you can see in the pic, I have multiple data in selected date. If I wanted to update every row with different values and do it with save button, what code should I do? Does my dbgrid…
mizkyd
  • 75
  • 1
  • 11
0
votes
0 answers

Delphi+Zeos: Same message, independent error: -1 record(is) updated

Well, I have an application ERP constructs in Delphi with ZEOS. Database is SQL SERVER. When happens some error, it doesn't return correct message, independent error, always return: -1 record(is) updated. Only one record should have been updated…
Dirceu Vieira
  • 19
  • 1
0
votes
1 answer

problems installing Zeoslib 6.6.6-stable on BDS C++ builder 2006

I'm having problems installing ZEOSLib 6.6.6-stable in BDS C++ Builder 2006. I only have C++Builder installed, no Delphi, but I can see the dcc32.exe file in the bds/4.0/bin/ folder. When I try to compile the packages with the Delphi compiler from…
Patowski
  • 5
  • 1
  • 4
0
votes
0 answers

Oracle CLOB Field Is Truncated/Gone When Saved With Zeos ZTable

I started few months ago in a company that uses Oracle 11g and I am building my first application for them. I have a simple table with a Name as Varchar2, a non-index number as Integer and a Text Field as CLOB to store some rules of each department…
NaN
  • 8,596
  • 20
  • 79
  • 153
0
votes
3 answers

Why is Delphi (Zeos) giving me widestring fields in SQLite when I ask for unsigned big int?

I am using the latest Zeos with SQLite 3. It is generally going well, converting from MySQL, once we made all the persistent integer field TLargeInt. But when we use a column definition unsigned big int (the only unsigned type allowed according to…
MarkAurelius
  • 1,203
  • 1
  • 14
  • 27
0
votes
1 answer

Delphi 2009 + Zeos + MySQL DBGrid displaying strings as (BYTES)

I have some troubles with the Zeos library in Delphi 2009. I have a MySQL database with utf8_bin encoding and when i'm trying to retrieve some strings from the DB and display it with a DBGrid the DBGrid is displaying the word (BYTES) and not the…
zaos
  • 1
0
votes
0 answers

Delphi MySQL field does not read entire value

I noticed something wierd in my application, and I cannot find a reason for it. Basically I have a field which is an identifier field, built from random letters and numbers... For some reason in the database, the full field value is shown(inside…
Marcel
  • 874
  • 1
  • 14
  • 28
0
votes
0 answers

SQlite3: EDatabase Error - Query - Cannot perform this operation on a closed dataset

I am using SQLite3 and Zeoslib on Delphi 2010. The following code is supposed to traverse through records in a table and update fields. So, it is within a while loop checking on END OF FILE condition. However, it never breaks but continually looping…
ThN
  • 3,235
  • 3
  • 57
  • 115
0
votes
1 answer

Delphi7 + ZeosDB date format error

I'm using Delphi 7 and ZeosDB on a application that connect to a Firebird and a SQL Server database but I'm with a problem when the field is date format. On Firebird work normally but when I change the connect to SQL Server the error is showed…
Rodrigo Ferraz Azevedo
  • 13
  • 1
0
votes
1 answer

MySQL and Zeoslib: None of the dynamic libraries can be found or not loadable (libmysql.dll) on Windows 8

I am working with MySQL server and Zeoslib with Delphi. My program can remotely connect to the MySQL database but not locally. However, it keeps raising the following error - "None of the dynamic libraries can found or not loadable..." So, I…
ThN
  • 3,235
  • 3
  • 57
  • 115
0
votes
1 answer

Zeolibs: Unknown column in Where clause

I am trying to execute a SQL query using Zeolibs but compiler keeps complaining with the following error - Unknown column in Where clause. ZQuery1.SQL.Text := 'SELECT * FROM new_table WHERE TagName = '+theSig.f.TagName; ZQuery1.ExecSQL; But I…
ThN
  • 3,235
  • 3
  • 57
  • 115
1 2 3 4 5
6
7 8