pcsoft.us.windevCopyright 2026, PC SOFT22 Jun 2018 10:11:00 Z21 Jun 2018 00:00:00 ZWe have a data file (MyDataFile) with several fields, some of them: SCode (Text, String 20) NLineNo (Numeric, Integer +-999 999 999 --> 4-byte) DStartDate (Date, yyymmdd) It also has a composite key: IND_Code_LineNo_StartDate (with all 3 fields of above) Looking at the data in HFSQL Control Center this index seems to be filled correctly. I even reindexed the table to be sure. Now I'm trying to access data with this index: nLineNo is int = 30000 HFilter(MyDataFile,IND_Code_LineNo_StartDate,["S12345",nLineNo,hMinVal], "S12345",nLineNo,hMaxVal]) I'm not getting any result. This workaround does work and gets me the desired result: HFilter(MyDataFile,IND_Code_LineNo_StartDate,["S12345",hMinVal], "S12345",hMaxVal], "NLineNo="+nLineNo) I'm now using the workaround, but what is wrong with the first variant? I even tried using minVal is buffer = HBuildKeyValue(MyDataFile,IND_Code_LineNo_StartDate,"S12345",nLineNo,hMinVal) maxVal is buffer = HBuildKeyValue(MyDataFile,IND_Code_LineNo_StartDate,"S12345",nLineNo,hMaxVal) HFilter(MyDataFile,IND_Code_LineNo_StartDate, minVal, maxVal) In the debugwindow I get the following as values: minVal: "S12345<0><0><0><0><0><0><0><0><0><0><0><0><0><0>0u<0><0><0>" maxVal: "S12345<0><0><0><0><0><0><0><0><0><0><0><0><0><0>0u<0><0>ÿ" On first glance, I would say this is definitely wrong. there should be 30000 instead of 0u. But why? So has anyone any ideas, what I'm missing? Thanks a lot for your answer.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65946/read.awp22 Jun 2018 10:11:00 ZThe hBuildKey seems to be padding the Code item with binary zero's to a length of 20 is that ok? edit: I mean is that still the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65946/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65946/read.awp[WD21] Weird integer in composite key problemguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65945/read.awp22 Jun 2018 00:00:00 ZThanks for your answers. The missing bracket is a typo. I changed the string as I was not sure about what I may share from my d…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65945/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65945/read.awp[WD21] Weird integer in composite key problemguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65939/read.awp21 Jun 2018 12:58:00 ZHi Christine, that may be as simple as your variable declaration... You are telling us that in your analysis it's an int o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65939/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65939/read.awp[WD21] Weird integer in composite key problemguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65938/read.awp21 Jun 2018 12:53:00 ZHi Christine, I don't use hFilter because queries are more convenient, but on first glance I see an opening bracket [ missing…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65938/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65932-wd21-weird-integer-composite-key-problem-65938/read.awp[WD21] Weird integer in composite key problem