Search found 22 matches

by Sergiomaster
28.02.2016, 08:47
Forum: Interbase
Topic: Interbase 7.5, protocol , whats'up
Replies: 1
Views: 471

Interbase 7.5, protocol , whats'up

Hello, It's a long time, i don't went on this forum, i use only ZEOS for maintenance by now and Firedac for new Delphi Seattle programs. And altough i don't ever use interbase since Firebird 2 publication. So i ran in a "problem" when someone asked me " which protocol i used for Inter...
by Sergiomaster
17.02.2015, 09:39
Forum: ZeosLib 7.1 stable Forum
Topic: Creating a custom LoggingFormatter
Replies: 2
Views: 284

Re: Creating a custom LoggingFormatter

[Solved] I use this code type ... MyLoggingFormatter = class (TInterfacedObject, IZLoggingFormatter) private public function Format(LoggingEvent: TZLoggingEvent) : string; virtual; end; var ... myFormatter : MyLoggingFormatter; implementation ... { MyLoggingFormatter } function MyLoggingFormatter.Fo...
by Sergiomaster
12.02.2015, 09:17
Forum: ZeosLib 7.1 stable Forum
Topic: Creating a custom LoggingFormatter
Replies: 2
Views: 284

Creating a custom LoggingFormatter

Hello, Still writing my ZEOS tutorial after a long pause (:prog2: full time) I am trying to use a loggingformatter different of the default one , using the function TZLoggingEvent.AsString(LoggingFormatter) . But i d'nt undertand how to do that ? How and where do i declare this formatter ? for sure ...
by Sergiomaster
26.11.2014, 08:55
Forum: ZeosLib 7.1 stable Forum
Topic: Intransaction ?
Replies: 11
Views: 1223

Re: Intransaction ?

That was what i said . All SGBDR (good ones) need a transaction even for a 'simple' (select from) read ! Firebird , as we are talking about, apply this pinciple ! Checking MON$TRANSACTIONS and other Sytem Tables of the Frebird database will show this ! unfortunatly i don't remenber if we can have a ...
by Sergiomaster
25.11.2014, 08:00
Forum: ZeosLib 7.1 stable Forum
Topic: Intransaction ?
Replies: 11
Views: 1223

Re: Intransaction ?

I think you misundertood me All SGBD i know have the same behaviour they need a transaction for all SQL statement . when you open a Query SELECT readonly or not transaction is opened , read done, and closed in a 'same time' you don't have to close transaction explicitely . for exemple let say we hav...
by Sergiomaster
24.11.2014, 15:05
Forum: ZeosLib 7.0 Stable Forum
Topic: fetchrow
Replies: 2
Views: 779

Re: fetchrow

Hello FetchRow works ,i mean : i test it with Firebird and have the effect i hope. i wrote this "expérience" in a tutorial still in progress you can find here http://serge-girard.developpez.com/tutoriels/temp/ZeosDBO/ , :roll: hopping the tutorial is accessible ) if you want to only have t...
by Sergiomaster
24.11.2014, 14:54
Forum: ZeosLib 7.1 stable Forum
Topic: Intransaction ?
Replies: 11
Views: 1223

Re: Intransaction ?

Hello You are right. As far as I know TZConnection include a transaction this one is "active" by default => autocommit:=True Now , when you open a ZQuery (SELECT) transaction start , reads are done and then transaction is stopped . When you Edit a Dataset it is the post instruction that St...
by Sergiomaster
12.11.2014, 08:21
Forum: Firebird
Topic: Lazarus, Firebird and Blobs over the network, slow
Replies: 3
Views: 1316

Re: Lazarus, Firebird and Blobs over the network, slow

Hello, is not , as i understood, the usage of TZQuery properties cashedblob fot that ? from doc\html\parameters.html 6.2. Statement parameters cursor=<cursor name> - The given cusor name is sent to sql server. cashedblob=[yes,no] - This means that blob data fetch immediate if [yes] or used interbase...
by Sergiomaster
11.11.2014, 11:18
Forum: Interbase
Topic: Read-only?
Replies: 6
Views: 1511

Re: Read-only?

Hello,
an other was to use UDF rtrim and lTrim (as far i remember existing in Interbase 5.5)
shall something like

Code: Select all

Result := Inherited ConstructnameCondition(Pattern,'ltrim(rtrim('+Column+'))');

works ?
by Sergiomaster
30.10.2014, 08:36
Forum: ZeosLib 7.1 stable Forum
Topic: FRench translation
Replies: 6
Views: 1579

Re: FRench translation

hello , one string was/is missing , after line 268 (in last snapshot rev 3438) cSPreviousResultStillOpen = 'L''ensemble de données résultat précédent de cette instruction est encore ouvert'; and of course Zeos.inc comment on languages need to be updated :wink: // ENGLISH, GERMAN, PORTUGUESE, DUTCH, ...
by Sergiomaster
22.10.2014, 06:18
Forum: MySQL
Topic: Index Help Neede
Replies: 1
Views: 586

Re: Index Help Neede

Hello, Findkey is a 'bad habit IMO , findkey is looking in the loaded dataset (that was great with a paradox table, loaded in memory , but not for a table in a SGBD overall if not local) Use a ZQuery (or TZReadOnlyQuery) with a select containing a where clause . i.e SELECT * FROM CUSTOMERS WHERE IDN...
by Sergiomaster
18.10.2014, 09:57
Forum: ZeosLib 7.1 stable Forum
Topic: Informations needed for a tutorial
Replies: 8
Views: 1355

Re: Informations needed for a tutorial

Hello, it might be a good idea if you learn to use our test-suites. If you find leaks of implementations it would be sufficent to add a test. Then i can fix the newly fails/exceptions... agree , but ... we all have family and a job as you say Why i'm writing this? 1. I would like to propose you star...
by Sergiomaster
18.10.2014, 06:57
Forum: ZeosLib 7.1 stable Forum
Topic: Informations needed for a tutorial
Replies: 8
Views: 1355

Re: Informations needed for a tutorial

We really have a huge Problem: Documentations, Exemples and tutorials.. Agree , I use the 7.1.3 stable version as basis / D7 (older but the main used i think) :nerd: the deeper i go , the tutorial is going to be a manual (i am enable to forget any functions/procedures/properties i encounter ) exami...
by Sergiomaster
12.10.2014, 08:01
Forum: ZeosLib 7.1 stable Forum
Topic: how to check firebird server service is running ?
Replies: 2
Views: 985

Re: how to check firebird server service is running ?

Hello , I ran also in that issue (wifi out of range) . my workaround was first to use the TZConnection.DbcConnection.Ping (i saw also yesterday a TZConnection.DbcConnection.Pingserver difference ?) but the time out seems to be too long . I use François Piette ICMP unit instead (only one unit of his ...
by Sergiomaster
12.10.2014, 07:44
Forum: ZeosLib 7.1 stable Forum
Topic: Informations needed for a tutorial
Replies: 8
Views: 1355

Re: Informations needed for a tutorial

Hello micheal Go on asking, i'll do my best for a tutorial. Hope you'll provide the results and we can add them to the forum? for sure , i will submit it (but not translate it i am afraid) . I will need , i think some technical volunteers to verify my writings also to check if there are big mistakes...

Go to advanced search