INSERT does not use a Where clause UNLESS there is a qualifying SELECT [which would base criteria on an entirely different table or condition to limit whether the insert is to be done or not]
INSERT does just one thing by itself. it adds a row of data. On Thursday, August 17, 2017 at 10:01:32 AM UTC-4, dbg 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, 6056Tel +61 > 8 9274 5477 Mob +61427 525952 Email [email protected] <javascript:>* > > *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 --- 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.
