Hi Marc,

> Is there a function (maybe in the gds32.dll) to compile the source code

from the stored procedure. For example: if I give the user the opportunity
to create a new database in my application with my stored procedures.
Normally I have to create the procedures and remove the source code with the
update-SQL. But if someone logs the SQL statements, network traffic or
whatever, everybody can see the source.

>
> Is there another way?
>
> Compile it on my machine and insert the compiled code? But what about

different releases? Will that work? Or .... as I asked: is there a function
or something like that in a DLL?

>
> Thank you very much in advance for your response.

If you want your users to create a new DB, why not restore
a meta-data only backup into a new db? This way, you can
have your procedure code erased, create a backup, and restore
that backup.

With regards,

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