I set up a DEFINE for a master fileworks fine. Should I b...

[robert fuschetto]

I set up a DEFINE for a master fileworks fine. Should I be able to use it in a JOIN I get a FOC236 error.

[VisuaLizeFOCUS .]

I did create one DEFINE field in Car master file below is the code:

 

image.png943611 25 KB

[robert fuschetto]

I guess I should open a case!

[Todd Wallace]

(FOC236)

LINKED FILE DOES NOT HAVE MATCHING KEY FIELD OR SEGMENT :

The referencing, and cross-referenced file do not have the field named as the CRKEY in

common. Check the names of the fields.

.

.

I have seen this when the define matches a field name that is already in the master.

[Debra Waybright]

We have never been able to use a defined field as a join field. I think that changes with 8207, but when we tried that the other day in our 8207 test environment, it still wasnt working, although it didnt give an error.

[robert fuschetto]

Todd,

Yes my define happens to match and existing field.

[Toby Mills]

Id say its certainly worth renaming your DEFINEd field to something oddly unique just to see if its a segment activation problem youre encountering.

[robert fuschetto]

Sorry, I should clarify, teh DEFINEd fields name is unique. Its alue is set to another column. Id I have not mentioned itwe did this to allow for similarly named fields that act as parameters for use on HTML forms.

Exampe: Some of our data sources have a DEPARTMENT field. Some have a DEPT field. If we add fexes for each to an HTML page we dont want IBI creating a control for each. By adding DEPT to the master files with DEPARTMENT and filtering on DEPT, parameter names are all the same across all master files and only one control is created on the HTML page.

[Alexander Homer]

Hi Robert,

As I understand it, youre trying to pass the same value to two different parameters in an HTML page, like this

 

image.png740632 18.9 KB

 

If so, you can just choose not to auto-generate the control for the second report, and then you should be able to bind the control to both parameters in the Parameters view tab and set the control to reload both reports, as shown here:

 

Let me know if theres something Im missing. I havent had issues joining with DEFINE fields per se (as sometimes DEFINEs with character functions are needed to reformat data to match values to another field), but there may be certain cases that dont work

[robert fuschetto]

Thanks All, I had worked around this but I know it will be issue again. I will circle around again when it pops up again