Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Migrating from DBISAM to ElevateDB
Thu, Feb 21 2008 3:50 AMPermanent Link

Robert Wismet
Hi,

I am trying to migrate our Database-Server-Engine from DBISAM to ElevateDB. Currently we use a own Database-Server-Engine based on the TDBISAMEngine.

In that server we used the events "BeforeDeleteTrigger", "BeforeInsertTrigger" and "BeforeUpdateTrigger" as well as "OnCustomFunction", "OnServerProcedure" and "OnServerScheduled".
Behind this events is a lot of C++Code (we are using C++Builder) which I don't want to rewrite completelly...

Where are this events in ElevateDB??

Regards,
Robert
Thu, Feb 21 2008 1:24 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Robert,

<< I am trying to migrate our Database-Server-Engine from DBISAM to
ElevateDB. Currently we use a own Database-Server-Engine based on the
TDBISAMEngine.

In that server we used the events "BeforeDeleteTrigger",
"BeforeInsertTrigger" and "BeforeUpdateTrigger" as well as
"OnCustomFunction", "OnServerProcedure" and "OnServerScheduled".   Behind
this events is a lot of C++Code (we are using C++Builder) which I don't want
to rewrite completelly...

Where are this events in ElevateDB?? >>

Triggers and jobs (scheduled events) in ElevateDB are handled via SQL/PSM,
and to use native code in them you'll have to define an external module that
is callable as a stored procedure from the triggers and jobs.  You won't
have to rewrite the actual code, however.  If you want to send me what
you're using, I can send you back a completed external module template and
SQL examples that accomplish what you want.  It will probably be Monday when
I can get to it, but it won't take me long to do.

In the meantime, if you haven't reviewed this section of the EDB manual, you
should probably do so:

http://www.elevatesoft.com/scripts/manual.dll?action=mancat&id=edb1&product=p&version=2007&category=2

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Feb 22 2008 8:07 AMPermanent Link

Robert Wismet
Hi Tim,

thank you very much for that offer! I played with the new triggers today and they are looking great SmileBut I think I sould refresh my SQL/PSM knowlege first SmileI also found out how to use
a external dll module! I think I'll try out that all again next week and if there are problems I'll post a new message again Smile

Thanks!

Robert
Image