Change Order Date

Thanks for the confirmation that it will be OK, Brian.  Appreciate it.

We generally do this every year, as orders have to be edited for some reason or other internally, and we don’t want the order date to reflect this edit by staff.  Just update t_order.

BRIAN WILBUR GRUNDSTROM | Database Administrator
SHAKESPEARE THEATRE COMPANY
Recipient of the 2012 Regional Theatre Tony Award®
516 Eighth Street, SE | Washington, DC 20003-2834
p 202.547.3230 ext. 2216 | c 917.952.7957
bwg@shakespearetheatre.org
www.shakespearetheatre.org
www.brianwilbur.com
2016|2017 SEASON •• Shakespeare’s ROMEO & JULIET • Norman, Simon & Burnett’s THE SECRET GARDEN • Bartlett’s KING CHARLES III • Elevator Repair Service’s THE SELECT (THE SUN ALSO RISES) • Shakespeare’s MACBETH • Ives’s THE SCHOOL FOR LIES

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dot Krebs
Sent: Thursday, February 02, 2017 2:45 PM
To: Brian W. Grundstrom
Subject: [Tessitura Technical Forum] Change Order Date

Deferring to those with more knowledge than I...

Let's say we had to modify a rollover order and in doing so, had to enter a source & an order date to complete the sale.

In SQL, is there any harm updating the roll-over order date and source to a null value so we can have the correct speed of sale information when the customer actually orders or is that a big no-no? 

It looked good in Test, but I may be missing something.

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!

Thanks for the confirmation that it will be OK, Brian.  Appreciate it.

We generally do this every year, as orders have to be edited for some reason or other internally, and we don’t want the order date to reflect this edit by staff.  Just update t_order.

BRIAN WILBUR GRUNDSTROM | Database Administrator
SHAKESPEARE THEATRE COMPANY
Recipient of the 2012 Regional Theatre Tony Award®
516 Eighth Street, SE | Washington, DC 20003-2834
p 202.547.3230 ext. 2216 | c 917.952.7957
bwg@shakespearetheatre.org
www.shakespearetheatre.org
www.brianwilbur.com
2016|2017 SEASON •• Shakespeare’s ROMEO & JULIET • Norman, Simon & Burnett’s THE SECRET GARDEN • Bartlett’s KING CHARLES III • Elevator Repair Service’s THE SELECT (THE SUN ALSO RISES) • Shakespeare’s MACBETH • Ives’s THE SCHOOL FOR LIES

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dot Krebs
Sent: Thursday, February 02, 2017 2:45 PM
To: Brian W. Grundstrom
Subject: [Tessitura Technical Forum] Change Order Date

Deferring to those with more knowledge than I...

Let's say we had to modify a rollover order and in doing so, had to enter a source & an order date to complete the sale.

In SQL, is there any harm updating the roll-over order date and source to a null value so we can have the correct speed of sale information when the customer actually orders or is that a big no-no? 

It looked good in Test, but I may be missing something.

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!