Importing Data and RecID

[Barry G. Sumpter]

Yes.

In Table Editor, for 2 tables linked by some LINK,
You will see 2 panes, Top and Bottom.

Select record in T1 pane by checkmark - first column - mouse click.
Then just do mouse click into check mark column of bottom pane to link
records.  Or unlink them.



That's the first I've read about this and the have never actually seen this
in action.
I'm just wondering if I've mucked up my data doing this unintentionally.

:P


PS the Link and Unlink commands are BinaryLinks





-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Wednesday, 2 September 2009 9:15 PM
To: valentina at lists.macserve.net
Subject: Re: Importing Data and RecID

On 9/2/09 11:01 AM, "Barry G. Sumpter" <barrysum at bigpond.net.au> wrote:

Hi Barry,

> LOL.  Good luck following that.

> With Primary keys and foreign keys you can see the value of the link.
> Primary key of State: Vic  you could see a foreign key of Vic
> Vic representing the state of Victoria
> 
> With Valentina just forget about using Primary and Foreign key.
> 
> Just use the RecID links instead.
> 
> A quick sql example is:
> Link Record (27) of tblPersonnel with Each Record (8) of tblStates
> 27 is the RecID of a Personnel record say Barry
> And 8 is the RecID of a States record in this case Victoria
> 
> There is an unlink as well and some pretty cool ways of defining the
Record
> clause.
> 
> Again don't waste your time with the other types of links.



******
> You can also setup multiple links say for a sales man who services
different
> states.
> 
> And as far as I know you have to use the additional LINK sql command to
link
> records.

This is required only for BinaryLinks.

For ObjectPtr - RecID pair, you just assign value into ObjectPtr field,
Exactly as with FK field in RDBMS.

 
> I'd like to know if there is a way of linking records using Valentina
> studio.

Yes.

In Table Editor, for 2 tables linked by some LINK,
You will see 2 panes, Top and Bottom.

Select record in T1 pane by checkmark - first column - mouse click.
Then just do mouse click into check mark column of bottom pane to link
records.  Or unlink them.

>      NOT the sql builder but the visual link window.

> i.e. check mark this record in that table
>             then check mark the records in the other table
>                now click "Link" button

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina