Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views and SEEK
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00029325
Message ID:
00029333
Views:
25
>>I have a grid in a form.
>>The grid displays a view.
>>I want to seek for employee name in the
>>view.
>>I have tried locate but it only returns the first
>>occurens of the name.
>>
>>Before I used seek and then the names were
>>seeked one after another.
>>
>>Is it possible to INDEX a view??
>>
>>How to solve this problem:
>>My code in the find button is:
>>ANT=LEN(ALLTRIM(UPPER(THISFORM.ansatt.value)))
>>LOCATE FOR SUBSTR(viewansskift.ansnavn,1,ANT)=ALLTRIM(UPPER(THISFORM.ansatt.value))
>>recnr=RECNO()
>>IF NOT BOF()
>> IF NOT EOF()
>>GOTO recnr
>>ENDIF
>>ENDIF
>>THISFORM.Refresh()
>>THISFORM.Grid1.SetFocus()
>>
>>Best regards
>>
>>Per Simmersholm

Well, let's try this again with an actual MESSAGE written.

Per, you can index a view just like a table. There was a thread about this in the last couple of days.

Also, check out 'CONTINUE' which is used to find the second, third.... instances of whatever you were LOCATING.

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform