Search found 2733 matches

by mdaems
05.03.2006, 22:23
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Can not update this query type
Replies: 3
Views: 844

Hi Zippo.
I remember somebody was asking some days ago a similar question. Is it possible that this table has no primary key? That seemed to be the problem in his case. (I did not see a confirmation in his thread that it actually solved the problem)

Mark
by mdaems
04.03.2006, 14:52
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How to avoid "cannot update this query type" ?
Replies: 14
Views: 3269

Stefan,

Was that one not been removed??? Still using an old version as I only have D5, but I read some changes have been done concerning read-only and requestlive.

Mark
by mdaems
04.03.2006, 14:48
Forum: 6.1.5
Topic: TZUpdateSQL
Replies: 7
Views: 3861

To Nelson : There's also a downside: other queries on the same (or another) connections won't see the changes as well!! So always think about this. Bye, Mark To a_nouri_s: You can use zeoslib with mysql 5. As far as i know it's not explicitly included, but apparently the mysql api didn't change that...
by mdaems
04.03.2006, 14:23
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How to avoid "cannot update this query type" ?
Replies: 14
Views: 3269

Hi Ansgar,

I think you've found the reason. why don't you try adding an autonumber pk-column? Don't forget to include it in your query. * will do of course. Doesn't cost that much, isn't it?

Checked the knowledge base? I know there are some busy creating docs but I don't know how far they are.

Mark
by mdaems
03.03.2006, 14:25
Forum: 6.1.5
Topic: TZUpdateSQL
Replies: 7
Views: 3861

Hi Nelson, Yes, you have a live connection at all times, but with cached-updates the data is only posted to the server on commit or when requested. In the meantime the updated values are only visible to your application. If you would abort the operation before post the server wouldn't even notice yo...
by mdaems
03.03.2006, 14:10
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How to avoid "cannot update this query type" ?
Replies: 14
Views: 3269

Hi Ansgar,

Did you try without the limit clause? Probably it is treated as aggregate?

Mark
by mdaems
26.02.2006, 11:22
Forum: Feature Requests
Topic: MySQL v5
Replies: 18
Views: 6840

Did anybody ask Mysql AB themselves? Maybe they'll even put a link on their site pointing towards Zeoslib. As far as I know Mysql is not that bad and still supporting the Open Source community.
Can somebody take care of that in the DEV team?

Mark
by mdaems
26.02.2006, 11:08
Forum: MySQL
Topic: bulk import
Replies: 2
Views: 1372

Hi David,

The fastest way is to use the mysqlimport tool from the mysql distribution. All information can be found in the mysql documentation. There's 1 prerequisite, the input data has to be formatted in a reasonable fashion. (there are some options but not all is possible)

Good luck,
Mark
by mdaems
10.01.2006, 16:00
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4455

Hi, That's because the first statement is just preparing the database server to return the results and the second statement is retrieving these results one by one over the network connection. For each record caches will be filled and the current record of the dataset changes. It still processes 100 ...
by mdaems
03.01.2006, 11:01
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: executable file size
Replies: 8
Views: 1737

Hi Killerjohn,

Did you already hear about the tool upx? It reduces exe-sizes usually a lot. (50% and more)

Mark
by mdaems
25.12.2005, 11:43
Forum: 6.1.5
Topic: table update event
Replies: 3
Views: 1220

Hi black cat,

I bet there's some more news about this functionality in the knowledgebase on this site.

Hapy Christmas and a Happy new year,
Mark
by mdaems
25.12.2005, 11:40
Forum: 6.1.5
Topic: Memory leak? or am I doing something wrong?
Replies: 18
Views: 7178

Hi, Pengwin

It doesn't even compile with D5, so...

Greets,
Mark
by mdaems
22.12.2005, 14:37
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error compiling v 6.5.1 in Delphi 5 Enterprise
Replies: 9
Views: 2226

I think somebody with CVS-access, D5 and D6 should track back the incompatible changes and check if these changes can be implemented without the problematic units or with version-specific code. I hope the dev team can find somebody who is willing to do this 'job from hell'. And indeed, if they don't...
by mdaems
02.12.2005, 13:15
Forum: 6.1.5
Topic: using Filter on ZTTable
Replies: 9
Views: 4803

Maybe you should replace all '%' to the right filter wildcard during the copy towards ZTCustomers.Filter?

What's your problem with TZQuery? I was thinking TZTable was derived from tzquery, so I would think it doesn't matter as, strictly spoken,you ARE using a TZQuery.

Mark
by mdaems
28.11.2005, 13:14
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error compiling v 6.5.1 in Delphi 5 Enterprise
Replies: 9
Views: 2226

Unfortunately Delphi 5 compatibility has been lost since the 2004 release of 6.5.1-alpha. You can use this 2004 release from sourceforge until the developers have fixed this unconvenience. (I do so and had not to much trouble in my simple appications) See other items in this forum.

Mark