Search found 2733 matches
- 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 ...
- 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...
- 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...
- 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
Mark
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...