Only thing I see is missing DEFAULT and BREAK before ENDSW.  But I don’t 
understand SET VAR vgst = (.vcamt/11) as calculating 10%...  And clearly your 
INSERT needs a WHERE clause.

Claudine

From: [email protected] [mailto:[email protected]] On Behalf Of 
DB GEOINFO
Sent: Thursday, August 17, 2017 9:01 AM
To: [email protected]
Subject: [RBASE-L] - This worked previously as a on click eep but not now under 
version X

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

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.

Reply via email to