Clearing an attribute?

Rem · Post by **Rem** » Tue Jan 22, 2008 11:48 am

Anyone knows how to clear an attribute from it´s value?

If I set it to 0 it will be 0 and also if I set it to '' it will be 0 (zero).

But how do I get it blank, as it is before anything is written to it?

/Rem

tford · Post by **tford** » Tue Jan 22, 2008 1:14 pm

Rem,

If you are doing it via rule use:

SomeBO.SomeAttribute=UNDEFINED

Tom

tford · Post by **tford** » Tue Jan 22, 2008 1:15 pm

oops -- I think the syntax might actually be IS UNDEFINED rather than =UNDEFINED.

Tom

Rem · Post by **Rem** » Tue Jan 22, 2008 1:39 pm

This doesn´t seem to work either.

It seems as UNDEFINED is used more for checking than for assigning. If I use it, it still is 0.

I also tried to assign it = another attribute wich was unassigned (blank) but it still ended up as 0.

Strange..

/Rem

christopherb · Post by **christopherb** » Tue Jan 22, 2008 6:21 pm

Rem,
Curious why would you wish an interger to be blank as to zero?

Chris

Rem · Post by **Rem** » Tue Jan 22, 2008 6:30 pm

Ahh, thougt someone might ask.

It easy, I want it blank in a printout report. If there is a lot of 0:s everywhere it´s much easier to miss out a little change. But if usually is blank a number showing up would be hard to miss.

And in this case we are talking about a basis for invoycing and we don´t won´t to miss out on that

!

/Rem

tford · Post by **tford** » Tue Jan 22, 2008 6:54 pm

Rem,
There may be easier ways to do it, but a couple of things come to mind:

1- Have a report element be conditional -- if the attribute is greater than zero, show the number -- otherwise show blank

2- Have a second attribute in your BO that is for report purposes. Have a rule set the second attribute something like this:
BO.TextAttribute=AS_STRING(BO.NumberAttribute)

You may have to use a conditional rule that sets BO.TextAttribute to a blank if BO.NumberAttribute is zero.

Tom