SQL Commands for creating Binary Links from Legacy Link values?

[Barry G. Sumpter]

Hi John,

Not a problem at all.

Another scenario is where you've created a binary link 
and simply deleted it.  Intentionally or not.

Or it gets corrupted as you mentioned.
And where a subsequent clone can't fix it.

You are correct you would be stuck unless you can recover from 
a backup.

Another reason I am uncomfortable is the presentation layer where the links
are almost hidden.  And I have to know where to go and look for them.

All the best,
     Barry G. Sumpter 



-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Sims, John
(CDC/CCHP/NCBDDD) (CTR)
Sent: Saturday, 14 July 2007 5:18 AM
To: Valentina Developers
Subject: RE: SQL Commands for creating Binary Links from Legacy Link values?

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Barry G. Sumpter
> Sent: Friday, July 13, 2007 3:02 PM
> To: 'Valentina Developers'
> Subject: SQL Commands for creating Binary Links from Legacy 
> Link values?
> 
> Hi All,
> 
> I've loaded T1 table with legacy data
> T1.ShopNo, T1.ShopName, T1.ShopState, T1.RecID (Created by Valentina)
> 
> I've ALSO loaded T2 table with legacy data T2.ShopNo, 
> T2.ReceiptNo, T2.ReceiptItemNo, T2.RecID (Created by Valentina)
> 
> There are currently NO Valentina Key links as yet.
> 
> There is only the (logical) relationship via the ShopNo 
> Text/String Value.  
> i.e.  "0001", "0002" etc
> 
> There are 10,000 Shops(T1) and 100,000,000(T2) Receipts i.e. 
> too large to update by hand
> 
> Is there a methodology to get the Valentina SQL engine, i.e. 
> via SQL statements, to do all the Binary Link work for me?
> 
> So far I can index both ShopNo fields and Build a Left out 
> Join Select statement.
> 
> But how do I turn this into a Binary Link via SQL Statements?
> i.e. Not just create a physical link using the "CREATE BINARY 
> LINK" command.
>      But actually filling the Link records with RecID link values.
>      I'm hoping I don't have to write code to loop thru 
> 100,000,000 records.
> 
> 
> 
> Thanks,
>      Barry G. Sumpter

Hi Barry (and others on the list).

Barry, please allow my to apologize for sort of hi-jacking your thread
but your question brings to light a concern I have about Binary Links
that would probably do both of us a lot of good to have addressed.

My concern is such:

If I have 2 tables, T1 and T2, and I link the corresponding data between
the 2 tables (as you, Barry, are wishing to do), then remove the
ObjectPtr field from T2 that points to T1, what happens if my binary
link becomes corrupted?  With no remaining reference in T2 that tells me
which T1 record it is attached to, how do I get them re-attached?

It is impossible for binary links to become corrupted? (I can't imagine
how this would be possible, but I am nowhere near Ruslan's equal).

Basically, I'm concerned about data integrity recovery.  Would I have to
just go to a backup to restore the values?

Again, Barry, sorry for the hi-jack, but your question finally got me to
solidify my concerns.

-John




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