Search found 2733 matches

by mdaems
10.03.2013, 22:13
Forum: ZeosLib 7.0 Stable Forum
Topic: TZQuery Filtering oldvalue
Replies: 1
Views: 443

nelsonroda , What compiler are you working with? This may have impact here, I think, because here we're looking at TField behaviour which isn't zeoslib code, but vcl/fcl-db code. Is it possible to demonstrate this issue using a small command line program using our test database (included in the big...
by mdaems
10.03.2013, 22:00
Forum: ZeosLib 7.0 Stable Forum
Topic: How can I detect if the statement is a select or non select?
Replies: 1
Views: 523

Use Open and intercept the 'no dataset' error? Search for 'select' in the sql statement? Inside some dbc drivers we use the database client library to check this. But then you're already passing the query to the database library, something you probabl don't want to do yourself when using a component...
by mdaems
10.03.2013, 21:54
Forum: ZeosLib 7.0 Stable Forum
Topic: Firebird, Transactions, Manuals, examples ?
Replies: 2
Views: 1281

misko2k , There are a few examples in the downloaded zeoslib file. And when you check the Knowledge Base on this forum there are a few articles describing the use of simple zeoslib components. As Jan told : you need two connection objects here. These correspond more or less to 1 transaction over on...
by mdaems
10.03.2013, 21:45
Forum: ZeosLib 7.0 Stable Forum
Topic: Instal Delphi XE3
Replies: 3
Views: 1063

Hans-Dieter, If that's the problem, please read the package files for XE3 and check where the differences are between Win32-debug-mode and Win32-release or Win64-both. It's probably only a few settngs that haven't been adjusted by the person who upgraded the packages from a previous Delphi version. ...
by mdaems
10.03.2013, 21:33
Forum: ADO
Topic: Lazarus, Zeos and Ms Access (mdb)
Replies: 24
Views: 19157

No way to reuse the fpc sqldb classes as they are in a new fpc-only zeoslib dbc driver? As far as I understand they are free to use.

Mark
by mdaems
10.03.2013, 21:26
Forum: ZeosLib 7.0 Stable Forum
Topic: MSSQL fails the first transaction
Replies: 4
Views: 896

Hi, Seems like we have to find out where the second 'begin transaction' (lowercase) comes from. Because if that one is fired by zeoslib in the right place we can just ommit the uppercase version in TZDBLibConnection.InternalSetTransactionIsolation. Unless the lowercase version comes from your user q...
by mdaems
10.03.2013, 21:15
Forum: ZeosLib 7.0 Stable Forum
Topic: How to join two query's from two different databases?
Replies: 4
Views: 2380

Maybe a stupid idea, but testing looks like fun: Two connections + two zquery (one for each connection). Then join the TZQueries in a Master-Detail relationship. The linkfields then match the corresponding records from the dfferent databases, so you don't have to write the link logic yourself. Or no...
by mdaems
10.03.2013, 20:57
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Zeos support 3-tier?
Replies: 4
Views: 6628

What do you mean by 'supporting multitier'? If that's 'being able to connect to a remote database server and pass information to a remote client' : definitely. But that's not a zeoslib feature. It's a combination of what your database client supports (eg. the postgres client libs support connections...
by mdaems
10.03.2013, 20:50
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Upgrade Zeos 6.5.1 to 6.6.4 BIG PROBLEM
Replies: 2
Views: 6542

santigesualdo , If you really need both versions side by side I can only advise you to use a virtual machine for support of the old application. But I'd say : just try to upgrade from 6.5.1 to 6.6.4 for that application. 6.5.1 was an alfa version that became the 6.6-series. So converting should not...
by mdaems
01.02.2013, 13:01
Forum: MS SQL Server
Topic: Insert Statement failed
Replies: 9
Views: 3413

Hi Coolman1974, Did you effectively make the change you propose (literally) and retest the program with the new version? Because the change makes sense I think, but I can't really test it as I don't have the test suite running against ADO. So comparing old results to new results is not possible. I s...
by mdaems
01.02.2013, 01:21
Forum: ZeosLib 7.0 Stable Forum
Topic: [patch_done] single quotes in queries
Replies: 30
Views: 4904

Hi, Thanks for the test case. I also saw the ticket you logged at https://sourceforge.net/p/zeoslib/tickets/21/ When Michaels answer wasn't really clear, please be aware that our native language isn't english at all. And I happen to know he has some non-zeoslib related activities at the moment, so h...
by mdaems
30.01.2013, 22:31
Forum: Announcements
Topic: How to help developing/maintaining ZeosLib for volunteers
Replies: 0
Views: 2615

How to help developing/maintaining ZeosLib for volunteers

Hi all,

Michael wrote a small Tutorial about how you can join or help the currently very small development team.
You can find it here

You're welcome!
by mdaems
30.01.2013, 21:51
Forum: MS SQL Server
Topic: Insert Statement failed
Replies: 9
Views: 3413

This is strange. Seems like he's not using the 0 you assign to parameter :FIELD3.
Have you tried to use a TZSqlMonitor component to log what's exactly sent to the database?
by mdaems
30.01.2013, 21:48
Forum: 6.6 - stable
Topic: Why doesn't work a simple rollback to me (Zeos+D7+MySQL) ?
Replies: 1
Views: 1485

Did you try attaching a ZSQLMonitor to your project to see the exact SQL that's executed? That could maybe reveal what's happening behind the scene.
by mdaems
30.01.2013, 21:45
Forum: ZeosLib 7.0 Stable Forum
Topic: [patch_done] single quotes in queries
Replies: 30
Views: 4904

Joyce, Can you reproduce this using a simple console program against our test database tables? Or is it only giving errors when using components? Not asking you to write a real test case for our test suite (which would also be fine, of course ;) ). Just pick a table from https://sourceforge.net/p/ze...