Problem with index 1

[mkendi]

In a table I have a character field with binary information (6 char) and a index for this field.
LOCATE finds the searched record, but SEEK returns always TRUE but stays in the first record.
The field is created as <char (binary)>.

I am using VFP6 SP5.

 

[AirCon]

mkendi,

You can set the codepage to 1254 but you must SET COLLATE TO 'MACHINE'. Then re-create the index file. I think it will work

Regards

-- AirCon --

 

[mkendi]

Yes, AirCon, this was it!!
First I have to remove the tag.
Then
SET COLLATE TO 'MACHINE'
INDEX ON KartNo TO KartNo_IDX
SET COLLATE TO 'TURKISH'

Thank you very much!

 

[AirCon]

Glad it works

Regards

-- AirCon --

 

[craigsboyd]

Would someone please explain WHY ...

SET COLLATE TO 'MACHINE'
INDEX ON KartNo TO KartNo_IDX
SET COLLATE TO 'TURKISH'

... fixed the problem? Thanks.

Slighthaze = NULL

 

[AirCon]

Slighthaze,

Using Set collate to 'machine', ensure that characters in the index file are the same with characters in the table. While others COLLATE can produce different characters in the index file. Maybe this is where the problem was.

I never use others collate, so I don't know much about this also. You can read about SET COLLATE & Developing International Applications in VFP help


-- AirCon --