Multi-record insert/append using sub-query list - and Binary Links

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: Thursday, July 19, 2007 10:35 AM
> To: valentina at lists.macserve.net
> Subject: Re: Multi-record insert/append using sub-query list 
> - and Binary Links
> 
> On 19/7/07 4:52 PM, "Sims, John (CDC/CCHP/NCBDDD) (CTR)" 
> <ayu8 at CDC.GOV>
> wrote:
> 
> Hi John,
> 
> > Hi Ruslan and Barry,
> > 
> > One word of caution for this solution.  I believe it would 
> fail in a 
> > multi-user environment.  If 2 users add records at the same 
> time, you 
> > don't know what you are going to get linked to what.
> 
> Its possible make little more complex for this.
> Use not BOOL but INTEGER. Each user use own number.
> 
> And have table that keep incremental counter which each user 
> obtain at first.
> 
>  
> > Perhaps we should re-open my request for SQLExecute to 
> return an array 
> > of affected RecIDs ;-)
> 
> > Then, perhaps you (Ruslan) could add to Valentina a 
> > LinkRecords(PrimaryRecID as Ulong, RecordsToLink() as Ulong) option.
> > Then to link the records, you pass your returned array of affected 
> > RecIDs along with the Record you want to link to.
> > 
> > Something like that???
> 
> :-)
> 
> Right, today reading Barry question, I have to think:
> 
> * it is somehow stupid INSERT 100 records, e.g. Into table of 
> million records, then use again
> 
>         SELECT      .... WHERE some flag
> 
> To locate these 100 records.
> 
> Much more wise will be to get ability to get this 
> SET/ARRAY/LIST of records on hands and later use it again when needed.
> 
> I.e. This bring  us to idea of CONTAINERS for Valentina engine.
> 
> 
> --
> 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]

Hi Ruslan,

It will be interesting to see where you go with this idea.  I think it
could be a really good one and really add some more power to Valentina.
Binary Links are such a fantastic addition to the world of databases!
The easier and more powerful you can make them, the better.

Keep up the good work!

-John