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

How can I delete the SQLite DLL when I'm finished with it if the OS thinks it's still in use?

How can I unlock or delete a file that is in use, so that I can delete it? The file in question is used by my own application. More specifically, my application is using the freeware Zeos Lib. When opening and saving my database the sqlite3.dll file…
user741875
2
votes
2 answers

Connect to SQL Server using ZEOS under WINDOWS

I want to connect to a SQL Server using ZEOS components under Windows, compiler is LAZARUS. Here is my function: procedure ConnecttoDatabase(Servername, Databasename: String; aConnection: TZConnection); overload; var DatabaseStr:…
user9044066
  • 107
  • 2
  • 11
2
votes
2 answers

Delphi null parameter in where

I have two ZQuery's - master and details, linked via detail.DataSource and sql parameters. Master sql: select key1, key2 from list Details sql: select * from list where key1=:key1 and key2=:key2 The problem is that when key2 is null the details is…
Anton Duzenko
  • 2,366
  • 1
  • 21
  • 26
2
votes
3 answers

Random error when loading project into Delphi XE6

From time to time, when I load a project into the XE6 IDE, the following error occurs This error results in the TZConnection component being removed from the Datamodule for some inexplicable reason. Note that the project has been loading without…
Brendan
  • 55
  • 1
  • 7
2
votes
1 answer

How to use TQuery with Oracle SQL syntax for variable assignments and Params?

In a regular Query on Oracle SQL we could use: var_user VARCHAR2(256) := 'eduard' select * from a_table where user_name = var_user If I use this code in Delphi's TQuery.SQL.Text I get the error Incorrect Token Followed By ":".. I believe it is…
NaN
  • 8,596
  • 20
  • 79
  • 153
2
votes
1 answer

Zeoslib won't allow switching database?

I use Zeoslib components to interact with my SQLite database file. I have several SQLite database files in a folder. So, I want to be able to open any one of them using Zeoslib component. However, it won't let me. It opens the first database…
ThN
  • 3,235
  • 3
  • 57
  • 115
2
votes
1 answer

DBGrid doesn't reflect the current dataset status with Zeos components in Lazarus

I'd like to know whether the TZQuery/TAConnection is capable to deal with the consecutive SQL statments and editing the database at the run time, that is : ZQuery.Close; ZQuery.SQL.Clear; ZQuery.sql.add('select * from…
Sonya Blade
  • 399
  • 7
  • 24
2
votes
0 answers

ZConnection does not work with FB 2.1

) I used to use Firebird 1.5. It works great but I need to make an incremental backup so it looks to me that I need to updgrade FB to at least 2.1 This is what I did, I un-installed 1.5 and installed 2.1 Flamerobin works fine. In my Delphi 7…
Jacek Wojcik
  • 1,223
  • 2
  • 19
  • 33
2
votes
3 answers

How to persist tables with master-detail relationship within a single transaction?

I'm trying to persist two tables with master-detail relationship in MySQL 5.6 using Delphi XE3 and Zeos 7.0.4. When I do ApplyUpdates on the master, the auto increment field stays with 0 as value. I need the auto increment value, so I can link the…
Leandro Jacques
  • 413
  • 5
  • 19
2
votes
1 answer

Unable to insert Unicode into SQL Server 2008 using Delphi ZeosLib and Delphi 7

I'm having trouble inserting Unicode into a SQL Server database using Delphi ZeosLib and Delphi 7, and then reading the inserted value. I've created a simple test program that first inserts and then queries the inserted value. The test table…
Joshua
  • 1,709
  • 2
  • 24
  • 38
2
votes
0 answers

How to embed MySQL (libmysqld.dll) using Delphi ZEOS

I'm trying to use embedded mysql database using libmysqld.dll (mysql 5.1) with zeos (7.0.3) in Delphi XE i put libmysqld.dll in the same directory, folder language\errmsg.sys folder data\belajar\biodata.frm,biodata.MYD,biodata.MYI,db.opt unit…
Erwan
  • 202
  • 3
  • 10
2
votes
1 answer

commit on MySql + Zeos lib

I use next code to post some records on a non autocommin connection: ZConnection1.AutoCommit := False; try ZTable1.Insert; ZTable1.FieldByName('name').AsString := 'John Doe'; ZTable1.Post; ZConnection1.Commit; except …
gogoloi
  • 627
  • 3
  • 8
  • 19
2
votes
2 answers

What is the solution for MySQL with Delphi XE2?

Zeos Lib still doesn't work for Delphi XE2. Anybody knows a free component set to deal with MySQL as good as Zeos/Interbase components?
NaN
  • 8,596
  • 20
  • 79
  • 153
2
votes
1 answer

How to check if a user is edting a table record before allowing another user to edit, not wait for post?

I am developing a web site of artists profiles and a desktop software to manage its database content. There are many operators that will receive in their in-boxes the same amount of pending records to be revised for approval and publish. The…
NaN
  • 8,596
  • 20
  • 79
  • 153
1
vote
1 answer

Zeoslib: How to tell if query is still processing?

I am using Zeoslib in Delphi to access a local MySQL database. I call a stored procedure with the TZQuery object: ZMakeRankedTable.SQL.Text := 'CALL MakeRankedTable(:tableA,:tableB,:SAMP_startTime,:SAMP_endTime,:Hourspan)'; This stored…
Mike Furlender
  • 3,869
  • 5
  • 47
  • 75
1
2
3 4 5 6 7 8