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

Delphi SQLite insert into a table with primary key as Autoincrement

I am trying to migrate my app from mySQL to SQLite, and in order to do that I recreated all my mySQL tables in SQLite. I read about the fact that AUTOINCREMENT is not recommended to be used in declaring the actual autoincrement field. And instead…
user1137313
  • 2,390
  • 9
  • 44
  • 91
1
vote
1 answer

Delphi XE2 with Zeoslib and Oracle Connection

Can anyone help me in setting up ZeosLib 7.1.4a to connect to Oracle 11g Release 2 Standard database. Currently we are using Delphi XE2, oracle is installed and the tnsnames.ora file specifies the connections to our different servers and databases,…
GavinC
  • 53
  • 1
  • 9
1
vote
1 answer

TZQuery on Typhon IDE Returns Only 6 Fields Where It Should Returns 8 Fields

I am working on Typhon IDE (v.5.1 and FPC v.2.7.1)and am creating user login function, utilizing PostgreSQL 9.3 as database and Zeos 7.2 as data connector. I have this following code: // ZQ: TZQuery; zq := ExecSQL('SELECT '+ …
Buyut Joko Rivai
  • 188
  • 2
  • 6
1
vote
1 answer

Firebird Insert Distinct Data Using ZeosLib and Delphi

I'm using Zeos 7, and Delphi 2009 and want to check to see if a value is already in the database under a specific field before I post the data to the database. Example: Field Keyword Values of Cheese, Mouse, Trap tblkeywordKEYWORD.Value =…
Brad
  • 2,237
  • 5
  • 41
  • 69
1
vote
1 answer

Check if database connection is still alive

I am developping a Windows background service with Delphi 7 and ZeosLib 6.6.5. This service is going to run 24/7 and interact with a Firebird database (version 2.1) located on a remote server, so I'll need to check if the service is still able to…
RindekMalek
  • 13
  • 1
  • 3
1
vote
1 answer

Get the result of MySQL CREATE TABLE

I am using Zeos lib to access and use MySQL tables. Now I want to create table myself. I can catch errors regarding CREATE TABLE command, but I can not get the success result. For example if I use IF NOT EXISTS I don't know the tables created or…
SAMPro
  • 1,068
  • 1
  • 15
  • 39
1
vote
1 answer

Delphi 7 + Zeos: how to prevent sqlite 3 converting date and integer/float to string?

Test database: create table a ( d date not null primary key); create table b ( d date not null primary key); insert into a values ('2013-01-01'); insert into b values ('2014-01-01'); Using Zeos lib with Delphi 7, these queries all return…
nagylzs
  • 3,954
  • 6
  • 39
  • 70
1
vote
3 answers

ZEO ZODB database - run locally not working

I tried looking at the documentation for running ZEO on a ZODB database, but it isn't working how they say it should. I can get a regular ZODB running fine, but I would like to make the database accessible by several processes for a program, so I am…
chase
  • 3,592
  • 8
  • 37
  • 58
1
vote
1 answer

Extensions won't show after buildout and restart

I'm trying to install an egg in my Plone 4.3.1 environment (with ZEO). So I added the line "collective.quickupload" to my buildout.cfg file and ran buildout by using the following command: /usr/local/Plone/zeocluster# sudo -E -u plone_buildout…
Alex Miccoli
  • 29
  • 6
1
vote
1 answer

Zeoslib fails to read LargeInt fields from sqlite database

I'm trying to read sqlite database with ZeosLib components and Delphi XE2. Everything works perfectly, except when I try to read three timestamp values that are stored, which are basically 17 digit numbers. Instead getting the proper value, I get…
rsrx
  • 1,433
  • 1
  • 13
  • 25
1
vote
1 answer

How can I safely communicate with my remote data base in Zeos?

I use MySQL in a shared server account and my worry is if a hacker monitors the connection between my application and that MySQL server. Is that connection ciphered anyhow or is it raw data passing through (including at the connection time when Zeos…
NaN
  • 8,596
  • 20
  • 79
  • 153
1
vote
4 answers

TDBGrid doesn't update when multiple users are editing it

I am developing an application which has a simple database. All of the functions are going well but when a user is editing the database from the program, the other user cannot see the content immediately. The other user needs to close the program…
Chunk Chunk
  • 143
  • 6
  • 17
1
vote
0 answers

Simulate a click on DBGrid

I have done some searching and nothing is working. Using D5, Zeos and SQLite. I have a DBGrid and a DataSet (tblBricks) that is Filtered. In the DBGrid1.OnCellClick Event, I have tblBricks.Refresh; At run-time I can set focus to the appropriate Row…
user2220358
  • 123
  • 3
  • 10
1
vote
1 answer

Using multiple SQL queries

I have done some searching and can't find a definitive answer to this one. I am just getting into SQL so be gentle. Using D5, TNTUnicode, Zeos and SQLite3 I have a DBGrid with all the Account names in the tblAccounts showing. I have a DBGrid with…
user2175495
1
vote
1 answer

Temporary autoincrement column on Delphi + Zeos, multiple queries failed?

Let's say I have very simple table : CREATE TABLE Bands (Name VARCHAR(20) NOT NULL) ENGINE = INNODB; INSERT INTO Bands VALUES ('Hammerfall'), ('Helloween'), ('Haggard'), ('Therion'), ('Tarja'); And run a query : SET @i :=…
Muhammad Yassin Indra Buana
  • 41
  • 3
1 2 3
4
5 6 7 8