Why can't you use ROW_ID? You only need the unique ID for displaying the View Form. When selecting records from the View form save the GUID and work with that (just make sure that field is indexed on your table). When the table is overwritten there is no problem because you have never saved the temporary ROW_ID value to any other table.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Wednesday, August 20, 2008 3:13 PM To: [email protected] 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"
