Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!tut.cis.ohio-state.edu!dsac.dla.mil!nfs0294
From: nfs0294@dsac.dla.mil (Glendell R. Midkiff)
Newsgroups: comp.databases
Subject: Re: Another SET RELATION QUESTION
Message-ID: <1637@dsac.dla.mil>
Date: 11 Jan 90 11:55:01 GMT
References: <1990Jan10.040858.12072@xenitec.on.ca^
Organization: Defense Logistics Agency Systems Automation Center, Columbus
Lines: 33

From article <1990Jan10.040858.12072@xenitec.on.ca^, by timk@xenitec.on.ca (Tim Kuehn):
^ <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.)

I never had any success setting multiple relations unless I placed each on a
separate line and used the ';'.

-- 
 |-----------------------------------------------------------------------|
 |Glen Midkiff   osu-cis!dsacg1!gmidkiff                                 |
 |From the Internet: gmidkiff@dsac.dla.mil                               |
 |Phone: (614)-238-9643 @DLA, Systems Automation Center, Columbus, Oh.   |