Introduction
IBSite is a free extension to CodeSite 2 from Raize Software which allows CodeSite messages to be sent from Interbase Stored Procedures and Triggers. It comes as a collection of UDF's (User Defined Functions), which once installed into Interbase, can be called like any other statement from Interbase SQL.

Requirements
IBSite has been tested with CodeSite 2 Professional and Interbase v6.0 on Windows. We aren't taking advantage of any of the features not present in CodeSite 2 Standard, so we believe it should also work with the Standard Edition. Additionally, Interbase has had UDF support for a number of versions, so we believe it should also work with any Interbase version on Windows which supports UDF's. As we try it out with more versions, we'll post the results.

Installation
On Interbase v6.0, the IBSITE.DLL should be copied to the UDF directory under the Interbase root directory. On previous versions of Interbase, IBSITE.DLL will need to be placed somewhere on the PATH. Once this is done, run the REG.SQL script against the database you wish to use IBSite within. This script registers the UDF functions with your database, and also creates some wrapper Stored Procedures. The UDF will need to be registered with each database you wish to use IBSite with.

If you're running Interbase as a Service, you will need to turn on the "Interacts with Desktop" flag in the Service Properties.

That's it. You're installed.

Uninstall.
Run the UNREG.SQL script against the database from which you wish to remove IBSite support. Once none of your databases have the UDF registered, you can delete IBSITE.DLL (You may need to shutdown Interbase first, as it loads the dll into memory and won't unload it until Interbase is shut down)

Use
To test your installation, bring up ISQL and run the following statement:

execute procedure csSendString 'Name', 'Value'

If all is working, you should see a message appear in your CodeSite 2 Viewer.

Have a look at the TEST.SQL script for a stored procedure which uses a lot of the calls.

More Info
For more info, check the IBSite homepage at http://www.madrigal.com.au/products/ibsite/default.htm. For bug reports or feature requests email support@madrigal.com.au

Version History

Disclaimer (Legal Stuff)
IBSite is made available for free to the developer community, in the hope that people will find it useful. Madrigal Technologies Pty Ltd is not responsible for any damage caused through it's use. Basically, feel free to use it, but it's not our problem if it damages anything.

If you want to distribute this from any other website than Madrigal Technologies' website, or on magazine disks, etc, then please get our permission first.

Madrigal Technologies retains all rights to IBSite. Just because we give licenses away for free, doesn't mean we give up our legal rights to the software.