While mapping values in AIE if you choose the SQL option, I hit a 255 character limit. It looks like the length of the SQL string that contains the SQL| keyword (4 characters) plus the length of the actual SQL cannot exceed 255 characters thus limiting the length of the actual SQL statement to 251 characters..
Has anyone had to write an SQL statement larger than this? If so what are the AIE related forms that need to be altered to increase the size of the field that holds this value? I know I can find it out by workflow/filter logging, but I may need a ready tip if anyone has one as I do not really have too much time to find this out myself.. Cheers Joe D'Souza No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1333 - Release Date: 3/18/2008 8:10 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
