Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!maytag!xenitec!timk
From: timk@xenitec.on.ca (Tim Kuehn)
Newsgroups: comp.databases
Subject: Re: Another SET RELATION QUESTION
Summary: Read the manual!
Message-ID: <1990Jan10.040858.12072@xenitec.on.ca>
Date: 10 Jan 90 04:08:58 GMT
References: <8328@cbnewsm.ATT.COM> <1632@dsac.dla.mil>
Reply-To: timk@xenitec.UUCP (Tim Kuehn)
Organization: XeniTec Consulting Services, Kitchener, ON, Canada
Lines: 31

<1632@dsac.dla.mil> nfs0294@dsac.dla.mil (Glendell R. Midkiff) writes:
><8328@cbnewsm.ATT.COM>, by ldc@cbnewsm.ATT.COM (derrick.j.mitchell):
>> SET INDEX TO custpart
>> SET RELATION TO part_no INTO parts, id INTO supplier
>> When I compile the above using "Clipper Sum/87" I get a
>> "SET RELATION error".
> 
> I had the same problem when I first started using the SET RELATION
> Command.
>
> Try splitting the line and use a ';' at the end of the first line:
>
>	SET RELATION TO part_no INTO parts,;
>		     TO id      INTO supplier
>
> See the example on page 5-182 of the manual.

Why bother with the ';' when the addition of the word "to" will fix the 
problem? i.e. 

set relation to part_no into parts, TO id into supplier
				    ^^^
This word is VERY important to this statement!(As you've already found out.)

+-----------------------------------------------------------------------------+
|Timothy D. Kuehn	       			       timk@xenitec.on.ca     |
|TDK Consulting Services			       !watmath!xenitec!timk  |
|871 Victoria St. North, Suite 217A					      |
|Kitchener, Ontario, Canada N2B 3S4 		       (519)-741-3623 	      |
|DOS/Xenix - SW/HW. uC, uP, DBMS. 		       Quality SW Guaranteed  |
+-----------------------------------------------------------------------------+