When using EZWriter with UDFs for Events and Orders, you much specify the value in CR073_EXT_ACCT_CODE in the Where clause of your SQL statement. However, the @ORDER and @EVENT values in the where clause will be replaced by the values of the Event and Order parameters being passed to EZWriter. This is because EZWriter simply does a find and replace on the parameter values.
To avoid this, you must split the text up to avoid using the pattern EZWriter uses to identify parameters. So instead of CR073_EXT_ACCT_CODE = '@EVENT' enter CR073_EXT_ACCT_CODE = '@' +'EVENT'
Once this change is made, your UDF values should be properly filled in on the template you are using with EZWriter.
Comments
0 comments
Please sign in to leave a comment.