Tim,

We make extensive use of custom functions in DBISAM to do things that we would not be able to do in SQL. I am just starting to look at migrating to
ElevateDB and I don't see where we can create custom functions in Delphi code but will have to use SQL. Our custom functions have to deal with
extracting data from the complex MARC record format (the standard for bibliographic data in libraries). We wouldn't be able to code these in SQL. I am
a total newbie to ElevateDB so maybe I'm missing something.

Thanks,
Danny

Danny,

<< We make extensive use of custom functions in DBISAM to do things that we
would not be able to do in SQL. I am just starting to look at migrating to
ElevateDB and I don't see where we can create custom functions in Delphi
code but will have to use SQL. Our custom functions have to deal with
extracting data from the complex MARC record format (the standard for
bibliographic data in libraries). We wouldn't be able to code these in SQL.
I am
a total newbie to ElevateDB so maybe I'm missing something. >>

Welcome to ElevateDB.

For writing functions in Delphi code, you need to create an external module
using the templates that we install into the development environment.  What
product are you using EDB with ?  I can then tell you what steps to take to
create an external module for use with EDB.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

We're using Delphi 2007.

Thanks,
Danny

Danny,

<< We're using Delphi 2007. >>

Okay, use the following steps:

1) Select File/New/Other from the main menu.
2) Click on the ElevateDB folder in the New Items dialog.
3) Click on the ElevateDB External Module icon on the right.
4) Click on the OK button.
5) Select the target directory.
6) Once the project is loaded, press Shift-F12 to select and bring forward
the external module window.
7) Fill in the EDBExternalModuleRoutine event handler and compile the
project.
8) Place the resultant DLL in the same directory as the configuration file.
9) Execute the following SQL on the target database to create the
function(s) in EDB:

http://www.elevatesoft.com/edb1sql_create_function.htm

where you would fill in EXTERNAL NAME <ModuleName> with the name of the DLL
that you just compiled.

You can always find out which modules (DLLs) are present for use with
ElevateDB by querying this Configuration database table:

http://www.elevatesoft.com/edb1sql_modules_table.htm

http://www.elevatesoft.com/edb1d7_querying_configuration_objects.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim:

These 3 web page references are no longer valid.  Might they be somewhere
else for reference?  Thanks.





C





"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:4B1CC098-B557-42DF-9C29-FFB36495F852@news.elevatesoft.com...
> Danny,
>
> << We're using Delphi 2007. >>
>
> Okay, use the following steps:
>
> 1) Select File/New/Other from the main menu.
> 2) Click on the ElevateDB folder in the New Items dialog.
> 3) Click on the ElevateDB External Module icon on the right.
> 4) Click on the OK button.
> 5) Select the target directory.
> 6) Once the project is loaded, press Shift-F12 to select and bring forward
> the external module window.
> 7) Fill in the EDBExternalModuleRoutine event handler and compile the
> project.
> 8) Place the resultant DLL in the same directory as the configuration
> file.
> 9) Execute the following SQL on the target database to create the
> function(s) in EDB:
>
> http://www.elevatesoft.com/edb1sql_create_function.htm
>
> where you would fill in EXTERNAL NAME <ModuleName> with the name of the
> DLL that you just compiled.
>
> You can always find out which modules (DLLs) are present for use with
> ElevateDB by querying this Configuration database table:
>
> http://www.elevatesoft.com/edb1sql_modules_table.htm
>
> http://www.elevatesoft.com/edb1d7_querying_configuration_objects.htm
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Carlton,

<< These 3 web page references are no longer valid.  Might they be somewhere
else for reference?  Thanks. >>

You can find them here:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=10&topic=159

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=3&topic=42

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1&product=d&version=7&category=4&topic=13

--
Tim Young
Elevate Software
www.elevatesoft.com