Zeoslib Portal

I create in firebird a text blob field:
BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE
COLLATE NONE
and I wanna read it into n lines of 25character per line.

how I can do it?

someone have some idea how I can add, delete, edit users in firebird using zeos?

Problems are not solved. After a lot of ZeosLib code studying I have understand how it manage schema. Infact I can't use ZConnection1.ExecuteDirect('set local search_path to test;'); or miore generic statement SET search_path = test; because zeos set schema in the follow way: 1. read sql statement 2...

I need to create a database ....
which is the best way?

This approach rise some problems while using more than one connections to database. We are trying to use different schemas from same database. These schemas have some table with the same name. So we have schema arc and schema arc_demo with the same table PRS Just try project in attachment using this...

I want to use different schema into the same database. In this way I can manage different set of data that I simply connect via trigger. So I have 1 database 5 schema and every schema contain my database... I want to set "schema" on ZConnection and not run this command before every query S...

seawolf wrote:ZConnection.GetTableNames('',list) where list is a TStrings containing a list of all tables (system tables too).
ZConnection.GetStoredProcNames('',list) where list is a TStrings containing a list of all stored procedures.

and how to discover a trigger?

How I can check if table or stored procedure o trigger exist
there are some ideas...

You prepare your two connections at runtime... could you post some sample code... just for check that your are set all parameters correctly

I will send them to mdaems so if he wants can publish it.
I just explain ZeosLib project, its history, how it's work with some example directly with delphi2007

This year at Delphi day organize by Marco Cantù we will speak about a lot of tools... and naturally we will held a session about Zeos Lib...

I hope mySQL will be opensource in the future... or we have to dismiss support in 7.x

I've seen this before when the dll version didn't fit with the server version. Difficult to find out what dll's fit to what servers. Are you using a 5.1 dll or one of the older mysql 5 dll's. Normally you should be able to use a 5.1 dll with the mysql5 protocol. Mark ok I will insert something to c...

mith wrote:I have this problem too. My solution is to call Connection.Reconnect before any query (like select, update, etc.) is executed. This is not good solution but work for me.

ot's really a NOT GOOD solutions...
in my project I have something like 5000 SQL command

I have the some problem only in one customer, with mySQL 5.1.30 installed on windows SBS 2003
any idea to trace it?