WHEN GETTING (FOC104) DEFINE IN MASTER REFERS TO A FIELD OUTSIDE ITS SCOPE

THE IBI EXPLANATION AND FORUM DESCRIPTIONS IS NOT CLEAR TO ME. THIS IS THE DEINFE I ATTEMPTING TO USE:

DEFINE TRANSMIT_WHEN_MI/MDYY = HDATE(TRANSMIT_WHEN_MI_O,'MDYY'); $

HOW WOULD I ADD THE WITH?

When you put a define in an MFD, it has to be based on fields in the MFD as I understand it.

You might want to move your define to the Table request.

ok, how would ou code that? I'm looking for a specific example.

quote:

DEFINE TRANSMIT_WHEN_MI/MDYY = HDATE(TRANSMIT_WHEN_MI_O,'MDYY');

Put the above define between any joins and the table file request.

JOIN.....
DEFINE FILE XYZ
TRANSMIT_WHEN_MI/MDYY = HDATE(TRANSMIT_WHEN_MI_O,'MDYY');
END
TABLE FILE XYZ
...

Is TRANSMIT_WHEN_MI_O a field in the Master you have the define in?

Error 104:
FOC104) DEFINE IN MASTER REFERS TO A FIELD OUTSIDE ITS SCOPE:
The defined field refers to a field which is not in the same
segment as the DEFINE (for FIELDNAME=OLD) or to a field that is
not in this Master (for FIELDNAME=NEW).

What kind of db is it?
What version are you on?
What operating system?

I suppose that you have multisegment master-file.
Is it so?

In DEFINE you are can use WITH [segment keyfield] to place virtual field into specific segment.

AFAIK this is only for WF 7.x
In 5.x - virtual fields always placed in segment which fields they are using.
(I can be wrong in 5.x issues)

quote:

DEFINE TRANSMIT_WHEN_MI/MDYY = HDATE(TRANSMIT_WHEN_MI_O,'MDYY');

DEFINE TRANSMIT_WHEN_MI/MDYY WITH somefieldname= HDATE(TRANSMIT_WHEN_MI_O,'MDYY');
is that what you wanted to know, Winston?

Yes, that is the example I am seeking.

Thx

quote:

DEFINE TRANSMIT_WHEN_MI/MDYY WITH some MASTER FILE fieldname= HDATE(TRANSMIT_WHEN_MI_O,'MDYY');

Winston, hope this helps.

Ira 5.3.6