Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!mailrus!ncar!noao!arizona!naucse!wew
From: wew@naucse.UUCP (Bill Wilson)
Newsgroups: comp.databases
Subject: Re: DBASE Set skip to...
Message-ID: <1844@naucse.UUCP>
Date: 13 Dec 89 15:45:37 GMT
References: <100@debet.nhh.no>
Organization: Northern Arizona University, Flagstaff, AZ
Lines: 35

From article <100@debet.nhh.no>, by si7_hn20587@debet.nhh.no (HALLVARD NATVIK NORWEGIAN SCHOOL OF ECO. AND BUSINESS ADMINISTRATION):
> Hello masters of Dbase IV
> 
> Can any of you tell me exactly how the SET SKIP TO .... command in Dbase
> IV works? I understand that it has something with 1:many relationships
> to do, but what advantages do you get when you add it to the SET
> RELATION TO command?
> 
> Unfortunately, I don't have access to the Ashton-Tate documentation, and the
> books I have looked up either fully ignore or don't give any examples of
> how the command is used.
>
I hope that you are not using an illegal copy of the product.  If you
are, it is not a good idea to ask questions on the net like this.

In answer to the question (just in case it is academic), the set skip
command is used to see all the records from an associated database
that is related to a master base.  For example (I am going from
memory):

sele 2
use classes index ssn
sele 1
use students
set rela to ssn into b
set skip on
list fields lname, fname, ssn, b->class, b-hours 

All the records in area two will print out for each ssn in area one.

-- 
Let sleeping dragons lie........               | The Bit Chaser
----------------------------------------------------------------
Bill Wilson             (Bitnet: ucc2wew@nauvm | wilson@nauvax)
Northern AZ Univ  Flagstaff, AZ 86011