Index: openacs-4/packages/simple-survey/sql/oracle/survsimp-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simple-survey/sql/oracle/Attic/survsimp-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/simple-survey/sql/oracle/survsimp-create.sql 15 Jun 2001 00:45:42 -0000 1.2 +++ openacs-4/packages/simple-survey/sql/oracle/survsimp-create.sql 9 Jul 2001 19:24:29 -0000 1.3 @@ -11,22 +11,23 @@ -- module, to be developed by buddy@ucla.edu, so we prefix -- all of our Oracle structures with "survsimp" +-- gilbertw - logical_negation is defined in utilities-create.sql in acs-kernel -- this is a PL/SQL function that used to be in the standard ACS 3.x core - not in the -- current ACS 4.0 core however... -create or replace function logical_negation(true_or_false IN varchar) -return varchar -is -BEGIN - IF true_or_false is null THEN - return null; - ELSIF true_or_false = 'f' THEN - return 't'; - ELSE - return 'f'; - END IF; -END logical_negation; -/ -show errors +-- create or replace function logical_negation(true_or_false IN varchar) +-- return varchar +-- is +-- BEGIN +-- IF true_or_false is null THEN +-- return null; +-- ELSIF true_or_false = 'f' THEN +-- return 't'; +-- ELSE +-- return 'f'; +-- END IF; +-- END logical_negation; +-- / +-- show errors begin Index: openacs-4/packages/simple-survey/sql/oracle/survsimp-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simple-survey/sql/oracle/Attic/survsimp-drop.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/simple-survey/sql/oracle/survsimp-drop.sql 15 Jun 2001 00:45:42 -0000 1.2 +++ openacs-4/packages/simple-survey/sql/oracle/survsimp-drop.sql 9 Jul 2001 19:24:29 -0000 1.3 @@ -64,6 +64,6 @@ / show errors +-- gilbertw - logical_negation is defined in utilities-create.sql in acs-kernel +-- drop function logical_negation; -drop function logical_negation; -