Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

General Information (SQL API)

Back | Level back

While installing, EULANDA® creates own functions, stored procedures and complex views in the SQL Server. These extensions are called API's (Application Programming Interface). EULANDA® intensively uses these APR's and provides them  among other to Solution Partners for developing own program extensions.

These API's can be used to call statistics, execute copy and booking transactions and other server side function.

One advantage is that changes on the database structure do not necessarily have to show. New extensions always are compatible to those already existing. New functions can be added at all times.

These interfaces are visible using either the EULANDA® SQL Designer or Microsoft's® Query Analyzer, thus providing all parameter information e.g. name, size, type, return values etc.

Important functions are documented additionally in this section.

To protect these functions, all API's are encrypted. Although this encryption is pretty simple, it should not be decrypted since this would among other infringe upon the copyright law.

Under certain circumstances the developers may provide you with parts of the source code. This source code when provided, is also protected by the copyright law and may be used for educational purposes only. This resource code is provided as to help solution partners or external developers  to find the right basic approach. Under no circumstances this code may be altered.

Hint

These views have to be rebuild after each database update. To do so, open the EULANDA® SQL Designer and right click on the name of the respective view. Choose "Show source code".

Change the line beginning with "CREATE VIEW ..  " in "ALTER VIEW .. " and subsequently press "CTRL+E" to execute the script. This will rebuild the view.

To avoid the manual rebuilding of  views, you may add their names to the the following node in the SQL Registry: „\ROOT\SYSTEM\EVENTS\DatabaseUpdates\“.
The EULANDA® Update Procedure will then work thru this list and rebuild these views automatically, in the sequence stated.
An example, with an inactive script and the respective description, can be found under the before mentioned location.