pcsoft.us.windevCopyright 2026, PC SOFT22 Feb 2018 21:59:00 Z22 Feb 2018 07:50:00 ZHello, [wd22] [postgresql] I have a composite key with 6 fields, File1 Field1 varchar(10) Field2 varchar(10) Field3 int Field4 varchar(10) Field5 varchar(3) Field6 int Composite Key [Field1Field2Field3Field4Field5Field6] When I try to read with HReadSeekFirst(File1, Field1Field2Field3Field4Field5Field6, [Value1, Value2, Valu3, Value4, Value5, Value6] ) it always returns True. Even HFound also returns true Even for those values for which NO record is found. It points to first record and returns value corresponding to the first record for any value that's been seek. But the same query run through HExecuteSQLQuery returns correct value and record, but not using HReadSeekFirst. Any thing that I'm missing ? Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64682/read.awp22 Feb 2018 21:59:00 ZHello Sivaprakash Try using HBuildkeyvalue() instead of the array square brackets Regards Alhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64682/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64682/read.awp[WD22] Issue with HReadSeekFirstguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64681/read.awp22 Feb 2018 21:59:00 ZNot that I have much experience with pg, but the native driver translates h* statements into sql, so if you are able to trace th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64681/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64681/read.awp[WD22] Issue with HReadSeekFirstguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64679/read.awp22 Feb 2018 16:34:00 Zmaybe you can check if the fields in the index are case sensitive?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64679/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64679/read.awp[WD22] Issue with HReadSeekFirstguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64677/read.awp22 Feb 2018 15:04:00 ZYes Fabrice Harari, We checked with hreadkseek + hidentical also, same result. We found that this issue happens with this fil…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64677/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64677/read.awp[WD22] Issue with HReadSeekFirstguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64672/read.awp22 Feb 2018 13:01:00 ZHi can you test if you have the same result with hreadseek + hidentical option instead of the hreadseekfirst? Best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64672/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64663-wd22-issue-with-hreadseekfirst-64672/read.awp[WD22] Issue with HReadSeekFirst