If you want the table field to have the name of the attachment do the
following:
On your attachment form have a Character field to hold the attachment
name (i.e. Short Description).
Do a Set Fields action to set the Character field = the Attachment
field. This will put the following formatted text into your character
field.
FileSize;CompressedSize;FileName ( i.e. 60921;4333;C:\Temp\My
Picture File Name.jpg )
You then have to do 2 STRSTR/SUBSTR passes ( 4 Set Field actions) on the
text to drop off the 2 file size values.
zTempInteger = STRSTR ($Short Description$, ";") + 1
Short Description = SUBSTR ($Short Description$, $zTempInteger$)
zTempInteger = STRSTR ($Short Description$, ";") + 1
Short Description = SUBSTR ($Short Description$, $zTempInteger$)
Bingo, you have your file name.
Fred
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Thursday, May 15, 2008 2:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to open an attachment in a child form record from a
tablefield on the parent record?
**
Really quite simple once you think about it....you already have the
attachment form with its attachment pool and field, you already have the
table field on your main form showing you all of the records, that's 90%
of the way. Now you need an attachment pool on your main form, and a
display only attachment field. Disable table drill down on the table
field, create an AL that fires on dbl click of the table row that does a
setfield from the attachment form to your main form into the display
only attachment field. Then have a second AL that fires on dbl click
that opens the attachment from the main form. This will give them the
ability to open the attachments stored in your attachment form. Let me
know if you get stuck on anything I have said...I've implemented this a
number of times with great success.
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Thursday, May 15, 2008 12:38 PM
To: arslist@ARSLIST.ORG
Subject: How to open an attachment in a child form record from a
tablefield on the parent record?
**
Hi everyone,
We have a need to store many .jpg files that we will periodically
access. We want to access them from our Site form but to store them on
this form would probably not be efficient. There will be approximately
10 .jpg files per Site so I thought a child form would be a better
storage area.
Initially my thought was to simply use a table field on the Site form
displaying the necessary fields from the child form. On the child form
there would be an attachment pool. There would be only one attachment
per child record because other identifying information goes with each
.jpg file. So in the table field we'd see the attachment file,
description name, and view name for each child record associated with
that Site. Ten child records, ten rows on the table field, ten .jpgs.
Problem is, you cannot select the attachment field (filename) in the
table field. Yes, we can double click on the row and access the .jpg
file directly on the child record but of course that is not what they
would prefer. They want to see the .jpg filenames, double click on them
and whalaa they are open directly from the Site record. I thought it
sounded reasonable until I'm playing around with the concept right now.
I've looked through the documentation for some way to display this other
than a table field and if it's there I'm missing it. Any suggestions on
how I can accomplish this?
ARS v7.0.1P3 (server, admin, user)
Oracle 10g
Windows 2003
I appreciate your help and ideas. Let me know what other information I
could provide.
Thanks,
Susan
Susan Palmer
ShopperTrak
200 W Monroe St 11th Floor
Chicago, IL 60606
312-529-5325
[EMAIL PROTECTED]
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
