Yes, ROWNUM is another pseudo column besides ROWID (which is longer than 15 characters anyways).. Joe
----- Original Message ---- From: "Moore, Christopher Allen" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, August 20, 2008 4:13:13 PM Subject: Re: Another view form question... Drew- I figured I'd have to create a new column, but how can I populate it? Is there a way in SQL to generate a GUID for each entry? Forgive my ignorance here; I don't know a lot on the SQL side. Thanks, Chris -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Wednesday, August 20, 2008 3:09 PM To: [email protected] Subject: Re: Another view form question... 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"
