Re: Weird Mid-Tier Problem

[Steinigans-Hillemann, Joerg]

**

I've had the same problem. And the answer to your (our) problem is: When attaching a file through Mid-Tier and copying it to a character field to get the filename, you already have only the filename without any path information. This behavior is different to the WUT.

So you just have to turn off your ALs for the Mid-Tier ($CLIENT-TYPE$ = 9).

 

Joerg

 

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of L. J. Head
Sent: Friday, April 28, 2006 7:20 PM
To: arslist@ARSLIST.ORG
Subject: Weird Mid-Tier Problem

**

Mid-Tier 6.3 Patch 14

 

First off...is there a better way, secondly...does anyone know why it's doing this

 

I am attaching a file to a record...and want to store the file name in a field.  Upon the file being attached I do a setfield of the attachment field to a character field.  This gives me for example c:\autoexec.bat.  I don't care about the path to the file...I just want the file name, so I perform this set of setfields as many times as necessary to remove all of the \'s from the file name

 

Setup:

2 Fields:

File Name (Character)

zTmpInt (Int)

 

1 Active link that fires as long as zTmpInt >= 0 (0 is it's default value)

 

<ACTL> Checking AL (5)
<ACTL>     -> Passed qualification -- perform if actions
<ACTL>          0: Set Fields
<ACTL>             File Name (536870916) = :\AUTOEXEC.BAT
<ACTL>          1: Set Fields
<ACTL>             zTmpInt (536870917) = 1
<ACTL>          2: Goto EO
<ACTL>            EO from action -- 5
<ACTL> Checking AL (5)
<ACTL>     -> Passed qualification -- perform if actions
<ACTL>          0: Set Fields
<ACTL>             File Name (536870916) = AUTOEXEC.BAT
<ACTL>          1: Set Fields
<ACTL>             zTmpInt (536870917) = -1
<ACTL>          2: Goto EO
<ACTL>            EO from action -- 5
<ACTL> Checking AL (5)
<ACTL>     -> Failed qualification

 

This works great and very fast on the native client....if I however run this same workflow through Mid-Tier my file name is set to 'UTOEXEC.BAT'...it always truncates the first character of the actual file name....your assistance is apprecated.  I'm looking into upgrading to patch 16...but don't think I should need to...

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___