HFilter not working in WD12

Hi All

This code worked in WD11, and I'm sure this time. It does not work in WD12 and I know their are 9 records that should be return to sSearchKetytem result set. This filter now returns no records. Did something change from WD11 to WD12 with the HFilter function?

Here is the code:

// Enable the filter
sSearckKeyItem, ThisRaceID is string
ThisRaceID = Middle(Cur.RaceID,1,13)
// Enable the filter
sSearckKeyItem = HFilter(Entries, "RaceID]='"+ThisRaceID+"'")

// Browse filtered records
HReadFirst(Entries, sSearckKeyItem)
WHILE NOT HOut()
	// Insert your process here
	Entries.InRace = True
	HModify(Entries)
	HReadNext(Entries, sSearckKeyItem)
END
// Disable the filter
HDeactivateFilter(Entries)
Cur.RaceID = Races.RaceID
Cur.RaceRowNumber = CurrentSubscript()
ReDisplayTables()

I can not get my help window to work to look it up. So I haven't been able to research the problem.

Hi John,

Windev Help [WD8] :

<Result> = HFilter(<File name> ,<Name of the browse key>, <Minimum limit>, <Maximum limit> [,<Selection condition>])

I think you have forgotten the browse key. Also check if "ThisRaceID" eaqual to the browse key. Maybe WD12 change the syntax of the filter. I only have WD8.

Christoph

Hi John,

Is the ]= a typo?
The "starts with" operator is [=

Regards,
Piet