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
2 answers

Zeoslib - loop over calculated fields

I have a Delphi 7 project using Zeoslib 6.6.6 and Sqlite3. On the form I have a Zquery selecting everything out of a sample database table along with a bunch of calcuated fields (TFloatField; TCurrencyField). The OnCalcFields event of the query runs…
Andrew
  • 73
  • 5
1
vote
1 answer

SQLITE query GROUP BY with SUM Using Delphi and Zeos

I have an app created using Delphi XE3 accessing the SQLite database with Zeos Component. A select command in SQLite that return 3 rows: select p.descricao, pg.valor from pagamento pg inner join venda v on pg.origem = 'venda' and v.id_venda =…
Márcio Rossato
  • 971
  • 1
  • 11
  • 20
1
vote
1 answer

Strange ZQuery behavior

I'm using Zeos and SQLite3 DB in Delphi ZQuery2.Close; ZQuery2.SQL.Clear; ZQuery2.SQL.Add('SELECT * FROM users WHERE un = ' + QuotedStr( UserName ) ); ZQuery2.Open; OutputDebugString(PWideChar( ZQuery2.FieldDefList.CommaText )); // log :…
Somebody
  • 703
  • 1
  • 7
  • 23
1
vote
1 answer

Keep RichEdit Formatting as a String?

I am assigning a string to a custom type I have declared, which I Read/Write using the TTreeViews Node.Data property. I read and write to and from the node, something like this: Read: RichEdit1.Lines.Text :=…
user741875
1
vote
1 answer

Setting a column on TZQuery.ParamByName

I need to run a SELECT statement where the column names are variable, as follows: query.SQL.Text := 'SELECT A.:COLUMN '+ ' FROM A '; query.ParamByName('COLUMN').AsString := 'column_name'; query.Open(); But when I do…
Rodolfo Donã Hosp
  • 1,037
  • 1
  • 11
  • 23
1
vote
0 answers

Problems with some chars in insert mode DBEDIT in lazarus + zeos + access

I am having an issue using Lazarus + zeos + access in some characters (Ç, ~, í ... ) The problem is a bit weird, sometimes i can insert properly, but sometimes the characters go crazy, example: When I am typing it is ok, the ç and ã BUT when I exit…
Leonardo Floriano
  • 35
  • 7
1
vote
2 answers

How to write LONG RAW data using OCI and Lob locator?

I want to fix zeoslib bug in writing long raw data bug description: Memo1.Lines.LoadFromFile('c:\t\ZDbcMetadata.pas'); // file size ~ 170Kb ZQuery1.SQL.Text := 'insert into t1(id, b) values(10, :p1)'; ZQuery1.Params[0].AsBlob :=…
Jk.
  • 443
  • 1
  • 3
  • 8
1
vote
1 answer

How to get always fresh data with Zeos TZConnection and TZQuery (in AutoCommit mode)?

I have Delphi application with TZConnection in AutoCommit mode (connecting to the Firebird 3.0) in the global DataModule, this single connection serves all the queries in all the datamodules of the application. But I have the problem, that the…
TomR
  • 2,696
  • 6
  • 34
  • 87
1
vote
1 answer

Converting ConnectForm fields from ZeosLib to FireDAC

Delphi 10.2.2 1. Is this correct way to convert this code part for MySQL from ZeosLib to FireDAC? ZeosLib: procedure TMeConnectForm.edExit(Sender: TObject); begin try MainForm.MyTrinityConnection.Password := edPassword.Text; …
Goaul
  • 943
  • 11
  • 13
1
vote
1 answer

Return value using alias name

I wrote code like this : sql1 :='select sum(jumlah) as debet from kasir_kas_transaksi where flag in (1,3) and tanggal = to_date('+quotedstr(after)+','+quotedstr('dd-mm-yyyy')+')'; with zquery1 do begin close; sql.clear; sql.Add(sql1); …
mizkyd
  • 75
  • 1
  • 11
1
vote
1 answer

ZEOS On Delphi7 - ZQuery1.Open -> very slow

i'm using Delphi-7 and zeos 6.6.4 (and just now upgrading to zeos 7.1.4) upon bigger rows of a table, things become very very slow on query. Not so much rows either (on salesdetail my table got around 200k rows). after I backup and clean the table,…
Stevanus Lianto
  • 13
  • 5
1
vote
1 answer

Delphi 2007 ZeosLib 6.6 Mysql 4.1 Transaction lock table from other client

The situation is this. I have two client programs that connect to the same mysql db on a server. When I run an operation on a table in the following way ZCon.TransactIsolationlevel := tiSerializable; ZCon.AutoCommit := true; …
Daniele
  • 177
  • 14
1
vote
1 answer

Are there SQLite commands that can output a select query as a SQL insert commands?

I am using Zeoslib to create in-memory databases with SQLite, and I need to the save the database onto disk when the program closes or dump it to a file regularly. As the SQLite3 program cannot handle in memory databases, is there a way to get…
vfclists
  • 19,193
  • 21
  • 73
  • 92
1
vote
2 answers

Delphi - ZEOS MySQL - access denied

I am trying to connect to my mysql database server (version 5.6) on the web, from Delphi 7 application... With Mysql Workbench, it works OK, i can run select queries with my test user (the same user that not working in Delphi 7)... In Delphi, where…
Fero
  • 35
  • 1
  • 1
  • 8
1
vote
1 answer

Delphi ZeosLib: Hot to enable Sqlite3 foreign_keys?

I'm using ZEOSDBO-7.1.4 with Delphi 7 to manage my application sqlite3 database. I've created some foreign keys to allow DELETE CASCADE remove rows from the details table. But by default foreign keys disabled, so you have to enable it at the…
Dr.eel
  • 1,837
  • 3
  • 18
  • 28
1 2
3
4 5 6 7 8