pcsoft.us.windevCopyright 2026, PC SOFT5 Jul 2017 17:37:00 Z5 Jul 2017 14:09:00 ZHi all, hModify() updates a record in a file with new fieldvalues. Is there somesort of way to update one field instead of all the fields in a record ? Best regards, Aad30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61585/read.awp5 Jul 2017 17:37:00 Zp44 For information, there are some words that are best avoided as field names in databases as they are reserved for other us…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61585/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61585/read.awphModify()guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61584/read.awp5 Jul 2017 17:20:00 ZHello Aad this is the kind of code I use in a save button (by example): - read and block record to modify - set the value…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61584/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61584/read.awphModify()guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61583/read.awp5 Jul 2017 17:12:00 Zthats just the thing if i do time.name=a data file. or control screen to fille hmodify() and the rest of the code above …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61583/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61583/read.awphModify()guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61582/read.awp5 Jul 2017 17:02:00 ZTo modify only one field of the file use UPDATE in sql Create one update query or write the update by hand and run it using h…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61582/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61582/read.awphModify()guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61581/read.awp5 Jul 2017 16:58:00 ZHi Aad, yes, the YearMonthDay1 item is a unique one. A second record for this day will trigger a duplicate!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61581/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61581/read.awphModify()guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61580/read.awp5 Jul 2017 15:47:00 ZThanks guys, The reason why I asked is, that hModify() has a potential danger. In a file with many fields it easily happens, …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61580/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61580/read.awphModify()guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61579/read.awp5 Jul 2017 15:33:00 Zi was just about to post the same question.Only diffrence i am going true the wd turtorial and my understanding of databases in …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61579/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61579/read.awphModify()guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61578/read.awp5 Jul 2017 14:39:00 ZHi Aad, to modify a record you have to read that record first after a seek or direct with hreadseek for example. Then the who…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61578/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61578/read.awphModify()guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61577/read.awp5 Jul 2017 14:38:00 ZHi, this is standard! If you read a record with HReadSeek... then the buffer of the file is filled with values of the record. Yo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61577/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61575-hmodify-61577/read.awphModify()