Search found 278 matches

by gto
23.10.2006, 15:50
Forum: MySQL
Topic: MySql Administration
Replies: 2
Views: 1084

MySql Administration

Hello! First: Yes, it's a bit off-topic, but I didn't find a better place :) I'm starting with MySql and Zeos (I've only used Interbase/Firebird until now) and I'm in need of a good administration tool, to make, alter and delete databases and stuff. For Interbase/Firebird I use IbExpert, a very comp...
by gto
18.10.2006, 15:35
Forum: 6.1.5
Topic: Problem with ZQuery filter
Replies: 4
Views: 4142

The best way is always to limit the query result on server side. But, as a quick 'n dirty fix, you may try this where you set the filter: ZHistorique.DisableControls; try ZHistorique.Filtered := false; ZHistorique.Filter := 'client = ' + strClient; ZHistorique.Filtered := true; finally ZHistorique.E...
by gto
13.10.2006, 14:34
Forum: Feature Requests
Topic: [bug_fixed] New Feature: LinkedFieldNames Vs IndexFieldNames
Replies: 15
Views: 6026

Hello people! Some ideas: I've never used the "old" IndexFieldNames for master detail relationship. This post explain the method I use, which, from my view, is quite more "clear". I know that IndexFieldNames is used in TTable for master/detail and should confuse some people that ...
by gto
09.10.2006, 22:06
Forum: User Contributions
Topic: More details for ZSQLMonitor
Replies: 3
Views: 3835

fduenas wrote:Hi. Thanks. But what si the revision of the files that you modified?
Currently we're on rev 108.
I've did it over the 105 release. Should I update my repository and then make a new patch?
by gto
09.10.2006, 18:23
Forum: User Contributions
Topic: More details for ZSQLMonitor
Replies: 3
Views: 3835

More details for ZSQLMonitor

As discussed here -> http://zeos.firmos.at/viewtopic.php?t=735

Here is the patch! I've applied here with no problems, and it's working fine. No filtering is component is ready, but is really easy to do now. Test it, but should be fine :)

[']s
by gto
05.10.2006, 13:36
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Migrate to 6.5.1
Replies: 6
Views: 1258

heretique, as far I know, no problemo.
Here, I'm using the latest Zeos SVN release in production, and without any worries.
New bugs may come in, it's natural :)
But certainly much of old bugs are fixed now.
You may try it in a test environment, and them move it to production ;)
by gto
28.09.2006, 14:07
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Zeos Lib Stable version
Replies: 7
Views: 2038

Mark, he should be using the CVS-13-10, which has this problem.
by gto
27.09.2006, 14:01
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Clear dataset
Replies: 9
Views: 2025

This is a tricky problem, and in most times can be fixed with a better system design, like using limits (MySQL) and first (Firebird). About limiting resultset to certain records on oracle, take a look here: http://blog.dataloss.nl/perma/oracle-limit http://edocs.bea.com/workshop/docs81/doc/en/core/i...
by gto
26.09.2006, 12:17
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Accessing large tables
Replies: 4
Views: 802

sandeep_c24 wrote:Thanks, I'll try that.

Can Unidirectional mode be added to Zeos?

Regards

Sandeep
Not quick 'n dirty :D

Some changes must be made, like a property to set the Unidirectional condition and all the paths to avoid if it's set (like no caching). In other words: It's possible, but must be made ;)
by gto
25.09.2006, 14:36
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Accessing large tables
Replies: 4
Views: 802

Ugly 'n Dirty fix: Use a TZQuery (or TZReadOnlyQuery), set the filtered property to true (don't add any filter, left it empty) and them use the query.

This makes the query to just fetch what is needed, so you will be "fetching at demand" ;)
by gto
22.09.2006, 13:34
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Zeos Lib Stable version
Replies: 7
Views: 2038

Here we go: http://zeos.firmos.at/viewtopic.php?t=761
This is officially the "beta" release, but it's hard tested on production environment, so you can use it as stable with no problemo ;)
by gto
18.09.2006, 22:03
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZSQLMonitor always logs application-wide
Replies: 9
Views: 3152

Well, just a post to say: I'm not dead yet! :) Many problems this and past week, but back to bussines now. The work to get more details reaching SQLMonitor is almost done. The TZLoggingEvent now have the following properties: Category: TZLoggingCategory Protocol: string Message: string ErrorCode: In...
by gto
06.09.2006, 14:47
Forum: 6.1.5
Topic: ZComponent.bpl and designide.bpl
Replies: 10
Views: 5771

wietsehagoort, have you checked all that ON/OFF value settings? I've seen that they're mostly ON into original file, but in your split they change a bit.
That switches aren't very clear to me, can't suggest what should be what :|
by gto
04.09.2006, 17:12
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZSQLMonitor always logs application-wide
Replies: 9
Views: 3152

Hello people! First of all, some info: If I can say what structure Zeos is build on, I'll show this: component ------------------ dbc ------------------ parsesql - plain ------------------ core The Core package have procudures, types and definitions that are common to all others. Common functions, b...