You've got to have that key field and it must be in the format that is
in the documentation. Create a new column if you don't have a suitable
one already.
Drew
On Wed, 20 Aug 2008, Moore, Christopher Allen wrote:
I have a problem creating a view form- thanks to Joe's advice I am now able to
see all the columns. My problem now is designating a key field. The only
column which is guaranteed to be unique is a GUID passed from the external data
source, but it's too long- 25 characters.
Has anyone else run into this problem, and how did you get around it? I can't
use ROW_ID because this table will be overwritten monthly. I know just enough
SQL to be dangerous...is there some sort of way to add a column and ensure it's
unique via SQL?
ITSM 7.0.1 p6
SQL 2005 SP2
Win 2003 svr
I appreciate any advice!
Chris
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"