--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> Hi,
>
>
> > How can i define UDFs for void functions ?
> >
> > I get an error for this syntax:
> > "DECLARE EXTERNAL FUNCTION OUTPUTDEBUGSTRING Cstring(64)
> > ENTRY_POINT 'OutPutDebugString' MODULE_NAME 'kernel32.dll';"
>
> You cannot use just any DLL, the function needs to be created with
> some strict rules.
>
> > More specifically, how can i define UDF for OutPutDebugString api
> > function in kernel32.dll?
> >
> > I want to use it in Stored Procedures.
>
> Create a wrapper external function library and let your function
> return a simple integer or so.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,

Oracle &

> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>

Thanks for infos,
Can i ask why there is a such restriction ?
I am using OutPutDebugString for obtaining some informations from
stored procedures via listener program (debugview from sysinternals).
i thought even it would be possible to listen messages with in a rad
ide with embedded server.
Now, I will write my own dll for this purpose, which looks very easy
to do.

Btw Martjin,
I am curious about how did u implement debugging abilities for
Sp/triggers in DBworkbench. Does Firebird have api functions for
debugging?