
20. dBase III data setting
Example:
customer.dbf has following data
NAME ADDRESS
PHONE
Tom
Address of Tom
11111111
Mary
Address of Mary
22222222
John
Address of John
33333333
Joe
Address of Joe
44444444
Bob
Address of Bob
55555555
Gilbert
Address of Gilbert
66666666
Example
Description
Result
^Q60,0,0
^P1
^L
FILEDB,OPEN,customer
V00,10,Prompt0
V#LINKDB,PHONE,V00
FILEDB,FIND,NAME,Mary
AC,79,120,1,1,0,0, Mary’s phone: ^V00
E
Print out Mary’s phone number
Mary’s phone: 22222222
^Q60,0,0
^P1
^L
FILEDB,OPEN,customer
V00,10,Prompt0
V#LINKDB,ADDRESS,V00
FILEDB,FIND,NAME,John
AC,79,120,1,1,0,0, ^V00
E
Print out John Address
Address of John
^Q60,0,0
^P1
^L
FILEDB,OPEN,customer
V00,10,Prompt
V#LINKDB,NAME,V00
FILEDB,MOVE,LAST
AC,79,120,1,1,0,0,Last Name is ^V00
E
Print out last person name
Last Name is Gilbert
^Q60,0,0
^P1
^L
FILEDB,OPEN,customer
V00,10,Prompt
V#LINKDB,NAME,V00
FILEDB,MOVE,2
AC,79,120,1,1,0,0,Second Name is ^V00
E
4.Print second person name
Second Name is Mary
40