list view Archives » Chad Petrovay

Select Top 3 * From [Uses for Select]: Part 2

In Part 1, we examined how to use the SELECT statement in SQL to create a SQL View that can be used in Crystal Reports for reporting. There are two additional uses for the SELECT statement, which make learning its syntax an invaluable tool for database administrators. (more…)

May 6, 2014

Accessioning Clean-up: Part 1

Whether you are launching a data cleanup project or simply want to verify that standards are being followed, there are times you want to be able to quickly and easily manage your data. In 5 (Often Forgotten) Productivity Tools I mentioned that List Views are a great way to review data. In the first part of this tutorial, we’ll design a List Views to help with a project to clean-up accessioning information. (more…)

August 18, 2011

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 table join excludes records, then TMS will repeat rows in the SQL view results. Either way, you get an Invalid property array index error and confused end-users. Here’s how to avoid it altogether.

(more…)

February 3, 2010

5 (Often Forgotten) Productivity Tools in TMS

Schools are closing, and temperatures are rising: Summer is arriving. As end-users are preparing to leave for the traditional family vacation, here are five (often forgotten) tools to help them work smarter.

(more…)

May 26, 2009

Tag: list view

Select Top 3 * From [Uses for Select]: Part 2

Accessioning Clean-up: Part 1

Avoiding an “Invalid Property Array Index” Error

5 (Often Forgotten) Productivity Tools in TMS