Error in Function Name

[Ivan Smahin]

Hello Beatrix,

Sunday, July 18, 2010, 7:07:21 PM, you wrote:

> Sometimes I'm getting an error VException 591118 Error in function
> name "PathSort".

It means there is no registered function named PathSort.


> The SQL is the following

> select RecID, MailboxPath, WhereClause, PathSort(MailboxPath) from mailbox order by 4

> The function PathSort is created when the database is created

>   theSQL = "create or replace function PathSort(thePath string)
> returns string begin case when lower(list_nthitem(thePath, 1, ':'))
> = 'inbox' then return concat('1:', replace(replace(thePath, ' ',
> 'zzzyyy'), ':', 'zzzxxx')); when lower(list_nthitem(thePath, 1,
> ':')) = 'sent' then return concat('2:', replace(replace(thePath, '
> ', 'zzzyyy'), ':', 'zzzxxx')); when lower(list_nthitem(thePath, 1,
> ':')) = 'sent messages' then return concat('2:',
> replace(replace(thePath, ' ', 'zzzyyy'), ':', 'zzzxxx')); "
>   thesql = theSQL + "when thePath = 'Trash' then return
> concat('3:', replace(replace(thePath, ' ', 'zzzyyy'), ':',
> 'zzzxxx')); when lower(list_nthitem(thePath, 1, ':')) = 'views' then
> return concat('4:', replace(replace(thePath, ' ', 'zzzyyy'), ':',
> 'zzzxxx')); else return concat('5:', replace(replace(thePath, ' ',
> 'zzzyyy'), ':', 'zzzxxx')); end case end"
>   call ValentinaDB.SqlExecute(theSQL)
>   
> I know that the function works but why do I sometimes get the
> error? The error message isn't really helpful. I have seen this
> after opening a database. A customer has the error message after adding data to the database.


Firstly I would diagnose the db.
Then, probably someone just drops the function?


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