Last time in A Place for Everything: Part 1, I introduced a script for adding an series of numeric units to a site/subsite in the , so in this follow-up, I’ll introduce a script that can add units that are marked by alphanumeric codes.
Category :SQL Scripting
A Place for Everything: Part 1
My mother has always been a proponent of finding a place for everything, and putting everything in its place. Before you can use the sub-module to record where everything is placed, you must first use the to create the places in which everything can be placed. While easy to use, the is not always efficient …
Text Entries in a Single View
If you’re anything like me, you probably have a stack of SQL views just to simplify report writing. Since text entries are so pervasive to TMS’s operation, I find that I am constantly making use of them in various Crystal Reports. Here’s a time-saver: a SQL view that combines the four tables used for controlling …
Avoiding an “Invalid Property Array Index” Error
In 5 (Often Forgotten) Productivity Tools I mentioned that List Views are a great way to review data. However, the TMS interface expects the SQL view to return only one row per selected record. If your table joins create more than one row per record, then TMS will truncate the SQL view results. If your …
Statistics at a Glance Report
As corporate philosophy continues to integrate itself into museum administration, greater emphasis is placed on the quantification of staff activities. Thus, I often find myself in the role not only of Database Administrator, but also of bean counter. This tutorial outlines how to create a Crystal Report that provides statistics drawn from TMS.