You are welcome.. Joe
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of brooksm Sent: Thursday, November 01, 2007 4:40 PM To: [email protected] Subject: Re: Create view form from SQL Server dblink That did it. Thanks Joe! Brooks Joe D'Souza wrote: > > Brooks, > > Try creating a VARCHAR2 field of length less than 15 but greater than 5. Use > this field to map it to the Request ID, and left pad it with 0's so that it > will sort the way it sorts in ARS regular forms. > > Cheers > > Joe D'Souza > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] Behalf Of brooksm > Sent: Friday, October 26, 2007 6:45 PM > To: [email protected] > Subject: Create view form from SQL Server dblink > > > Good afternoon listers- > On ARSystem 7.0 SQL Server 2005, i've created a dblink to another SQL Server > 2000 table. I've successfully created a view form off of this database link > and used the ROW_ID field as the key field for the new view form. The > problem I'm running into is that this key field is an integer datatype so > when I sort by this field in the form, it sorts like this: > 10 > 1003 > 1011 > 102 > 1038 > 104 > > How can I get this corrected? I know I'll probably need to recreate this > database view and change the key field datatype, but I tried VARCHAR, but > then cannot use this field as the key field when trying to create the view > form in Remedy. > > Thanks > Brooks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.17/1103 - Release Date: 11/1/2007 6:01 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
