Record help, need specific, its finding closest

[lashwarj]

Below is my code, it returns record similiar its not exact. How do i make my results exact. EX. If I put in 301.13-1-33 it will give me 301.13-1-3 and due to my not having a record select this will not be acceptable.


LOCAL cValue
STORE ALLTRIM(ThisForm.Text1.Value) to cValue
LOCATE FOR cValue = ALLTRIM(parcelid)
GOTO TOP
IF !FOUND()
GO TOP
LOCATE FOR cValue = ALLTRIM(newkey)
IF !FOUND()
MESSAGEBOX("Tax Map # Not Found","Sorry&quot
STORE "" TO ThisForm.Text1.Value
ENDIF
ENDIF
ThisForm.Text2.Value = parcelid
ThisForm.Text3.Value = newkey
THISFORM.REFRESH()

 

[weedz]

Try the '==' (EXACTLY LIKE)

LOCATE FOR ALLTRIM(cValue) == ALLTRIM(parcelid)

HTH,

Weedz (Edward W.F. Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

Download the CrownBase source code !!

 

[lashwarj]

The alltrim didnt help, how do I do the exaclty like

 

[Mike Gagnon]

lashwarj

You may want to add (In the init of your form)
SET EXACT ON
SET NEAR OFF

 

[Raccoon]

I recommend that you not use locate but use seek instead. With large numbers of records, locate takes a looooong time. It looks at each and every record, while seek jumps to the record.

 

[Mike Gagnon]

Racoon

The seek works if the field has an index.

 

[DSummZZZ]

More of my 2 cents.

lashwarj: The double equal (==) in weedz's statement is the exact match, as opposed to te single equal(=).

Racoon: LOCATE FOR is rushmore-able. It can be as fast as SEEK if there is an index usable by the rushmore technology.

Dave S.