Hi,

We are testing our software with DBISAM client/server version. We want to add a new function (distance) on the server side in order to be able to do
select statements like:

select distance(x1, y1, x2, y2)
from coordinates
where
 (X1 < 100) and distance(x1, y1, x2, y2) > 14.2

We looked in the customizing the server section in your documentation and did not find an answer. Could you advice?

Thank you,
Sergiu Oprea

Sergiu,

<< We looked in the customizing the server section in your documentation and
did not find an answer. Could you advice? >>

It's in there.  You have to set up the function and its parameters using
these methods:

CreateFunction

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

and CreateFunctionParam

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

The example in the manual shows how to use these both:

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

All of this, along with the actual function code, must be added to the
TDBISAMEngine component on the main form of the dbsrvr.dpr project that we
distribute with DBISAM.  It can be found in the \server\dbsrvr\source
subdirectory under the main DBISAM installation directory.  The function
code is added via the TDBISAMEngine.OnCustomFunction event handler, as show
in the DaysBetween function example in the above link.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Sergiu,

I assume you are using the V4 server, coz this is not possible in V3.

See the help section Customizing the Engine > Custom SQL and Filter
Functions

You should be able to do exactly what you want.

HTH
--
Best regards

Steve

"Sergiu Oprea" <sergiu.oprea@upcnet.ro> wrote in message
news:DC31C547-F12F-4FC3-B076-DC2F56F3C745@news.elevatesoft.com...

Hi Tim,

Thank you very much for your help, I did all the steps you told me on the client side but I did not complete in \server\dbsrvr\source, that is why it
did not work for client/server version.

Anyhow everything is ok now.

Thanks again,
Sergiu

Sergiu,

<< Thank you very much for your help, I did all the steps you told me on the
client side but I did not complete in \server\dbsrvr\source, that is why it
did not work for client/server version. >>

That's probably the item that trips up most of the developers that try to
implement a custom function for the first time.   I'm glad that you've got
it working now.

--
Tim Young
Elevate Software
www.elevatesoft.com