Search found 7 matches

by Uvigii
11.06.2009, 09:02
Forum: 6.6 - stable
Topic: How to preview generated SQL ?
Replies: 7
Views: 940

Hi, .... Just in case you're using mysql : have a look at mysqlproxy. That's designed to do the job you're talking about. Mark Thank You for guidance ! I do not think that mysqlproxy will fit my needs. To do what I need mysqlproxy should be running on each client machine, or on dedicated host on ea...
by Uvigii
22.05.2009, 09:44
Forum: 6.6 - stable
Topic: How to preview generated SQL ?
Replies: 7
Views: 940

Prepare statement will be implemented in version 7, so what you ask is partially implemented on the lastest snapshot. Download it and try if it fits your requestes Thank You seawolf for Your reply! I did install REV619. ZQuery.Prepare procedure seems to do nothing. Can You please point me to a simp...
by Uvigii
21.05.2009, 13:47
Forum: 6.6 - stable
Topic: How to preview generated SQL ?
Replies: 7
Views: 940

Yes I Do. But SQLMonitor log queries if I understand it correctly. I need a way to preview query , and depending on the parsed sql to cancel or execute it. Thank You. //off-topic Let describe it a little more: I have extremely tiny network bandwidth between client and server. My idea is to : 1. prep...
by Uvigii
21.05.2009, 11:07
Forum: 6.6 - stable
Topic: How to preview generated SQL ?
Replies: 7
Views: 940

How to preview generated SQL ?

If I have the following insert statement: ZQuery.SQL.Text:='Insert into table1 Values(null,:field1)'; ZQuery.ParamByName('field1').Value := 'abcd'; I need to see 'parsed' SQL before Zquery.Open (or ZQuery.ExecSQL), and depending on what I see to suspend or allow execution. Any suggestions ? Thank You.
by Uvigii
11.05.2009, 18:24
Forum: ZeosLib 7.0 Beta Forum
Topic: Problem updating BLOB's in Mysql
Replies: 11
Views: 1815

Uvigii , Did the example from fhaut help you? Did you find what you did wrong or what exactly zeoslib was doing wrong? Mark It seems thah blobs over 64 kb are cut down to 64 kb of data. Generated sql is correct (watched trough sql monitor and in mysql server log), but with only 64kb of data. Fhaut ...
by Uvigii
10.05.2009, 10:55
Forum: ZeosLib 7.0 Beta Forum
Topic: Problem updating BLOB's in Mysql
Replies: 11
Views: 1815

mdaems wrote:It should be... On other compilers this would be a bug.
On Delphi 7 with zeoslib 6.6.4-stable data corruption definitely occurs using the code from first post. Maybe i miss something ?!
by Uvigii
08.05.2009, 16:45
Forum: ZeosLib 7.0 Beta Forum
Topic: Problem updating BLOB's in Mysql
Replies: 11
Views: 1815

mdaems wrote:... This implies there are conversions in Delphi 2009.
...
Is it only specific to Delphi 2009 ?
Thank You.