JOIN With different data type

[Manuel8888]

Hi

I,m trying to do a join between two tables. The field involved is a string in the first one and a number in the second one. I.E. Value Field Table 1: 1 Value Field Table 2:"0001"

Anyone know how to do it?

Please explain me in detail, I,m just starting with WebFocus.

Thanks in advance.

 

[kiddpete]

You have to convert the string to an alpha with the same 'formating' as your target field. The EDIT function MAY be able to do this for you.

 

[FOCMAN]

You need to do a DEFINE based JOIN:

Something like:


JOIN MYFIELD IN TABLE1 TO ALL FIELD2 IN TABLE2 AS J1
END

DEFINE FILE TABLE1
MYFIELD/A4 WITH FIELD1 = EDIT(FIELD1);
END

TABLE FILE TABLE1
PRINT MYFIELD FIELD2
END


Look this up in a manual. Also the TO field in TABLE2 should be indexed.

 

[focwizard]

Focman had it close. What you need is a DEFINE-Based JOIN. It looks like this:

JOIN MYFIELD [red]WITH FIELD1[/red] IN TABLE1
TO ALL FIELD2 IN TABLE2 AS J1
END

DEFINE FILE TABLE1
MYFIELD/A4 WITH FIELD1 = EDIT(FIELD1);
END

TABLE FILE TABLE1
PRINT MYFIELD FIELD2
END

The keyword WITH says that the 'from' field is a DEFINEd field, associated with the segment containing the field FIELD1.