Zeoslib Portal

ism wrote:And how best to ?

I don't know.

Zeos components can be installed in MSEide ?

Yes, although not tested with Zeos 7.0. Please compile MSEide with -dmse_with_zeoslib or use the project apps/ide/mseide_zeos.prj in order to install components for Zeos 6.x in MSEide.

Hint: Contrary to Lazarus MSEide+MSEgui uses UnicodeString instead of utf-8 encoded AnsiString, so {$ifdef FPC} probably is not the optimal compilation condition.

Martin

Search for ssleay.dll on your system, you probably will be surprised how many versions you have, a file search on my HD returned 10 different instances. :-) The Postgres client library (libpq.dll) must be linked with ssleay.dll in the Postgres package. A simple workaround is to copy bin\libpq.dll an...

Try to write the records in a single transaction otherwise there will be a fsync on every write of a record which slows down updating speed. I don't know how it is done in Zeos, MSEgui has a dedicated tmsetransaction component and a slo_transactions flag in tsqlite3connection.options. It is off by d...

I'm sorry, but I do NOT see the benefit of adding separate string types in solving this 557 case. We used the approach with an own string type definition with success in MSEgui. MSEgui uses the types msestring and msechar for almost all strings. At the start of the development msestring was mapped ...

So we changed the call and added the charactersetid parameters. In case of Delphi : 0, in case of FPC : 871. These values are hard-coded for every compiler because: - Value 0 doesn't change current behaviour and it worked for Delphi before - FPC version now works (at least for Edson :) ) This proba...

Do I understand correctly that when you retrieve the data again using a Lazarus DBGrid it appears correctly? This looks more like a lazarus error... A possible explanation: Lazarus uses utf-8 encoding for all GUI text elements. If the database is not encoded in utf-8 the DB string values must be co...

MSEide+MSEgui has tactivator for that purpose (tab NoGui in component palette). http://sourceforge.net/project/showfiles.php?group_id=165409 Just released rev. 2.0beta1 BTW. Set the controller.activator properties of the DB components which you want to activate to the inserted tactivator component. ...

I can write how it works in MSEgui: Strings are converted from the current locale encoding or utf8 (if tmsesqlquery.controller.options dso_utf8 is set) to UCS2 at data fetching and back to the current locale encoding or utf8 at posting to the database. All strings in MSEgui are UCS2 encoded. So if y...

Not exactly on the subject, but MSEide+MSEgui has ZeosLib integration too, in addition to the sophisticated native MSEgui DB components.

http://sourceforge.net/projects/mseide-msegui

Martin

@piper62:
MSEide+MSEgui has tsqlresult, a resultset with a single record buffer.
Please compile the IDE with -dmse_with_zeoslib to get the ZeosLib components integrated.
http://sourceforge.net/projects/mseide-msegui

Martin

MSEide+MSEgui version 1.4 for FPC 2.2 has been released:

http://sourceforge.net/project/showfile ... _id=165409

Have a lot of fun!

Martin

MSEgui implementation of DB events is in lib/common/db/msedbevents.pas, mibconnection.pas and mpqconnection.pp. Feel free to use code pieces from MSEgui for ZeosLib if you find them useful.
Querying of asynchronous notifications by SQL select statement is not possible AFAIK.

Martin

Or use DB events? MSEgui has them for FireBird and PostgreSQL (component tdbevent).

Martin

Strange, it works for me with Protocol "mysql-5". The create script:

CREATE TABLE `table1` (
`pk` int(11) NOT NULL auto_increment,
`int1` int(11),
`text1` varchar(20),
PRIMARY KEY (`pk`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8