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
7
votes
8 answers

Database connectivity Delphi

I'm using delphi for years, but never for database stuff, but recently started researching and testing. I must say, i'm impressed, most of things happens automatically, i'm used to write by hand in php and python. i'm going to develop a commercial…
arthurprs
  • 4,457
  • 3
  • 26
  • 28
5
votes
4 answers

Multiple statements Delphi TZquery (Zeos) error

im trying to make a multiple statement query like this : // without the second insert the query works fine. // i need 2 querys to work because later, i'll do inserts on different kind of tables. // that's why i need 2 querys, not a single query…
Rebelss
  • 364
  • 1
  • 5
  • 15
5
votes
1 answer

Redirect TCP MySQL connection to proxy

I have a Delphi application which connects to a MySQL published database on Internet with address like mysql01.example.com:3306. However, my client computer is behind a proxy and I just can connect if I pass by the proxy. I use the ZeosLib to…
André Scaravelli
  • 251
  • 1
  • 4
  • 9
4
votes
1 answer

PostgreSQL: Capture RAISE NOTICE from a client connection via ZeosLib/Lazarus

I have developed a client application that use PostgreSQL 8.4 RDBMS. My Application is written in Lazarus and ZeosLib 7.2 for database access. I use a lot of stored procedures and in specific point I use raise notice to get info of the procedure…
AndreaBoc
  • 3,077
  • 2
  • 17
  • 22
4
votes
1 answer

Determine a parameters data type in a parameterized query using Zeoslib

Is it possible to determine a parameters data type in a parameterized query using Zeoslib and Firebird? I'm migrating from FibPlus to Zeoslib. with a stament like 'select name, surname, age from members where registration > :since and nationality =…
maz
  • 41
  • 3
4
votes
1 answer

Mysql ZeosLib Delphi XE3

I would like to know how I can save a query in memory to display in DBgrid, my current application is using : TZConnection > TZquery > DataSource > DBgrid works fine but the problem here is, after a call ZConnection.disconnect the dbgrid is…
Rebelss
  • 364
  • 1
  • 5
  • 15
3
votes
1 answer

TDataset and TMemDataset

I need to iterate through a number of MySQL queries and save them in an array of TMemDataset's. This seems to do it: MemDataset1.CopyFromDataset(ZQuery1,True); However each time the query changes, all the previous TMemDataset's are changed to…
Mike Furlender
  • 3,869
  • 5
  • 47
  • 75
3
votes
1 answer

Zeoslib: How to tell when query execution is complete?

I am using ZeosLib within Delphi to call a MySQL stored procedure through the TZQuery object. Immediately after MySQL finishes execution of the stored procedure I need to initiate my next block of code. I added a SELECT 1; statement at the end of…
Mike Furlender
  • 3,869
  • 5
  • 47
  • 75
3
votes
2 answers

Can select ... into outfile not save it into a file, but save it in blob instead

I want to do a select * from x into outfile 'c:/test.csv'. But instead of saving into an outfile test.csv I want to save it into a blob field. I'm starting the query from a client on Windows. The MySQL server is on a server on Windows or Linux (can…
Johan
  • 74,508
  • 24
  • 191
  • 319
3
votes
5 answers

Using @variables:= in delphi query does not work

I have the following problem. ZQuery1.SQL.Text:= ' SELECT '+ ' IF(q.rank2 = 1, @rank:= 1, @rank:= @rank + 1) AS rank '+ ' ,q.* FROM ( '+ ' …
Johan
  • 74,508
  • 24
  • 191
  • 319
3
votes
3 answers

How to find out which field was changed in a delphi 6 TZTable via ZeosLib

I have a TZTable (ZEOSlib) bound to a DBGrid now I need to know which particular TField was changed by the user. I tried with if NOT (taPositionenArtNrGH.NewValue = taPositionenArtNrGH.OldValue) then ShowMessage('ArticleNumber changed'); I…
Michael
  • 328
  • 2
  • 18
3
votes
1 answer

Delphi: how to create Firebird database programmatically

I'm using D2K9, Zeos 7Alpha, and Firebird 2.1 I had this working before I added the autoinc field. Although I'm not sure I was doing it 100% correctly. I don' know what order to do the SQL code, with the triggers, Generators, etc.. I've tried…
Brad
  • 2,237
  • 5
  • 41
  • 69
2
votes
2 answers

ZeosLib with MYSQL's shared memory protocol?

I started up my local MYSQL server with the shared memory protocol turned on. How can I connect to my server with ZeosLib? Where do I specify that it is using shared-memory? I am using Lazarus(freepascal), although the directions would be the same…
Mike Furlender
  • 3,869
  • 5
  • 47
  • 75
2
votes
3 answers

How to transfer a multidimensional array to a MySQL table (through Zeoslib)?

I am using the Zeoslib library in Delphi. I have a large multidimensional static array that I need to transfer to an empty table in a local MySQL database. How can I do this efficiently? Just iterate through a million insert statements?
Mike Furlender
  • 3,869
  • 5
  • 47
  • 75
2
votes
1 answer

Conversion from C++ to Delphi (simple)

I have a function in C++ that I am attempting to replicate in delphi: typedef double ANNcoord; // coordinate data type typedef ANNcoord* ANNpoint; // a point typedef ANNpoint* ANNpointArray; // an array of points bool…
Mike Furlender
  • 3,869
  • 5
  • 47
  • 75
1
2 3 4 5 6 7 8