SQL Select with Binary Link

[Ruslan Zasukhin]

On 5/21/08 8:55 AM, "Chris McConnell" <chris at mc-data.com> wrote:

> OK so here is a total process if I want to use binary pointerS
> 
>  
> 
> 1)       I insert a new record into the customer table
> 
> 2)       I retreive the last insert record id for the customer table
> (cust.recId)
> 
> 3)       I insert a phone number record
> 
> 4)       I retreive the last insert record id for the phone table (ph.recId)
> 
> 5)       I then insert into link link_name VALUES( cust.recId , ph.recId)

Well, may be steps 2 and 4 can be integrated into 5

    insert into link link_name VALUES( lastreid(cust) , lastreid(ph) )


-- 
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]