Hi,Can you point me to a reference on functionality and syntax for this column?Many thanks!Chris
_______________________________________
Chris Wallingford | T-Stats Product Manager | JCA 924 Quinnipiac Ave. #3 | New Haven, CT 06513Phone: 203-468-9123 | Fax: 203-468-1204
chris.wallingford@jcainc.com www.jcainc.com
Helping Non-Profits Work Smarter
From the doc,
A PowerBuilder expression that validates the data being entered in the field. This will prevent a user from saving a new row or saving an updated row if the data does not produce a true statement.
Marty Jones
Database Administrator
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469 | F 402.345.0222
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Wallingford Sent: Friday, July 16, 2010 11:37 AM To: Martin A. Jones Subject: [Tessitura Technical Forum] T_REFERENCE_TABLES.[col_valid]
Hi, Can you point me to a reference on functionality and syntax for this column? Many thanks! Chris
Chris Wallingford | T-Stats Product Manager | JCA 924 Quinnipiac Ave. #3 | New Haven, CT 06513 Phone: 203-468-9123 | Fax: 203-468-1204
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!
Chris,
That column is a powerbuilder expression that validates the data being entered in the field. This will prevent a user from saving a new row or saving an updated row if the data does not produce a true statement. –According to the documentation from Tessitura.
This is what syntax I see in the column for TR_batch_type, cntl_ind : POS('YN', gettext()) > 0
This seems to be the syntax for almost all of the 67 rows that have a value in that column for our table. Other syntaxes include: POS('YND', gettext()) > 0; POS('FECOA', gettext()) > 0; IsNull(gettext()) OR (long(gettext()) >= 1 and long(gettext()) <= 10) ; POS('1234', gettext()) > 0; POS('1/2/3/4/5/6/7/8/9/10/11/12', gettext()) > 0
Hope this helps you!
Thanks and have a great day!
Naomi Williams
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Wallingford Sent: Friday, July 16, 2010 11:37 AM To: Naomi Williams Subject: [Tessitura Technical Forum] T_REFERENCE_TABLES.[col_valid]