Pass a Char ('F') from Report triggers in Oracle Reports

[MarcelBeals]

Hello,
I am new to Oracle 8 and would like to know if anyone has ever come across this problem:
Just before the sql is executed i want to pass it part of the SQL statement:
function BeforeReport return boolean is

begin
_PrevYear := _CurrYear - 1;

IF _Gender_Selection = 'Female' THEN
_Where_Clause := 'AND Warehouse.Gender_CD := ' || 'F';
ELSIF _Gender_Selection = 'Male' THEN
_Where_Clause := 'AND Warehouse.Gender_CD := ' || 'M';
ELSIF _Gender_Selection = 'Unknown' THEN
_Where_Clause := 'AND Warehouse.Gender_CD := ' || 'U';
ELSE
_Where_Clause := ' ';
END IF;

return (TRUE);
end;

Marcel.

 

[Hehenka]

You can try this:

begin
_PrevYear := _CurrYear - 1;

IF _Gender_Selection = 'Female' THEN
_Where_Clause := 'AND Warehouse.Gender_CD := ' || ''F'';
ELSIF _Gender_Selection = 'Male' THEN
_Where_Clause := 'AND Warehouse.Gender_CD := ' || ''M'';
ELSIF _Gender_Selection = 'Unknown' THEN
_Where_Clause := 'AND Warehouse.Gender_CD := ' || ''U'';
ELSE
_Where_Clause := ' ';
END IF;

return (TRUE);
end;