Valentina Studio Features In Depth

Create virtual links automatically in databases where you need the functionality of foreign keys without creating foreign keys.


There are times when design constraints exist that keep you from adding foreign keys to a database, but you need to work with such a database as if they exited. This is where Virtual Links helps. This feature makes no changes to your database, but instead uses REGEX to create links outside of the database and within Valentina Studio PRO.

Virtual Links distinquish themselves with dashed lines.


Set Up Virtual Links

You can set up Virtual Links with any supported relational database, including ValentinaDB.

Initiate Virtual Links for a selected database within Valentina Studio PRO Locate your database within Valentina Studio and using the context menu, initiate Virtual Links...

View Existing Virtual LInks

Virtual Links take the form of REGEX and make no modification to your database schema.

See the existing Virtual LInks for the selected database The Setup Virtual Links dialog appears. You can use the default Virtual Links available or, you can add a new, custom Virtual Link by clicking the +.

Testing Automatic Virtual LInks

You can test your new Virtual Links within Valentina Studio PRO.

Add Custom Virtual LInks and test them with the current database.

Select your new Virtual Link and click the Test button.

The Virtual Links generated appear in the Link Name List.

 Find out more about Virtual Links support in Valentina Studio PRO in the Virtual Links documentation on the Paradigma Software wiki.

STUDIO
5 Virtual Links Maximum

PRO
Unlimited Virtual Links