how can i add in my own delphi-elevate-databaseserver some functions for sql statements?

our sql statements are now written for microsoft sql server. there are ISNULL or GETDATE() functions. i don't want use the sql-functions per database.

is there any other opportunity to add a custom function in the delphi code and add to the TEDBEngine?

aduna

>how can i add in my own delphi-elevate-databaseserver some functions for sql statements?
>
>our sql statements are now written for microsoft sql server. there are ISNULL or GETDATE() functions. i don't want use the sql-functions per database.
>
>is there any other opportunity to add a custom function in the delphi code and add to the TEDBEngine?

ElevateDB supports custom functions at two levels - one's written in SQL and one's written in Delphi. To use Delphi you have to develop the function as a dll (one dll can contain many functions) and reference it to the engine. There are examples of external functions in the extensions newsgroup and quite a few posts in this newsgroup.

Roy Lambert [Team Elevate]

aduna

EDB Has Current_Date and Current_Timestamp to return the date or time.

You can use the following:

Current_Date - INTERVAL '1' MONTH to return today less one month.

You can use the following:

WHERE SomeDate = DATE '2013-01-01'

to cast a correctly formatted string to a date. Once cast you can also use "INTERVAL" to add and subtract from this new date.

--

ISNULL()

This function is already present in EDB. There are also useful variations:

You can use

IF(Somefield IS NULL then 'something' else 'something else')

or

WHERE Somefield IS NULL

If you open EDBMgr, and load the help (sometimes you will have to set the help path in File, Preferences, Help first) there is a good section of help on all the available functions:

Numeric Functions,
String Functions,
Array Functions
... plus more.

Please look in the help.