Re: Attachment $NULL$ vs Empty

2008-08-26 Thread Elinore AR
BUMP!

Anyone has any input?

TIA.

Elinore

On Aug 8, 4:30 pm, Elinore AR [EMAIL PROTECTED] wrote:
 hi all, i am having an issue with attachments. in the HPD:WorkLog form
 there is a field called Files where the number ofattachmentis
 counted for that particular worklog. i am getting a count of 3
 (instead of the actual number of attachments that are in that worklog)
 every time my filter (from another form) runs to push attachments to
 the HPD:WorkLog form. my filter simply pushes my $Attachmentx
 $ (from a temp form) to the field z2AF Work Log0x. (in HPD:WorkLog)
 is there a way to set the push statement to test the field first (for !
 = $NULL$ and !=  ) before actually pushing it? i thought of
 individually pushing each of the attachments one by one (first push
 will create the worklog, the remaining 3 push actions to push the !=
 $NULL$ and !=   attachments) but i couldn't use the function $LASTID
 $ (to retrieve the last inserted Request ID and use it to insert 
 theattachmentto it) since it retrieves a system Request ID with prefix
 on it (WLG..)

 does someone have any better idea?

 TIA.

 Elinore

 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Attachment $NULL$ vs Empty

2008-08-08 Thread Elinore AR
hi all, i am having an issue with attachments. in the HPD:WorkLog form
there is a field called Files where the number of attachment is
counted for that particular worklog. i am getting a count of 3
(instead of the actual number of attachments that are in that worklog)
every time my filter (from another form) runs to push attachments to
the HPD:WorkLog form. my filter simply pushes my $Attachment x
$ (from a temp form) to the field z2AF Work Log0x. (in HPD:WorkLog)
is there a way to set the push statement to test the field first (for !
= $NULL$ and !=  ) before actually pushing it? i thought of
individually pushing each of the attachments one by one (first push
will create the worklog, the remaining 3 push actions to push the !=
$NULL$ and !=   attachments) but i couldn't use the function $LASTID
$ (to retrieve the last inserted Request ID and use it to insert the
attachment to it) since it retrieves a system Request ID with prefix
on it (WLG..)

does someone have any better idea?

TIA.

Elinore

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are