it seems there is a bug somewhere in the sql-handling of scriptcase.
i want to make a grid-application for a oracle-database with on the right side of the table a couple of columns with links to other applications. those links i construct with the oracle-decode function so the showing-up of the links can be made dependent on values of other columns. like in this one:
SELECT
MELDINGNR,
ISIS_STUDENTNR,
AANVRAAGNR,
STUDIEJAAR,
MELDINGSTATUS,
DECAAN,
STUDIEADVISEUR,
decode(studieadviseur, null, decode(decaan, null, ‘delete’, ‘’), ‘’),
decode(gezien_door_student, null, ‘edit’, 0, ‘edit’, 1, ‘’),
MELDINGDATUM,
…
if i code this and run the application it works as expected. the first decode-generated link-column only shows the text ‘delete’, when both the studieadviseur and decaan columns are null. the second decode-generated link-column only shows the text ‘edit’, when the gezien_door_student column is null or 0 (zero).
now i want to extend the funtionality of the second decode by adding the requirement the text ‘edit’ only shows, when both columns gezien_door_student and decaan are null or 0 (zero) and null. so i change the second decode-generated link-column to:
decode(gezien_door_student, null, decode(decaan, null, ‘edit’, ‘’), 0, decode(decaan, null, ‘edit’, ‘’), 1, ‘’)
after changing the sql-statement of the grid-application this way the effect of that is nop. the application behaves as if the change didn’t occur. the only way to get things working the intended way from this point is to start all over again with a new application. if you continue trying to get it right with editing or changing things at a certain point scriptcase starts to mix-up the sql and gives weird error-messages, when running the app.
is this a bug? is this a cache problem? anyone a solution to get scriptcase to understand my edits to the sql right-a-way?
/scriptfan