How exactly do I use TZUpdateSQL ?
I use a TZQuery with UpdateObject property set, cachedupdates=true, but the associated dbgrid is still readonly. Do I have to use RequestLive = True ? it works, but I just don´t want a live connection to the db.
What´s the right way to do it ?
thnx,
Nelson
TZUpdateSQL
Moderators: gto, cipto_kh, EgonHugeist
You only need TZUpdateSQL if your query is so complicated (joins) that Zeos can't generate an update sql by itself. Then you have to write your own insert/update/delete SQL in TZUpdateSQL.
And yes, you have to set RequestLive = true (in 6.5.1: ReadOnly = false), for else it is in fact readonly.
Regards,
Rüdiger
And yes, you have to set RequestLive = true (in 6.5.1: ReadOnly = false), for else it is in fact readonly.
Regards,
Rüdiger
-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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 you tried to modify the data.
Mark
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 you tried to modify the data.
Mark
very good. thanks-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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 much between 4.1 and 5.0
Please have al look at older threads about how to bypass (basicly, you can substitute the dll-file (windows) by using the 5.0 one). If you want to use very specific features of 5.0, I don't know, but I see no novelties that would make problems. I work on 5.1 in this way (using the 5.0 dll).
I don't remember whether somebody already committed himself to provide 5.0 support. Maybe you can try to open a separate thread to clear out what's planned to be implemented in the promised version 6 (was it 6?).
BTW : Can you please stop putting this same question in every thread. I only answered this one to stop your rather annoying behaviour. Most of us DO read new posts and answers.
Enjoy Zeoslib. I hope I did not offend you to much with the last comment.
Bye,
Mark
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 much between 4.1 and 5.0
Please have al look at older threads about how to bypass (basicly, you can substitute the dll-file (windows) by using the 5.0 one). If you want to use very specific features of 5.0, I don't know, but I see no novelties that would make problems. I work on 5.1 in this way (using the 5.0 dll).
I don't remember whether somebody already committed himself to provide 5.0 support. Maybe you can try to open a separate thread to clear out what's planned to be implemented in the promised version 6 (was it 6?).
BTW : Can you please stop putting this same question in every thread. I only answered this one to stop your rather annoying behaviour. Most of us DO read new posts and answers.
Enjoy Zeoslib. I hope I did not offend you to much with the last comment.
Bye,
Mark