Linking Problem

Chris Kelleher

Chris Kelleher

Administrator
Staff member
Hello Everyone,

I am new to Symix and am having trouble combining information from two
fields for a report. I want to create a report to find the cust-num and
credit-limit from the customer field and to find the name from the custaddr
field.
I keep getting an error that says the custaddr is in two tables, main and
symlic. I do not know how to link these together, can anyone help me?

Progress 8.3B

TIA,

Sherry Riffle
Allen Industries, Inc.
 
Sherry,
Your problem is that the tables customer and custaddr exist in both the main
and symlic db, and you are connected to both. To solve your problem, change
your program to reference the main db similar to the following.

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
for each main.customer no-lock,
first main.custaddr no-lock where custaddr.cust-num =
customer.cust-num:
display custaddr.name /*whatever else you want*/ .
[/code]

HTH
Marty Sosso
 
Try defining the database name on the first reference of the file. If you
only need customer number, name and credit limit, all you need is the
custaddr file - but try this.

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
for each symix.customer no-lock where
customer.cust-seq = 0:
find symix.custaddr of customer no-lock no-error.
display customer.cust-num
custaddr.name
custaddr.credit-limit
customer.terms-code.
end.
[/code]
 
The proper database alias for custaddr is SYMCUST.
Using symix as the alias on custaddr can cause
problems, especially in multi-site situations with
global customer masters.

Patrick T. Gordon
Senior Software Engineer
Software Services
Symix Computer Systems, Inc.
Columbus, OH 43231
Phone: 614/523-7000
Fax: 614/895-1195
 
You must log in or register to reply here.
Back
Top