Currency-Format and a string

[d***@googlemail.com]

Hello out there,

I´ve got a huge problem:

This is, what´s my computed filed looks like:

'Please... '+case( stamm_verfueg when is < 0 then' This is... ' +
string( stamm_verfueg,'#,##0.00 €'+' xyz,') else 'dfdsfdsfdsf '+string
(((stamm_verfueg_finanz_limit_hw_fir)),'#,##0.00 €')+' verfügbar.')...

I hope i now did not erase too much from the syntax.

Wit this code I get an result for stamm_Verfueg like "3.000,00 €"
But if the value of stamm_verfueg is for example 30.000 I also get
"3.000,00 €" as result.

I really do not know, how to fix this problem.

Greets

Dominic

[Terry Dykstra [TeamSybase]]

In a case like this, just show the whole computed field.

Make the format string longer. Something like:

case stamm_verfueg
when < 0 then string(stamm_verfueg, '#,##0.00') + 'xyz'
when > 10000 then string(stamm_verfueg, '#,###,##0.00') + 'abc'
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<***@googlemail.com> wrote in message news:2aa32154-d775-4329-b271-***@i18g2000prf.googlegroups.com...
Hello out there,

IŽve got a huge problem:

This is, whatŽs my computed filed looks like:

'Please... '+case( stamm_verfueg when is < 0 then' This is... ' +
string( stamm_verfueg,'#,##0.00 €'+' xyz,') else 'dfdsfdsfdsf '+string
(((stamm_verfueg_finanz_limit_hw_fir)),'#,##0.00 €')+' verfügbar.')...

I hope i now did not erase too much from the syntax.

Wit this code I get an result for stamm_Verfueg like "3.000,00 €"
But if the value of stamm_verfueg is for example 30.000 I also get
"3.000,00 €" as result.

I really do not know, how to fix this problem.

Greets

Dominic