Le jeudi 11 d�cembre 2003, "H�bschen, Peter" a �crit...
bonjour,
> Create dbproc foo(In myvar1 smallint, in myvar2 varchar(3))
> Returns Cursor as
> Var
> SQLString Varchar(100);
> $Cursor = 'foo_Cursor':
> Begin
> SQLString = 'Select * from mytable where '
> If myvar1 > 0 Then SQLString = SQLString || ' compvar1 = ' || myvar1;
> If myvar2 <> '' Then SQLString = SQLString || 'compvar2 = ''' || myvar2;
> Declare :$Cursor Cursor for
> Execute SQLString;
> End;
I use this kind of syntax:
$Cursor = 'foo_Cursor';
SQLString = 'SELECT foo_Cursor(*) FROM theUser.theTable WHERE ';
...your if_statements ...
execute SQLString;
--
jean-michel
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
