TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Mime-Version:
1.0
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
From:
Amy Noel <[log in to unmask]>
Date:
Mon, 25 Nov 2002 16:02:14 -0800
Content-Transfer-Encoding:
quoted-printable
Content-Type:
text/plain; charset=US-ASCII
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Parts/Attachments:
text/plain (11 lines)
Hello fellow TMS Users, 
 
I'm wondering if we are one of a few TMS users for whom some query functions do not work.  Particualry,  "and not" queries do not work on large number of records and CLOB fields, like object packages.  This means that end users (who do not use SQL worksheet) cannot eliminate an Object Package from a larger selection or query "and not *" on some fields.  
 
Is there anyone who has this problem and found a way around it within the application?  I don't see our average TMS user learning SQL.  This is becoming more of an issue for us as our number of in-house staff learn and use TMS continues to grow. 
 
Thanks, 
Amy Noel
CIS Application Manager
The J. Paul Getty Museum 

ATOM RSS1 RSS2