Triggers

This is the first time, I have been playing with Triggers, and have tried to
put together a "Trigger creator".

I have tested it with my various DataBases, which are quite basic, and it
seems to work for me.

I am certain however, that there is a lot of scope for improvement, and if
somebody is interested in helping me to improve it, I would like to hear
from you.

Kind Regards
Wolfgang

wolfgang@compmark.net

PS: uploaded the source to Binaries under same subject

You need Synedit and the Jedi Library to compile

> You need Synedit and the Jedi Library to compile

Links pls?

--

Eivind Bakkestuen
Nexus Database Systems Pty Ltd

ftp://ftp.delphi-jedi.org/api/win32api.zip
http://sourceforge.net/project/showf...ckage_id=86350

"Eivind Bakkestuen [NDD]" <Ieivind.bakkestuenHATE@nexusdb.comSPAM> wrote in
message news:47089c65@nexus-vkpb9bih5.Nexus.local...
>> You need Synedit and the Jedi Library to compile
>
> Links pls?
>
> --
>
> Eivind Bakkestuen
> Nexus Database Systems Pty Ltd
>

Wolfgang,

Instead of creating a log-table per normal table, you might want to create
a single log-table instead.

Pretty much like our product does ;-)

http://www.upscene.com/products/audit/ndblm_main.htm


--
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

Your product isn't free and I want to add it as a separate utility to my
Apps along with things like our DbViewer, Word Processor, Spreadsheet,
Export to PDF, Excel, XML etc.

It's all about Value Added at no additional Cost, cause the competition is
tough and with this AddOn-facility we can enable Admistrators to create
their own "Custom Audit Trail" any way they wish.

Kind Regards
Wolfgang



"Martijn Tonies" <m.tonies@upscene.removethis.com> wrote in message
news:470a10a2$1@nexus-vkpb9bih5.Nexus.local...
> Wolfgang,
>
> Instead of creating a log-table per normal table, you might want to create
> a single log-table instead.
>
> Pretty much like our product does ;-)
>
> http://www.upscene.com/products/audit/ndblm_main.htm
>
>
> --
> 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
>
>

Hello Wolfgang,

> Your product isn't free and I want to add it as a separate utility to my
> Apps along with things like our DbViewer, Word Processor, Spreadsheet,
> Export to PDF, Excel, XML etc.
>
> It's all about Value Added at no additional Cost,

Your working time is free of charge? ;-)

We offer bundle licenses at a reasonable price (at least we think it is
reasonable *g*), which allows you to give NDB LogManager to your
customers as many times as you want.

We even might be able to arrange something for you in particular, so you
don't have to re-invent the audit trail and you can concentrate on more
interesting things. ;-)

Well, if you are interested in getting in touch with us, then please
send me an email to: t . steinmaurer @ upscene . com

Sorry for the plug.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com

Actually, I prefer the individual log table per table. I implemented my
own that way and it has added the following features to my application:

1) History / audit trail (duh..!)

2) Allows easy implementation of caching tables where necessary. I use
Nexus's GetChangedTables() method and I only update records changed in
log files since the last update (via stored auto-inc fields on the log
table).

Best Regards,

Shane

My time isn't actually free. We are working on a monthly subscription basis,
which represents 90% of our revenue, coming from what is now approaching
1000 Clients, and I like it that way. I don't have to chase sales anymore,
but can concentrate on improving the product with a more longterm view,
which generates more sales all by itself.

In fact, as we got more and more Clients, we kept dropping the actual
purchase price, which by now is appr 1/3 of our competitors, at the same
time offering three times more in terms of content, speed.and stability, the
latter two thanks to NexusDB.

The "Trigger generator" I am presently working on, is another Addon to our
products, and I thought, there might be enough interest for some other Nexus
Users to get involved.

Kind Regards
Wolfgang


"Thomas Steinmaurer" <t.steinmaurer_dontbugmewithspam_@upscene.com> wrote in
message news:470a5337$1@nexus-vkpb9bih5.Nexus.local...
> Hello Wolfgang,
>
>> Your product isn't free and I want to add it as a separate utility to my
>> Apps along with things like our DbViewer, Word Processor, Spreadsheet,
>> Export to PDF, Excel, XML etc.
>>
>> It's all about Value Added at no additional Cost,
>
> Your working time is free of charge? ;-)
>
> We offer bundle licenses at a reasonable price (at least we think it is
> reasonable *g*), which allows you to give NDB LogManager to your customers
> as many times as you want.
>
> We even might be able to arrange something for you in particular, so you
> don't have to re-invent the audit trail and you can concentrate on more
> interesting things. ;-)
>
> Well, if you are interested in getting in touch with us, then please send
> me an email to: t . steinmaurer @ upscene . com
>
> Sorry for the plug.
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com

Wolfgang wrote:

> My time isn't actually free. We are working on a monthly subscription basis,
> which represents 90% of our revenue, coming from what is now approaching
> 1000 Clients, and I like it that way. I don't have to chase sales anymore,
> but can concentrate on improving the product with a more longterm view,
> which generates more sales all by itself.

I wish more people would sign up to paid support so that we could do the same
....

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm