Wow Craig, total typo in my case! Sorry for the confusion...

> > >If not, is there any other reason a UDF
> > > shouldn't be used instead of a sproc (I'd rather use a sproc,
> since
> > > their easier to maintain, but some things need to or should be
> done
> > > in C/C++)?
> >
> > External Functions should call back into the database. Plain and
> > simple.
>
> Should? I read that external functions which call back into the
> database (by necessity inside a separate transaction) could
> potentially cause deadlock.

SHOULD NOT.

Plain and simple, well, it is now ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com