Thanks --- En date de : Lun 26.10.09, Frex Popo <[email protected]> a écrit :
De: Frex Popo <[email protected]> Objet: AIE 7.1 data conversion À: [email protected] 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 at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

