pcsoft.us.windevCopyright 2026, PC SOFT2 Apr 2015 11:37:00 Z31 Mar 2015 14:36:00 ZHello, I want to use a seek on a composite key. But I want to use only the first element of 2 elements. It is also possible that I seek like this [elem1,elem2] on a key with 3 elements. When a execute a line like this HreadseekFirst(aDataFile,MyTrippleCompositeKey,[elem1,elem2]) There is no error but HFound() gives a false. The thirth element guarantees me that I found the wanted record. What is the best way to seek with 2 elements in a 3 elements composite key. Thanks. Willy Hermans30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51319/read.awp2 Apr 2015 11:37:00 Z... or use a query ... IMHO the way to go in the 21st century... Just my 2 cents, Peter H.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51319/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51319/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51292/read.awp1 Apr 2015 08:53:00 ZDid u try use HBuildKeyValue(). I am using it when have situation like yours and it works for me.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51292/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51292/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51290/read.awp1 Apr 2015 02:01:00 ZHi You could use this syntax as well FOR ALL xxx WHERE compisitekey = [1,2] End regards Allardhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51290/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51290/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51282/read.awp31 Mar 2015 16:03:00 ZOK, again many thanks. Conclusion : 1) In coding a function like HReadSeekFirstSoft(DataFile,Key,Parameter) should be v…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51282/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51282/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51281/read.awp31 Mar 2015 15:42:00 ZHi Willy, If you want to make a suggestion, send it to the Free Technical Support. I agree with your point. But you can al…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51281/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51281/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51280/read.awp31 Mar 2015 15:28:00 ZHi, Many thanks for the answers. Now a suggestion to the WinDev developers. I hope they are also reading this forum. My…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51280/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51280/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51279/read.awp31 Mar 2015 15:10:00 ZHi Willy, You do it correctly. There are no errors. Do not forget that you seek on a key with 3 elements and you only have…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51279/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51279/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51278/read.awp31 Mar 2015 14:55:00 ZHi, why you don't add another composite key for the 2 searched elements? If Hreadseekfirst returns true, then you can check if…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51278/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51278/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51277/read.awp31 Mar 2015 14:54:00 ZHi Willy I don't know about the best way, but this is what I would do: hfilter(aDataFile,MyTrippleCompositeKey,[elem1,elem2,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51277/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51274-what-best-way-seek-with-2-elements-51277/read.awpWhat is the best way to seek with 2 elements in a 3 elements composite key.