chipp at chipp.com
Wed Mar 22 19:22:35 EST 2006
You need to perform a math action on it first.
put it into tShowid
add 0 to tShowID
should do it.
> I have this bit of code the numberFormat
> is not giving me two zeros after the decimal point
> Why ???
> thanks in advance
> global gConID
> get fld "showid"
> put it into tshowid
> set the numberFormat to "#0.00"
> put "SELECT sum (child) FROM Booking where showid = '"& tshowid & "'"
> into tChild
> put revdb_querylist(,,gConID,tChild) into tcSeats
> put tCseats into fld "child"
> put "SELECT sum (adult) FROM Booking where showid = '"& tshowid & "'"
> into tAdult
> put revdb_querylist(,,gConID,tAdult) into tAseats
> put tAseats into fld "Adult"
> put "SELECT sum (cashDb) FROM Booking where showid = '"& tshowid &
> "'" into tCash
> put revdb_querylist(,,gConID,tCash) into tCashFld
> put tCashFld into fld "cash"
> Liam Lambert
> liamlambert at mac.com
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode