• 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

    Thanks for the clarification.  The constituency_no column is set as an identity column and the value will be populated automatically.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Tuesday, March 26, 2013 4:22 PM
    To: Guy, Jackie
    Subject: RE: [Tessitura Technical Forum] v.11: constituency_no in TX_CONST_CUST

     

    Hi Beth and Jackie - 

    Thanks for your responses.  I was not very clear--in our db the sub constituency is updated by a custom SP (as opposed to being a part of UPDATE_SUB_HIST).  I've got that part of it - it's just that in this proc we add or update the row in TX_CONST_CUST for the customer/constituency in question, and I noticed that TX_CONST_CUST has an additional column in v.11 called constituency_no (separate from the constituency ID, set in TR_CONSTITUENCY.  Note that we are not actually Live in v.11, but I was trying to test my udpated proc in there - and hit against this.

    I was wondering if I needed to insert a value into the constituency_no column in the UPDATE command in the SP.  But I didn't in my test and it seems to have calculated itself?  In which case I will not worry...

    Thank you--


    Frannie

    From: Jackie Guy <bounce-jacquelineguy8869@tessituranetwork.com>
    Sent: 3/26/2013 3:54:38 PM

    The constituency column of the TX_CONST_CUST table is a foreign key referenced from id column of TR_CONSTITUENCY.

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Tuesday, March 26, 2013 3:42 PM
    To: Guy, Jackie
    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!




    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

    Thanks for the clarification.  The constituency_no column is set as an identity column and the value will be populated automatically.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Tuesday, March 26, 2013 4:22 PM
    To: Guy, Jackie
    Subject: RE: [Tessitura Technical Forum] v.11: constituency_no in TX_CONST_CUST

     

    Hi Beth and Jackie - 

    Thanks for your responses.  I was not very clear--in our db the sub constituency is updated by a custom SP (as opposed to being a part of UPDATE_SUB_HIST).  I've got that part of it - it's just that in this proc we add or update the row in TX_CONST_CUST for the customer/constituency in question, and I noticed that TX_CONST_CUST has an additional column in v.11 called constituency_no (separate from the constituency ID, set in TR_CONSTITUENCY.  Note that we are not actually Live in v.11, but I was trying to test my udpated proc in there - and hit against this.

    I was wondering if I needed to insert a value into the constituency_no column in the UPDATE command in the SP.  But I didn't in my test and it seems to have calculated itself?  In which case I will not worry...

    Thank you--


    Frannie

    From: Jackie Guy <bounce-jacquelineguy8869@tessituranetwork.com>
    Sent: 3/26/2013 3:54:38 PM

    The constituency column of the TX_CONST_CUST table is a foreign key referenced from id column of TR_CONSTITUENCY.

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Tuesday, March 26, 2013 3:42 PM
    To: Guy, Jackie
    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!




    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