Look into using a sequence via a trigger to populate the column. Axton Grams
On Wed, Aug 20, 2008 at 4:13 PM, Moore, Christopher Allen <[EMAIL PROTECTED]> wrote: > 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" >> > > _______________________________________________________________________________ > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
