Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (3)

Resolved Binary link on same table

  1. Stephan Fellner
    Stephan Fellner
  2. as Valentina DB Server
  3. Saturday, March 11 2017, 04:10 PM
  4.  Subscribe via email
Hi,

wondering if it's possible to link the same table with binary link. The idea is a table with tasks and sometimes a task can be a subtask of a task in same table. Is a binary link an possible option for this relation? it's not urgent, just a thought.

Thx.
  1. Valentina DB ADK
  2. VSQL
  3. DOCS
  4. FIXED
Comment
There are no comments made yet.
Responses (3)
Ruslan Zasukhin
Ruslan Zasukhin Accepted Answer
Hi Stephan,

Thank you for point,
going to fix error in wiki.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Stephan Fellner
Stephan Fellner Accepted Answer
And about my question... yes... it works...

CREATE BINARY LINK lnk_task_task ON TABLES (task, task) AS ONE to MANY;
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
Stephan Fellner
Stephan Fellner Accepted Answer
Found an error in your documentation:

CREATE BINARY LINK link_Phone_Person ON (Person, Phone) AS MANY TO MANY;

Should be

CREATE BINARY LINK link_Phone_Person ON TABLES (Person, Phone) AS MANY TO MANY;
References
  1. http://valentina-db.com/docs/dokuwiki/v7/doku.php?id=valentina:vcomponents:vkernel:vlink:binarylink
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories