pcsoft.us.windevCopyright 2026, PC SOFT5 Feb 2018 23:31:00 Z5 Feb 2018 18:31:00 ZWhile updating a field in a file from some other data (HF files imported from XLS) I came upon the following problem using the following code: arrFiles is array of strings = ["Beans$","Choc$","Frozen$","Fruit$","Grains$","Juice$","Misc$","Nuts$","Olives$","Pasta$","PB$","Snacks$","Spices$"] sFile, sItem, sTmp, sSC_Code is string i, nMax is int nMax = ArrayCount(arrFiles) FOR i = 1 TO nMax sFile = Upper(arrFiles) HReadFirst(sFile) WHILE NOT HOut(sFile) sSC_Code = "" sItem = {sFile +".Item"} IF sFile = "SPICES$" THEN sSC_Code = NoSpace({sFile +".ScaleCode"}) ELSE sTmp = NoSpace({sFile +".SC_CODE"}) IF Left(sTmp,1) = "S" THEN sSC_Code = sTmp // SCCODE END END HReadSeekFirst(TNF_Item,ITMDESC,sItem) // THIS FAILS IF HFound(TNF_Item) THEN // AND OF COURSE SO DOES THIS TNF_Item.SCODE = sSC_Code HModify(TNF_Item) ELSE Info(sItem +" not found!") END HReadNext(sFile) END END The ITMDESC in TNF_Item is defined as string[50] unique key. The results shown in Step1.png and Step2.png don't seem to make any sense. Step1 shows status just before HReadSeekFirst and Step2 shows just after. [attachment 2580 Step1.png] [attachment 2581 Step2.png]30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-solved-finally-64415/read.awp5 Feb 2018 23:31:00 ZI finally figured it out AND I think I had this problem once before and someone (probably Fabrice) pointed out the solution. Whe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-solved-finally-64415/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-solved-finally-64415/read.awpcorrupt data file?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-solved-sort-64413/read.awp5 Feb 2018 21:01:00 ZIt was unfortunate that the first item in the file was # 817 Basmati Rice since the reason that it couldn't be found was due to …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-solved-sort-64413/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-solved-sort-64413/read.awpcorrupt data file?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-64412/read.awp5 Feb 2018 19:31:00 ZHi I guess you have only double-quote string issue ie parsing problem. Pls see below sDQ is string = """" sSql is stri…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-64412/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64410-corrupt-data-file-64412/read.awpcorrupt data file?