home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
utils
/
miscutil.zip
/
DBRELATE.ZIP
/
BREAKTST.PRG
< prev
next >
Wrap
Text File
|
1987-07-22
|
1KB
|
59 lines
* BREAKTST.PRG THIS PROGRAM TESTS CONCEPTUALLY NON-LINEAR
* RELATION CHAINS IN DBASE AND CLIPPER, GIVING PARTICULAR
* ATTENTION TO WHAT HAPPENS WHEN THE RELATION CHAIN IS "BROKEN".
* GREGORY J. SCOTT, 409-838-2195 July 22, 1987
PUBLIC CLIPPER
SELE A
USE BREAK1
INDEX ON B1 TO BREAK1 && FIELD B1, VALUES A, B, C
SELE B
USE BREAK2
INDEX ON B1 TO BREAK2 && FIELD B1, VALUES 0, C, Z
SELE C
USE BREAK3
INDEX ON B1 TO BREAK3 && FIELD B1, VALUES A, B, C
SELE A
SET ALTERNATE TO BREAKTST.TXT
SET ALTERNATE ON
IF CLIPPER && TEST CLIPPER MULTI-CHILD RELATION
SET RELATION TO B1 INTO B,;
TO B1 INTO C
? "CLIPPER MULTI-CHILD RELATION"
DO WHILE .NOT. EOF()
? A->B1, B->B1, C->B1
SKIP 1
ENDDO
ENDIF
GOTO TOP && TEST EXTENDED LINEAR RELATION DB3+ & CLIPPER
SET RELATION TO B1 INTO B
SELE B
SET RELATION TO A->B1 INTO C
SELE A
? "EXTENDED LINEAR RELATION CHAIN"
DO WHILE .NOT. EOF()
? A->B1, B->B1, C->B1
SKIP 1
ENDDO
SET ALTERNATE TO
IF .NOT. CLIPPER
SELE A
LIST STRU TO PRINTER
LIST TO PRINTER
SELE B
LIST STRU TO PRINTER
LIST TO PRINTER
SELE C
LIST STRU TO PRINTER
LIST TO PRINTER
ENDIF
TYPE BREAKTST.TXT TO PRINT