Search found 2733 matches

by mdaems
25.11.2013, 11:09
Forum: ZeosLib 7.1 stable Forum
Topic: 0 record(s) updated. Only one record should have been update
Replies: 18
Views: 7866

Re: 0 record(s) updated. Only one record should have been up

Thanks, In this form it will be easiest to do the little patch manually: to remove the lines with a minus sign and add the lines with the plusses in the 2 named files. Of course, you can ignore comments and formatting only changes. As i wasn't sure if you're running an svn working copy version (and ...
by mdaems
23.11.2013, 00:22
Forum: ZeosLib 7.1 stable Forum
Topic: 0 record(s) updated. Only one record should have been update
Replies: 18
Views: 7866

Re: 0 record(s) updated. Only one record should have been up

I did some experiments. Seems like the % sign is only needed for Firebird tables with an underscore included ??? For some reason a table named blob_values can't be found using '... like "BLOB_VALUES"', but '... like "BLOB_VALUES%"' seems to work. Does somebody know why? (Or is it...
by mdaems
22.11.2013, 22:16
Forum: ZeosLib 7.1 stable Forum
Topic: 0 record(s) updated. Only one record should have been update
Replies: 18
Views: 7866

Re: 0 record(s) updated. Only one record should have been up

The function I was refering to is function TZAbstractDatabaseMetadata.AddEscapeCharToWildcards(const Pattern: string): string; But looking at TZAbstractDatabaseMetadata.ConstructNameCondition I wonder why I added % to the like string in case the pattern contains wildcards. I'm afraid I'll need an ex...
by mdaems
22.11.2013, 19:55
Forum: ZeosLib 7.1 stable Forum
Topic: 0 record(s) updated. Only one record should have been update
Replies: 18
Views: 7866

Re: 0 record(s) updated. Only one record should have been up

I agree with Jan. Option 3 is the way to go. But afaik there is some function that escapes wildcards. I did create it together with some other user, a few years ago. For a very similar use case.

Mark
by mdaems
09.11.2013, 23:16
Forum: ZeosLib 7.2 Forum
Topic: Delphi XE5 version for ZeosLib 7.2
Replies: 17
Views: 12070

Re: Delphi XE5 version for ZeosLib 7.2

There's also another solution : use the download snapshot feature of Sourceforge Subversion. -> Zeoslib project page (http://sourceforge.net/projects/zeoslib/) -> Subversion -> Browse to the right branch -> Click the 'Download Snapshot' link The short way : https://sourceforge.net/p/zeoslib/code-0/2...
by mdaems
24.10.2013, 08:37
Forum: ZeosLib 7.2 Forum
Topic: Feature Request - TZSQLMonitor "Exectime: 500ms"
Replies: 3
Views: 1043

Re: Feature Request - TZSQLMonitor "Exectime: 500ms"

Hi, This feature effectively adds overhead for all operations. So it's not something I really would consider adding. However, I think you can implement this feature by adding a custom LogListener. (The way we do it for the test suite). Then you can add your own timers at will. I don't know if you no...
by mdaems
17.10.2013, 20:29
Forum: ZeosLib 7.1 stable Forum
Topic: Parameter error in 7.1.2-stable
Replies: 11
Views: 4286

Logging

Michael, I probably expressed myself wrongly. The first proposal was just a starter idea for the second one. It was just the idea of sending one or more POINTERS to strings(or Z-equivalents)/objects/functions to the logmanager, so without doing string manipulations in the log calling method before t...
by mdaems
17.10.2013, 01:07
Forum: ZeosLib 7.2 Forum
Topic: 7.2 testers-thread
Replies: 514
Views: 120128

Re: 7.2-alfa testers-thread

Michael, Michal, I suppose there is some behaviour changes between 7.0, 7.1 a,d 7.2. This is/might be justified. Let's decide case by case. And file a bug report for each different case. So we can decide per case if it's a bug and how we can resolve it. To have a valid case we need: - a piece of cod...
by mdaems
17.10.2013, 00:43
Forum: ZeosLib 7.1 stable Forum
Topic: Parameter error in 7.1.2-stable
Replies: 11
Views: 4286

Logging bind values

Yeah, just make fun of a stupid old COBOL and PL/SQLprogrammer with only self study pascal/dephi experience... :mrgreen: OK, for the logging I was thinking about sending string/object and function pointers (=constants that don't need runtime calculation!?) only to the DriverManager.LogMessage (or si...
by mdaems
16.10.2013, 23:20
Forum: ZeosLib 7.1 stable Forum
Topic: Parameter error in 7.1.2-stable
Replies: 11
Views: 4286

Re: Parameter error in 7.1.2-stable

The test case I prepared. Fails for postgres , but seems to work for FB, SQLite and mysql. {** Bugs report UseParamTwice. Queries using twice the same parameter should not fail } procedure ZTestCompCoreBugReport.TestUseUnpreparableParam; var Query: TZQuery; begin if SkipForReason(srClosedBug) then E...
by mdaems
16.10.2013, 22:43
Forum: ZeosLib 7.1 stable Forum
Topic: Parameter error in 7.1.2-stable
Replies: 11
Views: 4286

Re: Parameter error in 7.1.2-stable

Update. Adding a test for using a parameter twice doesn't give failures. That works as expected. Looking deeper it seems like we have the (known) problem that the server can't decide on the datatype of a parameter because of the way it's used. Comparing a constant to null is possible, but it's impos...
by mdaems
16.10.2013, 21:22
Forum: ZeosLib 7.1 stable Forum
Topic: Parameter error in 7.1.2-stable
Replies: 11
Views: 4286

Re: Parameter error in 7.1.2-stable

Michael, I think using the same parameter name twice is quite a normal thing to do. Maybe we forgot about that when the CAPI was implemented. But... a fix we really need. Concerning the log : a record should w printed at execute time, containing all values that are bound. Have a look at the firebird...
by mdaems
29.09.2013, 12:24
Forum: ZeosLib 7.0 Stable Forum
Topic: ZTable linked with TEMPORARY TABLE
Replies: 4
Views: 2835

Re: ZTable linked with TEMPORARY TABLE

Hi, It should be possible to use temporary tables for all databases that show these tables as part of the normal metadata queries (eg. mysql). The main problem is that the metadata caches should be cleaned after creating new temporary tables and before opening the ZQuery or ZTable components. I have...
by mdaems
20.09.2013, 15:57
Forum: ZeosLib 7.1 stable Forum
Topic: Zeos 7.0.x and 7.1.x
Replies: 4
Views: 1198

Re: Zeos 7.0.x and 7.1.x

That's my idea too. As long as 7.1 is not declared stable, 7.0 should be maintained. However, I'm afraid we did backport too much lately. We had some reasons to do so, but not all of them were equally valid, I'm afraid. It's difficult to decide where a fix should be applied. And how it should be don...
by mdaems
11.09.2013, 07:58
Forum: ZeosLib 7.0 Stable Forum
Topic: 7.0.4 possible bug in ApplyUpdates with auto increment field
Replies: 13
Views: 6012

Re: 7.0.4 possible bug in ApplyUpdates with auto increment f

Thanks for your answer. What you mean with row by row? Can you give me a snippet of both examples you gave me? It's just because I never did the way you are proposing, so I don't know how to accomplish this. Best regards! Sorry, but I have no snippets available. And unfortunately at the moment I'm ...