Zeoslib Portal

Hi, I will back to use (and hopefully can give contribute :) ) Zeoslib when Zeoslib implements unicode, I am interesting with many features of this library. I am user of MSEide (FPC) with fully implement UCS2 to all string in GUI text. I have some question about new Zeoslib features : 1) What is dat...

Is it possible to switch language ZeosLib at runtime. My purpose is if my application use english, zeos use english too, if my app use indonesia, zeos use indonesia too, etc. If it is possible, how I can do it?

wahono

First time I use ZeosLib, I got this problem too. IMHO, you should rename libmysql.dll to libmysql51.dll. Maybe you have more than one MySQL Server with different version

wahono

Hi, Did first investigation. One of the involved factors seems to be the Transaction Level setting tiNone. When that setting is used Commit and Rollback are not sent to the server. (Trick to do this kind of tests : add a TZSQLMonitor to your project.) This will involve some more study, I'm afraid. ...

IMHO, TZConnection.ExecuteDirect seems like a function, which by the way, works very well, that would not respect the transactions. But if it came to support , no problem ;) I think query that is executed from anywhere, from tzquery or from tzstatement or from tzconnection.executedirect should can ...

When you try execute one of steps, than you click show data, it seems all of these steps is right. But you should close form and connect database again to see this effect.

All steps without error message, here is the test project.

I set zcon (TZConnection).autocommit=true. I try with 3 way to use transaction (database : MySQL 5.1, IDE : MSEgui, Lib Version : Last test trunk) 1. Record can append normally. zcon.starttransaction; zcon.executedirect('insert into salestrans (transid) values (''coba4'')'); zcon.commit; 2. Record c...

Thanks, I am usually feel 20 years old. But currently was 31 years.

wahono

At the moment, I am using FPC 2.3.1 trunk. I think should add define for this version in zeos.inc (If I am not wrong)

{$IFDEF VER2_3}
{$DEFINE FPC2_2UP}
{$DEFINE FPC2_1UP}
{$ENDIF}

wahono

Thanks for your info, I will try it. My purpose is I want to get list of grouping field value from filtering tdataset. When we make filter for TZ*Query, I want to show list of field value that can be choose by user, so the value for filtered field is value from original resultset only (but grouped/u...

Is it possible to get partial parsing of SQL in TZQuery? For example I set SQL with SELECT * FROM product WHERE code LIKE '001%', I want to get "WHERE code='001'" from TZQuery.

wahono

I have this problem too with MSEide and ZeosLib last trunk (Testing Branch). Memory increase every 4 kb, without another operasion, just move record with tdbnavigator.

Hi Mark, you can see it with dbnavigator, and move record more times, and you can see at task manager, memory is increased.

regards

In FPC 2.2.0 these property is exists. Thanks.

In unit ZAbstractRODataset.pas, class TZAbstractRODataset, there are two property with conditional compile to FPC is without these property : {$IFNDEF FPC} property BeforeRefresh; property AfterRefresh; {$ENDIF} But these property is exists in FPC, I think this conditional should be removed. wahono