NumberFormat

[Eric Chatonet]

Hi Liam,

Specifying the numberFormat is not enough:
If you want the numberFormat applied, you *must* make any numeric  
calculation :-)
For instance:

put tFinalTotal * 1 into fld "FinalTotal"

Le 17 janv. 06 à 17:44, liamlambert a écrit :

>
> Hi all
> I am calling a col total from a data Base  and not getting the  
> right format
> Say the Total is 100.50
> I am getting 100.5
>
> this is the code
>
>
>
> set the numberFormat to "00.00"
> get fld "showid"
> put it into tshowid
>  put "SELECT sum (total) FROM showDb where showid = '"& tshowid &  
> "'" into tTotal
>  put revdb_querylist(,,gConID,tTotal) into tFinalTotal
>  put tFinalTotal into fld "FinalTotal"

Best Regards from Paris,
Eric Chatonet
------------------------------------------------------------------------ 
----------------------
http://www.sosmartsoftware.com/    eric.chatonet at sosmartsoftware.com/