Sef
VIP Member
I am trying to make the Create!Stream output configurable.
We have scheduled reports running over the weekend and rather than hardcoding the email destinations in create!Stream or adding the email addresses to the pdf, I want to use a custom table with only 2 columns. Column 1 = UBE name (+version + environment) and column 2 is the destination email address.
By using the Create!Stream lookup-list functionality (after setting up the appropriate ODBC connetions to the E1 database) I can find the destination email address.
However, whilst trialing this solution I receive the error 'Program type out of range'. Strangely enough if I retrieve a numeric value from a table the method is successful!? Retrieving a character field or a string always fails!
Bottomline suggests that the string type (nvarchar vs varchar) is incompatible.
Has anybody else seen this issue and have a solution for it?
TIA for any feedback,
We have scheduled reports running over the weekend and rather than hardcoding the email destinations in create!Stream or adding the email addresses to the pdf, I want to use a custom table with only 2 columns. Column 1 = UBE name (+version + environment) and column 2 is the destination email address.
By using the Create!Stream lookup-list functionality (after setting up the appropriate ODBC connetions to the E1 database) I can find the destination email address.
However, whilst trialing this solution I receive the error 'Program type out of range'. Strangely enough if I retrieve a numeric value from a table the method is successful!? Retrieving a character field or a string always fails!
Bottomline suggests that the string type (nvarchar vs varchar) is incompatible.
Has anybody else seen this issue and have a solution for it?
TIA for any feedback,