home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
World_Of_Computer_Software-02-387-Vol-3of3.iso
/
s
/
sbt25sm4.zip
/
ZIPSMC02.EXE
/
SYVENR._XP
(
.txt
)
< prev
next >
Wrap
MS Visual FoxPro App
|
1993-02-11
|
3KB
|
52 lines
Locating Records in File...
a_apvend//
vendno
.NOT. DELETED()
.AND. ctype = lc_ctype
.AND. buyer = lc_buyer
.AND. code = lc_code
ll_cont .AND. vendno = lc_vendno
ll_cont
Indexing on Company Name...
INDEX ON company + vendno TO (gc_idrvtmp + gc_tmpf1 + gc_extndx) FOR &lc_filt. .AND. &lc_cond. COMPACT
Indexing on Purchase Volume...
INDEX ON LEFT(STR(100000000000000 - ytdpur, 18, 2), 18) + vendno TO (gc_idrvtmp + gc_tmpf1 + gc_extndx) FOR &lc_filt. .AND. &lc_cond. COMPACT
vendno
SET FILTER TO &lc_filt. .AND. &lc_cond.
Detail Vendor File Report
Summary Vendor File Report
- Ordered By Vendor Number
- Ordered By Company Name
- Ordered By Purchase Volume
Vendor Number =
Type =
Buyer =
Code =
Matching: F
syvend
syvens
GN_TRACE
tE_TRACE
reLC_FILT
orLC_COND
LC_TITLE
LC_HEAD1
LC_HEAD2
LC_VENDNO
LC_BUYER
LC_CTYPE
LC_CODE
G_DSPST
EDGN_MSGLINELN_OPNVENDG_OPNFL
GF_APVENDFLL_CONT
LC_ORDER
GC_IDRVTMPGC_TMPF1
GC_EXTNDX
VENDNO
A_APVEND
LC_DETAIL
LC_FRMFILEGC_IDRVPRGG_PRNRP
C:\SMDISK\
C:\SMDISK\SYVENR.PRG
SYVENR.FXP