Tablename as Parameter in stored function

[Ivan Smahin]

Hello Martin,

Thursday, October 18, 2007, 4:54:21 PM, you wrote:

> How can I pass a table name into a stored procedure?

> This is my function:

> CREATE FUNCTION NextAutoID(inValue string)
> RETURNS ULONG
> begin
>     DECLARE max_autoid ULONG ;
>     select MAX(AutoID) INTO max_autoid from  inValue ;
>     RETURN max_autoid + 1 ;
> end;


> but I get this error:
> error: Table "inValue" not found.

Hmm, report it to mantis please as feature request.



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com