Re: [sqr-users] SQR Bug.

[Don Mellen <donm@ontko.com>]

On Mon, 22 Dec 2003, Ian Mills wrote:

...
> The value returned from the query is correct, but when I assign it
> to a global variable, the number changes.
> 
> Here is the offending source code...
> begin-select
> sum(TOTAL_DOCL_PRICE) &sales
> 
>     add &sales to #_gf_prim_g1   ! *************** offending line
...
>     subtract #_gf_extra_ar_gst_error from #_gf_prim_g1
> 
> from doc d,
> ...
> 
> After the end-select I show the values to write them to the log file
> #debugt show ''
> #debugt show 'SALES : ' &sales '           Current G1 : ' #_gf_prim_g1
> 
> The results in the log file are as follows...
> SALES : 38925864.48           Current G1 : 37114136.550000

Check the value of #_gf_extra_ar_gst_error, which you subtract from the
value of #_gf_prim_g1.   My guess is it equals 1811727.93.

HTH,
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users