General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only