Linking string field to number field? 1

[Slonoma]

Hey all,
What are my options as far as linking a string field to a number field using CR 9 and Oracle?

Thanks,

Slo-No

 

[lyanch]

The easiest way to handle this is with the add command function where you write your own SQL. You can then cast the string to a number or vs versa. for the link.

Lisa

 

[Slonoma]

Lisa,
Thank you very much. This is going to take some work but you got me going on the right path!

Slo-No

 

[RogaDanar]

You can also create a 'view' for the numbered table.

e.g.

create or replace view StringContacts
(name, state, age)
as
select name, state, to_char(age)
from Contacts

When you pull in the StringContacts view to the report (instead of the Contacts table), you can now link 'age' to the other string.

Not the best example, but hopefully it gets you started.