Configuring the Multi Query Splitter for Advanced Queries in VDM

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.

Article Goal

Learn how to configure the Multi Query Splitter value in VDM, allowing you to control how Advanced Queries are separated when executing multiple SQL statements.

What Is the Multi-Query Splitter?

The Multi Query Splitter defines the character or value used to split multiple queries written within a single Advanced Query block in VDM.

Note: If the default splitter character (e.g., ;;) appears in your SQL logic or data, it may cause unintended query splitting. Changing the splitter prevents this conflict.

Why Change the Multi-Query Splitter?

Some SQL functions or values may contain characters (like semicolons, pipes, or tildes) that interfere with the default query splitting behavior. By setting a custom splitter, you can avoid syntax issues and ensure the correct query logic is executed.

Tip: Choose a splitter that is unlikely to appear in your query syntax—such as ||| or a unique tag like --SPLIT--.

Video Tutorial:

Steps to Change the Multi-Query Splitter

Step 1: Open VDM

Launch VDM from your system.

Step 2: Open or Create a View with Advanced Query

Open an existing view that uses Advanced Query, or create a new one.

Step 3: Access View Options

Click the View Options tab located in the top ribbon bar.

Step 4: Set the Multi-Query Splitter

Click the Multi Query Splitter button in the View Options toolbar.

Enter the custom character or value you want to use as the splitter.

This value will replace the default and be used to separate each query block in execution.

Step 5: Update Your Advanced Query

In your Advanced Query, use the new splitter wherever you want to separate queries.

Example:
If you set the splitter as |||, then your query should look like this:

Step 6: Run and Validate

• Click Run View

• Confirm that all queries are executing correctly and split as intended based on the new delimiter.

Article Summary

The Multi-Query Splitter in VDM allows you to define how multiple queries are separated within an Advanced Query block. By customizing this value, you can avoid syntax issues caused by conflicting characters and maintain precise control over how your view processes multiple SQL statements.

Use Case: You're using semicolons in your SQL logic for other purposes. By switching the splitter to --SPLIT--, you ensure only intended query blocks are separated and executed.