Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Landing on a particular record in a view
Message
 
To
29/07/1999 12:28:26
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00247717
Message ID:
00247775
Views:
18
Actually I am getting 4 records that match my criteria. What I need to do is have the ability to run another query locating a specific record in the 4 record set. I also want my navigational bar to scroll through all 4 records, even though I landed on record 3. Here is the code I used to obtain my 4 records:

* b= persons name
* c= persons id number
* lc_p_inv_pid = parameter pass to query locating person by id number
*
do case
case .a = 1
.set_1p && sets control source for fields
locate for alltrim(person_tbl.p_lname) = .b
.c = person_tbl.p_inv_pid
lc_p_inv_pid = .c
requery('lv_1p')
refresh()


what do I do after this to locate a particular record in the above query result, such as record 3. I don't know how to get to record 3 in the result set above?

thanks for reply

nick patel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform