I found a fix.

The problem was that I was passing in string values like "$2,000",
"$1,999", "$1,000".

For some reason param text in v5 doesn't like an unescaped $ symbol.

Escaping $ (\$) in the STRING command format solved the problem.

$estim :
=String([IOPR_COST_ESTIM_HIST]cost_estimate_dollars;"\$#,###,###,###")

-- Brad

On 8/27/10 2:48 PM, Brad Perkins wrote:
> Given these param text template declarations:
>
> $row_html := "<tr><td class=\"^5\">^1</td><td class=\"^5\"
> style=\"text-align:right\">^2</td><td class=\"^5\">^3</td><td
> class=\"^5\">^4</td></tr>"
> if ($delete_checkbox) `prepend first column
>     $row_html := "<tr><td class=\"^5\">^6</td><td
> class=\"^5\">^1</td><td class=\"^5\"
> style=\"text-align:right\">^2</td><td class=\"^5\">^3</td><td
> class=\"^5\">^4</td></tr>"
> end if
>
> Where $row_html would be supplied to param text as follows:
> param text ($row_html;$date;$estim;$by;$comment;$class)
> param text ($row_html;$date;$estim;$by;$comment;$class;$checkbox)
>
> I'm seeing strange param text output for the $estim value (param ^2)
> which is a cost estimate in rounded dollars amount.
>
> It is built like this:
>
> $estim :=
> String([IOPR_COST_ESTIM_HIST]cost_estimate_dollars;"$#,###,###,###")
>
> It may also be "No Cost Impact".
>
> I have verified that the String command is formatting the value as
> expected.
> I have verified that value is expected prior to calling param text.
>
> This is the same code that we are running on our production
> 4D2003/Active4D V4 system. That system displays the dollar estimate
> amounts as expected.
>
> With v11 and Active4D v5r19 I'm getting strange output:
>
> Cost 2000 => empty string (It should be 2,000)
> Cost 1000 => ,000 (It should be 1,000)
> Cost 1999 => ,999 (It should be 1,999)
>
> Is this a bug?
>
> _______________________________________________
> Active4D-dev mailing list
> [email protected]
> http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
> Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
>

_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Reply via email to