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

how to sort data on a dbgrid in delphi 7

hello i am new to zeos datasets and i would like my db grid to sort the data in an ascending or descending mode. i am using zeos datasets and a firebird database. i tried searching and this is all i got procedure TForm1.DBGrid1TitleClick(Column:…
Chunk Chunk
  • 143
  • 6
  • 17
0
votes
0 answers

SQLite3 and Refresh after deleting a record?

two hours of searching and reading and I am no closer. Using D5, Zeos v6 SQLite I have Table with the rows displayed in a DBGrid. All fine. I use DELETE FROM tblOne WHERE Acct="FirstEntry" and it deletes the only row that matches. Still all fine -…
user2175495
0
votes
1 answer

Zeos 7 Failing to install

I have installed the Zeos 7 Beta on my own machine but it fails on my client's laptop. We're both running Delphi xe2, his is Entreprise, mine is Pro. His machine is running 64-bit windows 7, mine is running Window 7 32-bit. When I do Compile all on…
Mark Patterson
  • 417
  • 2
  • 6
  • 15
0
votes
2 answers

ZeosDb : Encrypt SQLite

I am using ZeosDB component to access sqlite database. It works fine on an unencrypted db. On a encrypted db i receive : file is encrypted or not a database. Eaven if I set the password. Is the DLL file I use wrong ? I use the last dll from the…
opc0de
  • 11,557
  • 14
  • 94
  • 187
0
votes
2 answers

How to fix a count() in a query with a "group by" clause?

I have a function that gets a SQL code and inserts a count field in it and executes the query to return the number of rows in it. The objective is to have a dynamic SQL code and be able to get its record count no matter what code it has, because I…
NaN
  • 8,596
  • 20
  • 79
  • 153
0
votes
1 answer

Unicode filenames with zeos / sqlite

I need to save data in sqlite databases with user-chosen filenames. This includes unicode filenames. Is there a way to specify this in the Zeos components in Delphi?
Tobias Langner
  • 10,634
  • 6
  • 46
  • 76
0
votes
1 answer

Do ZeosLib DataSets need to perform FetchAll method to return real real total rows?

In Firebird/Interbase databases we have the TIBQuery, TIBTable and TIBDataSet, which have the FetchAll method to count how many rows that data set has. If we don't call that method, these data sets only register as "total" the number of rows that…
NaN
  • 8,596
  • 20
  • 79
  • 153
0
votes
1 answer

Can we create a virtual table with temporary information from the select command (not other tables)?

I need to fill up a TDBLookupComboBox with the options for a ENUM column: MOD_MARKETING ENUM('NENHUMA','CONSULTAR','CADASTRAR','GERENCIAR') But I do not want to create a new table in the database project just for that. I don't want to use…
NaN
  • 8,596
  • 20
  • 79
  • 153
-1
votes
2 answers

Rad Studio Delphi XE and PostgreSQL

I'm starting a new project, and this must be done in Delphi, so we get Rad Studio XE (not XE2). I have never wrote code in Delphi, I'm a C#.NET-MSSQL experienced programmer, that's why this project is exciting. For DB, we cannot afford MSSQL, but…
BlackCath
  • 816
  • 13
  • 23
-1
votes
2 answers

Delphi ZeosLib [Incompatible types: 'TZConnection' and 'TZAbstractConnection']

I have a system in Delphi 7 with zeos 6 in which I use the following function: function zIncCodeByYear (zQry : TZquery; ....): String; var zConLocal, zConOriginal : TZConnection; ... begin bActive := zQry.Active; zConOriginal := …
Sidon
  • 1,316
  • 2
  • 11
  • 26
-1
votes
1 answer

EZSQLException handling with message "SQL Error: Can't connect to MySQL server on xxx.xxx.x.xx(xxxxx)."

I am working with MySQL server, Delphi and Zeoslib. Whenever I try to connect to my MySQL server running in another machine and it is shutoff on purpose, it throws an exception that it can't connect. I want to be able to suppress this exception or…
ThN
  • 3,235
  • 3
  • 57
  • 115
-1
votes
1 answer

Does ZeosLib allows remote connection to MSSQL in Android?

I would like to know if ZeosLib is ready to be used with Android FMX for accessing MSSQL remotely, like it does in x32. If not, Is there any external component pack or built-in solution in Delphi that does?
NaN
  • 8,596
  • 20
  • 79
  • 153
-1
votes
1 answer

Zeos and/or SQLite crashing with Memo

I have a VARCHAR2 Field of 10,000 Bytes and during the initiating process Zeos crashes with invalid data size. Stepping through it, the Size in question, Zeos shows 4,223,943 which I would agree, should be invalid. Currently it appears that SQLite…
user2175495
-2
votes
1 answer

Delphi SQLite Error: Constraint Failed

I am having this common error and can not figure what it's causing that This is the procedure to import data from CSV file procedure TForm1.importarData; var S,D: TStringList; fecha:TDate; hora:TTime; i,j: Integer; FileName,Aux: String; …
Martin Ocando Corleone
  • 134
  • 13
-2
votes
1 answer

requested database driver not found on delphi 7

I have installed ZEOS on my Delphi 7 and tried connecting to a Firebird database. After I put the db path to the object inspector and tried to connect to it, Delphi always displays a message requested database driver not found. I have installed the…
Chunk Chunk
  • 143
  • 6
  • 17
1 2 3 4 5 6 7
8