>I have around 1000 Records in a file. The file has a field PS, In certain records I have a text 'T M' in the middle and the last three words are 'g n'.
>
>Using the following function I am able to locate the PS having 'T M' and 'g n' at the last three digits. But the problem is my below mentioned code locates the first instance of T M and g n , while I need the record number of the last occourance of T M and g n.
>
>I.e I mean to say that I need the last record number whic has the above text.
>
>Is there any way that locate function finds from bottom to top or any other way
>
>Here is my code
>
>
>
>LOCATE FOR AT('T M',PS)>0 AND RIGHT(ALLTRIM(Ps),3)='g n'
>IF FOUND
>lrecordno=RECNO()
>ENDIF
>
>
Instead of LOCATE you may try using SELECT statement with TOP 1 AND ORDER BY clause to order the way you want.
If it's not broken, fix it until it is.
My Blog