Search found 7 matches
- 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...
- 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...
- 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...
- 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.
- 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 ...
- 10.05.2009, 10:55
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Problem updating BLOB's in Mysql
- Replies: 11
- Views: 1815
- 08.05.2009, 16:45
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Problem updating BLOB's in Mysql
- Replies: 11
- Views: 1815