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.11/1094 - Release Date: 10/26/2007 8:50 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
