Xref: utzoo comp.databases:4553 comp.sys.ibm.pc:41460
Path: utzoo!utgpu!watserv1!watmath!att!cbnewsm!ldc
From: ldc@cbnewsm.ATT.COM (derrick.j.mitchell)
Newsgroups: comp.databases,comp.sys.ibm.pc
Subject: Another SET RELATION QUESTION
Keywords: CLIPPER
Message-ID: <8328@cbnewsm.ATT.COM>
Date: 7 Jan 90 22:30:05 GMT
Organization: AT&T Bell Laboratories
Lines: 35

First I must say thanks to the answers to my previous question.

My other problem is the followings:

USE parts
SET INDEX TO parts
SELECT 0	&& Get the next available work space
USE supplier
SET INDEX TO supplier
SELECT 0
USE custpart
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".
From what I read in the manuals the above should work.
The data file "parts" is INDEXed on part_no. Also, the data file
"supplier" is INDEXed on id. If I try splitting it into two SET RELATION
there is no error.

SET RELATION part_no INTO parts
SET RELATION id INTO suplier

However, the last SET RELATION canceled the previous
one, as expected.  If after splitting the command I add the ADDITIVE
option to the Clipper compiler flags an error and ignore the ADDITIVE

SET RELATION part_no INTO parts ADDITIVE
SET RELATION id INTO suplier ADDITIVE

It is now sunday evening...... I give up.

	Again Thanks in advance for you help.