Mike is absolutely right! I was thinking of UPDATE… Lots of grey matter lost these past years. How do you stay so sharp Mike?
From: [email protected] [mailto:[email protected]] On Behalf Of Michael Byerley Sent: Friday, August 18, 2017 9:02 AM To: RBASE-L Subject: [RBASE-L] - Re: This worked previously as a on click eep but not now under version X 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, 6056 Tel +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 -- 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]<mailto:[email protected]>. For more options, visit 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.
