|
| Double select for hmodify is the way? |
| Iniciado por guest, 04,jun. 2016 01:06 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 04,junio 2016 - 01:06 |
Hi. I have a very naive question...
I'm using NA for MySql and it works fine. By the way I just noticed that a
HReadSeekFirst(users, id, sId) for getting a record
followed by the HModify(users)
runs on MySql 2 select query and 1 update.
The select query are almost identical, one would be enough. I think the first is to read the record and "record positioning" while the second is for comparing the current record with my modifications. In fact the update query works only on actually changed fields.
Is there a way to get the same result with only one select? On bulk update now I spend twice the number of select queries I would have with query by hand.
Maybe it's waht I need to pay in order to use an automated function like hmodify?
Thank you. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,junio 2016 - 09:54 |
Hi
Yes that would be the price iguess. You cannot change how it works
regards
Allard |
| |
| |
| | | |
|
| | |
| |
| Publicado el 06,junio 2016 - 10:47 |
Hi Stefano,
Not sure, but disabling the automatic modification conflict handling can make this go away.
hOnError("*",hErrModify,"") //Will turn modification conflict handling off
I hope this helps,
Peter Holemans |
| |
| |
| | | |
|
| | | | |
| | |
|