pcsoft.us.windevCopyright 2026, PC SOFT6 Jun 2016 10:47:00 Z4 Jun 2016 01:06:00 ZHi. 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.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57963-double-select-for-hmodify-way/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57963-double-select-for-hmodify-way-57977/read.awp6 Jun 2016 10:47:00 ZHi Stefano, Not sure, but disabling the automatic modification conflict handling can make this go away. hOnError("*",hErrMod…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57963-double-select-for-hmodify-way-57977/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57963-double-select-for-hmodify-way-57977/read.awpDouble select for hmodify is the way?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57963-double-select-for-hmodify-way-57968/read.awp4 Jun 2016 09:54:00 ZHi Yes that would be the price iguess. You cannot change how it works regards Allardhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57963-double-select-for-hmodify-way-57968/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57963-double-select-for-hmodify-way-57968/read.awpDouble select for hmodify is the way?