[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Numeric Edit Mask
- Subject: Re: [sqr-users] Numeric Edit Mask
- From: "Arnon Oppenheimer" <arnono@semech.co.il>
- Date: Wed, 23 Oct 2002 17:06:11 +0200
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
- References: <sdb433ad.027@magnatrax.com>
Use IF :
IF #val > 0
print '+' (1,1)
print #val ()
ELSE
print #val (1,1)
END-IF
or cond:
let $x=cond(#val>0,'+' || Edit(#val,'888888'),Edit(#val,'88888888'))
Regards,
Arnon Oppenheimer
-------------------------------------------------------------------
SEMECH SOFTWARE MARKETING LTD.
TEL : (972) - 3 - 5333144
FAX : (972) - 3 - 5333132
Email: arnono@semech.co.il
-------------------------------------------------------------------
----- Original Message -----
From: Kent Parker
To: sqr-users@sqrug.org
Sent: Tuesday, October 22, 2002 12:04 AM
Subject: [sqr-users] Numeric Edit Mask
I'm writing an interface with SQR and need to create signed numeric fields
with the positive fields showing a plus sign (+) and the negative fields
showing a negative sign (-) at the beginning of each.
Do you guys have a solution for this?
Thanks a million.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users