• Replies 4 replies
  • Subscribers 336 subscribers
  • Views 154 views
  • Users 0 members are here
Related

bulk insert into t_eaddress

Matt Winchester
$organization

I need to perform a bulk insert into t_eaddress. How does the eaddress_no field get populated? Is the AP_GET_NEXTID procedure called because I don't see a type for eaddress_no in T_NEXT_ID?

Thanks.

 

  • Former Member
    Former Member $organization
    The eaddress_no column in t_eaddress is populated via AP_GET_NEXTID.  It uses the row of type "AD" from T_NEXT_ID which is also used to populate the address_no column in t_address.
     
    Bob

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Winchester
    Sent: Wednesday, May 06, 2009 4:32 PM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] bulk insert into t_eaddress

    I need to perform a bulk insert into t_eaddress. How does the eaddress_no field get populated? Is the AP_GET_NEXTID procedure called because I don't see a type for eaddress_no in T_NEXT_ID?

    Thanks.

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization

    Matt,

    The T_EADDRESS table uses the 'AD' type, same as T_ADDRESS.  This is taken from WP_MAINTAIN_EADDRESS:

    -- get a new address id
    exec @eaddress_no = [dbo].ap_get_nextid_function @type = 'AD'

    Begin Transaction

    --insert into t_eaddress
    Insert [dbo].t_eaddress(
    eaddress_no,
    ...
    Values (@eaddress_no,
    ...

    Michael Reisman
    Director of Information Technology
    The New 42nd Street, Inc.
    mreisman@new42.org
    646.223.3069     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Winchester
    Sent: Wednesday, May 06, 2009 4:32 PM
    To: Michael Reisman
    Subject: [Tessitura Technical Forum] bulk insert into t_eaddress

    I need to perform a bulk insert into t_eaddress. How does the eaddress_no field get populated? Is the AP_GET_NEXTID procedure called because I don't see a type for eaddress_no in T_NEXT_ID?

    Thanks.

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!