Some ideas - Does Costs have a PK that is not being updated with a new value on the insert? - Should your insert include the value of the current row for reference?
Albert > On Aug 17, 2017, at 8:01 AM, DB GEOINFO <[email protected]> wrote: > > Simple problem. Old fashioned. This just calculates a 10% tax except when > less is levied or sometimes zero. Simple but doesn’t work anymore. Nothing > happens. Gst is not updated. How should I re-write it? > > > EEP > *(calc_gst) > *(Y = 10% gst, N = 0 gst, X = manual gst entry) > > SET VAR vgst1 = .CGST > SET VAR vcamt = .CAmt > SET VAR vynx = .GstYN > SET VAR vgst = 0 > SWITCH (.vynx) > CASE 'Y' > SET VAR vgst = (.vcamt/11) > BREAK > CASE 'N' > SET VAR vgst = 0 > BREAK > CASE 'X' > SET VAR vgst = .vgst1 > BREAK > ENDSW > > INSERT INTO Costs (CGst) VALUES (.vgst) > > RECALC VARIABLES > RETURN > > Drake-Brockman Geoinfo Pty Ltd > 404 Great Eastern Highway > Woodbridge, Perth, WA, Australia, 6056 > Tel +61 8 9274 5477 <tel:%2B61%208%209274%205477> > Mob +61427 525952 > Email [email protected] <mailto:[email protected]> > Web www. dbgeoinfo.net.au <http://dbgeoinfo.net.au/> > Dropbox URL: https://www.hightail.com/u/DBGEOINFO > <https://www.hightail.com/u/DBGEOINFO> > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
