Author Archives: zeos

Closing of National Mirrors

Dear Visitor,The ZeosLib Team has decided to close all international mirrors and keep just the main (english) site running. While this is only a temporary measure, the mirrors will probably be out for some time. The official date on which … Continue reading

Posted in Uncategorized | Leave a comment

ZeosDBO 6.5.1-alpha released

ZeosDBO 6.5 continues 6.x branch by adding new valuable functionality into well known database components. In the new version you’ll get drivers for Oracle 9i, SQLite 2.8, MySQL 4.1, PostgreSQL 7.4, most wanted Midas/DataSnap IProviderSupport interface and many other features … Continue reading

Posted in News | Leave a comment

Patch #1 for ZeosDBO 6.1.5

There is a patch for 6.1.5 available in the Download section. Please apply the patch to the 6.1.5 source and recompile. This patch addresses the following problems: Fixed Bug#985629 Locate and Lookup don’t find float fields. Fixed Bug#988462 Query.RowsAffected returns … Continue reading

Posted in Announces | Leave a comment

FreeDbConv Version 1.63 Released

cforce writes “New:* support for postgresql-7.4, sqlite, sqlite-2.8, oracle, oracle-9i, mysql-4.1, ado* changed interface* speed improvments BugFixes:* fixed Win2k bug* interbase & firebird import* autocommit bug / autocommit cycle* out of bound bug if status file is messed up http://www.mediashark.de.vu”

Posted in News | Leave a comment

ZeosDBO 6.5.0-alpha released

ZeosDBO 6.5 continues 6.x branch by adding new valuable functionality into well known database components. In the new version you’ll get drivers for Oracle 9i, SQLite 2.8, MySQL 4.1, PostgreSQL 7.4, most wanted Midas/DataSnap IProviderSupport interface and many other features … Continue reading

Posted in Announces | Leave a comment

Unit for fast preparing and executing SQL scripts

GAF writes “Design time application development is good for small or middle projects. But when count of forms in the project is more than 10 and number of queries on each form is more than 3 it’s too hard to … Continue reading

Posted in Code Hacks | Leave a comment

How to create a database, tables and triguers

OCTweak writes “Create a new application and add a ZConnection and a ZSQLPROCESSOR to the formAdd a button, name it CreateBtn and add the following click event for it procedure TForm1.CreateBtnClick(Sender: TObject);varHstName, PathName, DBName, Props: string;beginHstName := ‘192.168.0.1’; // if … Continue reading

Posted in Code Hacks | Leave a comment

How to define transaction isolation level during connection

OCTweak writes “procedure TForm1.ConnectBtnClick(Sender: TObject);beginZConnection.Properties.Clear;ZConnection.HostName := ‘192.168.0.1’; // ip where Firebird is installed or leave blank if embed;ZConnection.Database := ‘c:fibdatabasesTEST.FDB’;ZConnection.User := ‘sysdba’;ZConnection.Password := ‘masterkey’;ZConnection.Properties.Add(‘codepage=ISO8859_1’);ZConnection.TransactIsolationLevel := tiNone; // use ZDbcIntfs// ==============================// IMPORTANT//The first element in every TPB must be the isc_tpb_version3 … Continue reading

Posted in Code Hacks | Leave a comment

Transactions, Locking, ZeosDBO, and You (Part 1)

Merlin writes “The ability to understand and transactions and use them from within your application is what makes you a truly great database developer. This article explains how to incorporate transactions into your database development strategies. A follow up artical … Continue reading

Posted in Manuals | Leave a comment

Suggestion: remove drivers from ZConnection.pas and move to other unit

ssamayoa writes “A few days ago I began to test Zeos because I like the idea to make single applications which targets diferent dabatase servers, in my case Im interested on supporting Firebird, Oracle and MS SQL Server. What I … Continue reading

Posted in Code Hacks | Leave a comment