Good question :) All I did was use "funtion|substr" which did work but should not have worked, I mean loaded the data but I am still getting warnings, stating data type conflict which I am working on. Thanks
--- En date de : Lun 26.10.09, jham36 <jha...@gmail.com> a écrit : De: jham36 <jha...@gmail.com> Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 15h47 What was the solution? On Oct 26, 9:43 am, Frex Popo <frexp...@yahoo.fr> wrote: > Thanks > > --- En date de : Lun 26.10.09, Frex Popo <frexp...@yahoo.fr> a écrit : > > De: Frex Popo <frexp...@yahoo.fr> > Objet: AIE 7.1 data conversion > À: arsl...@arslist.org > Date: Lundi 26 Octobre 2009, 14h20 > > Hello everyone, > > I have a table on a remote database (SQL Server 2005) whose data we are > reading to a local form in Remedy. One of the columns in the remote table is > of type INTEGER. The target column in the remedy form is of type character. I > need to be able to convert the INTEGER data to charaters within the AIE > mapping. I am trying to avoid adding a filter to the form to the do the > conversion. I looked at the AIE manual but did not see a function to do this. > I have perhaps missed something but the only one I could see is the SQL| and > the targetSQL| statements... > > Any thoughts? > > Many thanks > frex > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"