At 05:14 PM 15-02-02 +0000, you wrote:

>Hello
>
>Can anyone recomend a good book on SQL and where to get it. I ave
>purchased several and all give generalizations about triggers, stored
>procedures etc. None explain them in detail with examples.
>

A book on SQL would be a great investment for you but, unfortunately, it won't help you with FB/IB procedure language (PSQL). PSQL (a.k.a. P/L in some RDBMSs) is "vendor-specific", meaning there is no standard implementation. MSSQL's P/L, for example, is a variety of an old version of VB; Oracle's is a full-blaze language in its own right with hooks to other products; etc. etc.

The IBPhoenix site has a couple of papers on writing triggers and procedures - old, but the language hasn't changed a great deal over the years.

Sorry to be a stinker, but an issue like this isn't an IBO topic. You will get lots of help on SQL and engine tricks & workarounds by joining the ib-support list (same server as this one).


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at www.ibobjects.com