Adding Custom Database Functions or Fields

Tony Coffman -

Adding Custom Database Functions or Fields

A custom database function or field is special SQL syntax that your database allows within a SQL select statement.  This is commonly used for Mathematical Computations, Concatenations, Substrings etc.

To add a Custom Formula or Function to a View, Right Click on the Report Fields area on the Tables and Fields tab.

Next, type in your Custom Field or Function in the box below and Click OK.

When the Custom Field or Function is added to your View it will have the @DBF prefix in front of the item.  To edit the Custom Field or Function, simply double click on it.

Here are some examples of what you can do with VDM's Custom Field or Function option:

Cache Database Functions

Microsoft SQL Functions

Have more questions? Submit a request

Comments

Powered by Zendesk