Tables and Fields - @DBF Storage

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

The @DBF storage in VDM allows you to save your custom database fields or functions locally, so you can reuse them in any view.

Video Tutorial: 

Not Yet Available.

How to Use @DBF Storage

1. Open VDM: Launch the VDM application.

2. Open or Create a View: Start a new view or open an existing one, then begin adding your fields.

3. Expand the @DBF Table: Find the @DBF table in the Tables and Fields section and expand it to see your saved functions.

💡 Note:
If you don’t see anything listed, that means you haven’t saved any database functions yet.
To save one:

• Click Save Locally when you're adding or editing a database function.

• If you are adding / updating to a function, clicking Add / Update only changes it in that view.
  To update your saved (local) version, click Save Locally again.

Example: Creating a "Today" Function in SQL

You can create a simple function to return today’s date like this:

• GETDATE() retrieves the current date.

Once added, save it locally using the Save Locally button so it appears under the @DBF table for reuse later.

4. Add Functions from @DBF to Your View: To use a saved function, double-click it or drag it into your field list.

5. Run the View: Click Run to see your results and confirm everything is working as expected.

✅ Article Summary

The @DBF storage feature makes working in VDM more efficient by letting you:

• Save time by reusing database functions.

• Keep your views consistent.

• Easily access your saved logic in any project.