>when i try to create this simply function get this error >~ Error: [-5016] (at 67): Missing delimiter: )
>create function dba.fn_conta_ExisteNivelSuperior(strCuenta varchar(30)) >Returns varchar(10) AS >Var strRetVal varchar(10); >Try > Set strRetVal = 'S'; >Catch > If $RC <> 100 Then Stop($rc, 'unexpected error on >fn_conta_ExisteNivelSuperior'); >Return strRetVal; Please have a look to http://dev.mysql.com/doc/maxdb/en/5a/962f81d1cbbb408c11829eb08051f3/frameset.htm The datatype varchar has a special meaning in the context of functions. VARCHAR means that the database kernel calculates the length automatically depending on the embedding sql statement. You should therefore change the function as follows : create function dba.fn_conta_ExisteNivelSuperior(strCuenta char(30)) Returns char(10) AS Var strRetVal char(10); Try Set strRetVal = 'S'; Catch If $RC <> 100 Then Stop($rc, 'unexpected error on fn_conta_ExisteNivelSuperior'); Return strRetVal; Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
