pcsoft.us.windevCopyright 2026, PC SOFT11 Aug 2016 16:00:00 Z11 Aug 2016 01:07:00 ZHello, Look at my scenario and what Im trying to do: I have 2 windows that use a data file ("cfop_table" at my case); I use HReadSeekFirst(cfop_table,id,522) at window 1; Then I use HReadSeekFirst(cfop_table,id,514) at window 2; When I call cfop_table.id at window 1 the Id is that 514 and not 522. I trying to solve it using variable type Record: _CFOP is Record of cfop_table at declaration of my window 1 and after the HReadSeekFirst(cfop_table,id,522) I assing to variable _CFOP = cfop_table the data file. But, when I try to modify (using HWrite(cfop_table)): First I assign the Record variable to data file then I run the HWrite. I used Trace to check the Id's before and after and its ok, but when I profile the SQL run the Update using the Id of Window 2 (UPDATE `cfop_table` SET `descricao` = 'testtt' WHERE `id`=514 -- Im using Neor Profile SQL). I already tryied use HReset(cfop_table) before the assign of record variable to data file but the result is the same. Below is the code and Trace's: Trace("Trace1@Window 1# "+cfop_table.id,_CFOP.id) HReset(cfop_table) Trace("Trace2@Window 1# "+cfop_table.id,_CFOP.id) cfop_table = _CFOP Trace("Trace3@Window 1# "+cfop_table.id,_CFOP.id) IF HWrite(cfop_table) THEN Trace("Trace4@Window 1# "+cfop_table.id,_CFOP.id) END Trace's output: Trace1@Window 2# 522 Trace2@Window 2# 514 Trace1@Window 1# 514 522 Trace2@Window 1# 0 522 Trace3@Window 1# 522 522 Trace4@Window 1# 522 52230WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59054/read.awp11 Aug 2016 16:00:00 ZHi everybody 2 other solutions: 1. use halias in your second window 2. use hsaveposition and hrestoreposition when you ch…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59054/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59054/read.awp[WD19] How to change key value of data file?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59056/read.awp11 Aug 2016 15:54:00 ZThanks you all for the replies! I didn't know the option 'Independent HyperFile Context', I tested and works perfect! Than…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59056/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59056/read.awp[WD19] How to change key value of data file?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59055/read.awp11 Aug 2016 15:32:00 ZHi all, Or another solution close to Mark's solution: use a separate business layer tier to work with the data like I do in t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59055/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59055/read.awp[WD19] How to change key value of data file?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59052/read.awp11 Aug 2016 14:29:00 ZHi Hugo I agree with Peter, but if you want to use 1 window then you can't do that. Option is to use an internal window for …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59052/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59052/read.awp[WD19] How to change key value of data file?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59051/read.awp11 Aug 2016 09:53:00 ZHi Hugo, In your Window description, make sure the 'Independent HyperFile Context' is flagged. If this is not the case, recor…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59051/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59046-wd19-how-change-key-value-data-file-59051/read.awp[WD19] How to change key value of data file?