pcsoft.us.windevCopyright 2026, PC SOFT3 Jul 2016 07:17:00 Z30 Jun 2016 21:20:00 ZHaving a heck of a time figuring this out. I have a file (requests) with a composite key consisting of a store # field (integer) and a date fulfilled field (date). The idea was to use HReadSeekFirst to find an unprocessed record by store number. But it doesn't recognize an empty date for some reason. I have a table with 2 records in it, one with a blank date and one with a current date. If I do the following: IF HReadSeekFirst(requests,storenumDateFulfilled,[7998,""])=False RETURN // Not found or error END IF HFound(requests) = False THEN RETURN // Not Found END IF requests.DateFulfilled <> "" THEN RETURN END The HReadSeekFirst and HFound passes, but the DateFulfilled is the current date, NOT the empty date as desired. Any ideas? Is this a bug?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58452/read.awp3 Jul 2016 07:17:00 ZHi, since WD 5.5 I'm building composite keys a string keys by programming, even if parts of the key are numeric, dates etc. From…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58452/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58452/read.awpHReadSeekFirst problem with composite keys and empty datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58450/read.awp2 Jul 2016 20:42:00 ZPeter. HFound() return False because hreadseekfirst() do exact search and with parameter " " record such that can not be found…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58450/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58450/read.awpHReadSeekFirst problem with composite keys and empty datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58443/read.awp1 Jul 2016 15:03:00 ZThanks, I'll try your way. But I would still like to know why what I wanted to do didn't work. I may just have to change my sear…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58443/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58443/read.awpHReadSeekFirst problem with composite keys and empty datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58442/read.awp1 Jul 2016 14:56:00 ZThanks for the reply, but I did try both ways.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58442/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58442/read.awpHReadSeekFirst problem with composite keys and empty datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58424/read.awp1 Jul 2016 08:52:00 ZMaybe you can try with this (don't use second parameter-date): HReadSeekFirst(requests,storenumDateFulfilled,[7998],hGeneric+hL…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58424/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58424/read.awpHReadSeekFirst problem with composite keys and empty datesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58416/read.awp1 Jul 2016 04:21:00 ZHello Peter I have never had much luck using the array method [] and I find that using HBuildkeyValue() is more reliable so y…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58416/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58408-hreadseekfirst-problem-with-composite-keys-and-empty-dates-58416/read.awpHReadSeekFirst problem with composite keys and empty dates