• Replies 9 replies
  • Subscribers 337 subscribers
  • Views 38 views
  • Users 0 members are here
Related

v.11: constituency_no in TX_CONST_CUST

Frances O'Connell
$organization

Hi all,

Can anyone tell me how the constituency_no column in TX_CONST_CUST is calculated?  i am trying to update a procedure that updates our subscription constituency and want to make sure i have the right value plugged in there.

thanks!

Frannie

Parents
  • $organization

    Hi Frances,

     

    Constituency_no is an identity column, so the number is determined by SQL Server automatically. It kind of acts as a unique identifier for each row in this table, although in this case, it isn’t the primary key of the table. So there is no need to include it when inserting rows into this table.

     

    Thanks,

    David

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Tuesday, March 26, 2013 1:46 PM
    To: David Frederick
    Subject: Re: [Tessitura Technical Forum] v.11: constituency_no in TX_CONST_CUST

     

    Actually I think I just got the procedure to run without plugging anything into that column.  Is is calculated elsewhere?

    Thanks ---

    Frannie

    From: Frances O'Connell <bounce-francesoconnell5073@tessituranetwork.com>
    Sent: 3/26/2013 3:20:54 PM

    Hi all,

    Can anyone tell me how the constituency_no column in TX_CONST_CUST is calculated?  i am trying to update a procedure that updates our subscription constituency and want to make sure i have the right value plugged in there.

    thanks!

    Frannie




    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!

Reply
  • $organization

    Hi Frances,

     

    Constituency_no is an identity column, so the number is determined by SQL Server automatically. It kind of acts as a unique identifier for each row in this table, although in this case, it isn’t the primary key of the table. So there is no need to include it when inserting rows into this table.

     

    Thanks,

    David

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Tuesday, March 26, 2013 1:46 PM
    To: David Frederick
    Subject: Re: [Tessitura Technical Forum] v.11: constituency_no in TX_CONST_CUST

     

    Actually I think I just got the procedure to run without plugging anything into that column.  Is is calculated elsewhere?

    Thanks ---

    Frannie

    From: Frances O'Connell <bounce-francesoconnell5073@tessituranetwork.com>
    Sent: 3/26/2013 3:20:54 PM

    Hi all,

    Can anyone tell me how the constituency_no column in TX_CONST_CUST is calculated?  i am trying to update a procedure that updates our subscription constituency and want to make sure i have the right value plugged in there.

    thanks!

    Frannie




    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!

Children
No Data