Look...

> That's right.
> I create the DB,
> But I don't have any triggers.
> No SP no nothing just plain DML statements.
> I use OPF which supports not just FDB also supports Access, MSSQL and
> ORACLE.
> In this case I have to inject extra SQL statement into the program.
> I don't want to deal with IFDEF compilation conditions.

So, you cannot reach the Firebird API either?

Generators aren't supported in MS Access or MS SQL.

Do you want to have a "demo application" for each of these database types?

And you want us to figure out a generic solution for all these systems?

> > Thanks Martijn.
> > Unfortunatelly, I don't have a chance to use triggers.
>
> You create the database, right? So why can't you create triggers?

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