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.11/1094 - Release Date: > 10/26/2007 > 8:50 AM > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/Create-view-form-from-SQL-Server-dblink-tf4700172.html#a13536993 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
