>The reason I wanted to try the LOCATE was cause with the SEEK() does not work correctly. This is what I’m doing:
>
>IIF(SEEK(THISFORM.r_year+result.source,'Temp','Temp'),Temp.descr," ")
>
>It doesn’t find the right info, although, it does exist. I also tried setting EXACT ON and still doesn’t find it.
>
>any ideas?
Make sure that THISFORM.r_year is the same size as Temp.fyr and result.source is the same size as Temp.source. Use PADR() or ALLTRIM() to add or remove leading and trailing spaces. If they are not the same size, this expression will always return .F.
Ronald Suen
Epic Information Solutions Inc.
Ph: (780) 488-4418
Fax: (780) 488-0402