Linking to calculated fields
D2005, RB V 9.03
I've created tables to display day and month strings as such;
Int String
1 First
2 Second
...
1 January
2 February
The intent was to link, (join) to a calculated field from the SQL
EXTRACT function which returns an integer for either the day or month.
However, DADE won't let me link on a calculated field.
Is there a workaround for this?
Thanks,
John
I've created tables to display day and month strings as such;
Int String
1 First
2 Second
...
1 January
2 February
The intent was to link, (join) to a calculated field from the SQL
EXTRACT function which returns an integer for either the day or month.
However, DADE won't let me link on a calculated field.
Is there a workaround for this?
Thanks,
John
This discussion has been closed.
Comments
Unfortunately it is not possible to link calculated fields in Dade. However
this can be done manually in code. Take a look at the following example.
http://www.digital-metaphors.com/tips/LinkDADEPipelines.zip
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Thanks very much!
John