[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
VPICK() Database "pick-list" routine
Description:
VPICK() allows the user to pick a record from a "pick-list" window.
The "pick-list" window contains a subset of fields for each record in
the database. VPICK() is non-screen destructive.
Syntax:
VPICK( <expN1>, <expN2>, <expN3>, <expC1>, <expC2>, <expC3>, <expL> )
Pass:
<expN1> = Top row of window
<expN2> = Left column of window
<expN3> = Maximum number of lines in window
<expC1> = Macro string of field names to display on each line. i.e.
"FRST_NAME+[ ]+LAST_NAME"
<expC2> = Title for top of window
<expC3> = Footnote for bottom of window
<expL> = .T. if database is indexed, otherwise .F.
Return:
<expN> = INKEY() value of last key pressed by user
Notes:
Example:
c_FldList = "LAST_NAME+[ ]+FRST_NAME+[ ]+PHONE"
DO WHILE .T.
gn_StartRec = RECNO() && What record to start on?
n_Key = VPICK(5,5,12,c_FldList,"Title","Footnote")
DO CASE
CASE n_Key = 13 && [Return]
EDITPROG() && Edit current record
CASE n_Key = 22 && [Insert]
ADD_PROG() && Add new record
CASE n_Key = 27 && [Escape]
EXIT
ENDCASE
ENDDO
.
.
.
Usage:
See Also:
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson