Search found 4 matches

by Gobol
30.10.2009, 18:12
Forum: Off Topic
Topic: [unit] TMultiInsert - for speeding up multiple transfers
Replies: 1
Views: 25405

[unit] TMultiInsert - for speeding up multiple transfers

Hi, I'd like to share my code, a class TMultiInsert, which descendens from TClientDataSet for simplicity. I think that example would be the best description. Let's assume, we're having a table in our database, correctly connected via ZConnection. This table we'd like to fill up with some values... s...
by Gobol
03.04.2006, 23:10
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Specifying key fields in WHERE clause of UPDATE query ?
Replies: 3
Views: 871

Ok, sorry - my fault. I hadn't set a primary key for the table - so the Zeos & MySQL was confused about that what I wanted to do :)

Anyway thanks for answering.
Greets,
Bogusz
by Gobol
03.04.2006, 22:56
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Specifying key fields in WHERE clause of UPDATE query ?
Replies: 3
Views: 871

Yes, I tried setting that property (WhereMode) ... each case -> the result was the same - no changes in query sent to the MySQL 5 server by Zeos. I've also tried setting KeyFields in each of TField object associated to TZTable, I had set the ProviderFlags to [inUpdate] only in all fields except one,...
by Gobol
03.04.2006, 19:14
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Specifying key fields in WHERE clause of UPDATE query ?
Replies: 3
Views: 871

Specifying key fields in WHERE clause of UPDATE query ?

Hello all! At the beginning - this is my first post on this forum, great job providing the alternative way to ODBC/BDE ! :) I would like to ask how to specify which field would be a key field in WHERE clause of UPDATE query which is send automagically on <obj> . Post; proc ? I'm trying to use Delphi...