Re: Question: $LASTID$

2008-06-16 Thread T. Dee
THANKS

Ty


On 6/14/08, Arthur Johnson [EMAIL PROTECTED] wrote:
 **
 If you're at 6.3 or later, try this:
 Create a character field with ID - 179(named say UniqueGUID) on the Calling
 form
 At the Push Field that creates the record in the Called form, push this GUID
 field value as well, to a character field(e.g. UniqueID) on the Called form.
 Then in the Filter where you are trying to use $LASTID$, create a Set Field
 Action instead, with qualification - 'UniqueID' = $UniqueGUID$
 You should be able to get the record that was created with the above Push
 Field
 Hope this helps.
 I have used this at the Active Link level as well.


 On 6/13/08, T. Dee [EMAIL PROTECTED] wrote:
  I'm trying to use $LASTID$, but i'm not getting the $LASTID$.
 
  I thought I read some where that you can now specify the Form that you
  want the LastID from - is this true - or am I just wishing :-)
 
  THANKS!
 
  Happy Friday!
 
 
 ___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
  Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 

 __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


Re: Question: $LASTID$

2008-06-14 Thread Arthur Johnson
If you're at 6.3 or later, try this:

   1. Create a character field with ID - 179(named say UniqueGUID) on the
   Calling form
   2. At the Push Field that creates the record in the Called form, push
   this GUID field value as well, to a character field(e.g. UniqueID) on the
   Called form.
   3. Then in the Filter where you are trying to use $LASTID$, create a Set
   Field Action instead, with qualification - 'UniqueID' = $UniqueGUID$

You should be able to get the record that was created with the above Push
Field
Hope this helps.
I have used this at the Active Link level as well.

On 6/13/08, T. Dee [EMAIL PROTECTED] wrote:
 I'm trying to use $LASTID$, but i'm not getting the $LASTID$.

 I thought I read some where that you can now specify the Form that you
 want the LastID from - is this true - or am I just wishing :-)

 THANKS!

 Happy Friday!


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


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


Re: Question: $LASTID$

2008-06-14 Thread Brian Gillock
Here's a quick and dirty version...

Create a filter that performs a Set Fields action...From the Read Value for
Field From, select SQL

Use the following SQL command:
SELECT nextid FROM arschema WHERE name = 'whatever form you want'

Select your field, make sure it's a numeric field, and set it to $1$ - 1.
$1$ being the first SQL Result Column.

I'm sure there are other ways to skin this cat, but that's the first I
thought of...

HTH
Brian

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
Sent: Friday, June 13, 2008 7:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$

I've never done that before Brian, could you kindly assist me with this?

THANKS!



On Fri, Jun 13, 2008 at 6:27 PM, Brian Gillock
[EMAIL PROTECTED] wrote:
 You should be able to do a Direct SQL for NextID from which ever form you
 need.

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Friday, June 13, 2008 3:00 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Question: $LASTID$

 So since I am doing this in a filter this would explain why it is not
 working.  Any suggestions / work arounds?

 THANKS!

 Ty


 On Fri, Jun 13, 2008 at 4:23 PM, Rick Cook [EMAIL PROTECTED] wrote:
 ** The thing about $LASTID$ is that it can only be called in an Active
 Link,
 because it grabs the last record created by that client.  The form
 involved
 is set by the form name on the AL that calls the action.

 Rick

 On Fri, Jun 13, 2008 at 1:03 PM, Wheeler, Dylan
 [EMAIL PROTECTED]
 wrote:

 I don't see anything about it being able to query a specific form in the
 7.0 docs, would be a great addition though :)

 -

 Dylan Wheeler
 Production Control Analyst Principal
 IT Operations
 Downey Savings  Loan Association, F.A.
 Email: [EMAIL PROTECTED]



 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Friday, June 13, 2008 11:37 AM
 To: arslist@ARSLIST.ORG
 Subject: Question: $LASTID$


 I'm trying to use $LASTID$, but i'm not getting the $LASTID$.

 I thought I read some where that you can now specify the Form that you
 want the LastID from - is this true - or am I just wishing :-)

 THANKS!

 Happy Friday!

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


 This message and any attachments are for the intended recipient(s) only
 and may contain privileged, confidential and/or proprietary information
 about Downey Savings or its customers, which Downey Savings does not
 intend
 to disclose to the public.  If you received this message by mistake,
 please
 notify the sender by reply e-mail and delete the message and
attachments.





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

 __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



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



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

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


Re: Question: $LASTID$

2008-06-14 Thread Wheeler, Dylan
You could also do something like

SELECT MAX(your_request_id_name) FROM your_table_name ORDER BY
your_request_id_name DESC LIMIT 1

Then set the field with $1$

Brian, will your way give the prefix as well? I forgot if the arschema
kept the prefix or not, don't have access to a db at the moment.

- 

Dylan Wheeler
Production Control Analyst Principal 
IT Operations 
Downey Savings  Loan Association, F.A. 
Email: [EMAIL PROTECTED]



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock
Sent: Saturday, June 14, 2008 9:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$


Here's a quick and dirty version...

Create a filter that performs a Set Fields action...From the Read Value
for Field From, select SQL

Use the following SQL command:
SELECT nextid FROM arschema WHERE name = 'whatever form you want'

Select your field, make sure it's a numeric field, and set it to $1$ -
1. $1$ being the first SQL Result Column.

I'm sure there are other ways to skin this cat, but that's the first I
thought of...

HTH
Brian

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
Sent: Friday, June 13, 2008 7:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$

I've never done that before Brian, could you kindly assist me with this?

THANKS!



On Fri, Jun 13, 2008 at 6:27 PM, Brian Gillock
[EMAIL PROTECTED] wrote:
 You should be able to do a Direct SQL for NextID from which ever form 
 you need.

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Friday, June 13, 2008 3:00 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Question: $LASTID$

 So since I am doing this in a filter this would explain why it is not 
 working.  Any suggestions / work arounds?

 THANKS!

 Ty


 On Fri, Jun 13, 2008 at 4:23 PM, Rick Cook [EMAIL PROTECTED] 
 wrote:
 ** The thing about $LASTID$ is that it can only be called in an 
 Active
 Link,
 because it grabs the last record created by that client.  The form
 involved
 is set by the form name on the AL that calls the action.

 Rick

 On Fri, Jun 13, 2008 at 1:03 PM, Wheeler, Dylan
 [EMAIL PROTECTED]
 wrote:

 I don't see anything about it being able to query a specific form in

 the 7.0 docs, would be a great addition though :)

 -

 Dylan Wheeler
 Production Control Analyst Principal
 IT Operations
 Downey Savings  Loan Association, F.A.
 Email: [EMAIL PROTECTED]



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Friday, June 13, 2008 11:37 AM
 To: arslist@ARSLIST.ORG
 Subject: Question: $LASTID$


 I'm trying to use $LASTID$, but i'm not getting the $LASTID$.

 I thought I read some where that you can now specify the Form that 
 you want the LastID from - is this true - or am I just wishing :-)

 THANKS!

 Happy Friday!

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


 This message and any attachments are for the intended recipient(s) 
 only and may contain privileged, confidential and/or proprietary 
 information about Downey Savings or its customers, which Downey 
 Savings does not
 intend
 to disclose to the public.  If you received this message by mistake,
 please
 notify the sender by reply e-mail and delete the message and
attachments.






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

 __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




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




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


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

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


Question: $LASTID$

2008-06-13 Thread T. Dee
I'm trying to use $LASTID$, but i'm not getting the $LASTID$.

I thought I read some where that you can now specify the Form that you
want the LastID from - is this true - or am I just wishing :-)

THANKS!

Happy Friday!

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


Re: Question: $LASTID$

2008-06-13 Thread Wheeler, Dylan
I don't see anything about it being able to query a specific form in the
7.0 docs, would be a great addition though :)

- 

Dylan Wheeler
Production Control Analyst Principal 
IT Operations 
Downey Savings  Loan Association, F.A. 
Email: [EMAIL PROTECTED]



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
Sent: Friday, June 13, 2008 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Question: $LASTID$


I'm trying to use $LASTID$, but i'm not getting the $LASTID$.

I thought I read some where that you can now specify the Form that you
want the LastID from - is this true - or am I just wishing :-)

THANKS!

Happy Friday!


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


This message and any attachments are for the intended recipient(s) only and may 
contain privileged, confidential and/or proprietary information about Downey 
Savings or its customers, which Downey Savings does not intend to disclose to 
the public.  If you received this message by mistake, please notify the sender 
by reply e-mail and delete the message and attachments.

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


Re: Question: $LASTID$

2008-06-13 Thread Rick Cook
The thing about $LASTID$ is that it can only be called in an Active Link,
because it grabs the last record created by that client.  The form involved
is set by the form name on the AL that calls the action.

Rick

On Fri, Jun 13, 2008 at 1:03 PM, Wheeler, Dylan [EMAIL PROTECTED]
wrote:

 I don't see anything about it being able to query a specific form in the
 7.0 docs, would be a great addition though :)

 -

 Dylan Wheeler
 Production Control Analyst Principal
 IT Operations
 Downey Savings  Loan Association, F.A.
 Email: [EMAIL PROTECTED]



 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Friday, June 13, 2008 11:37 AM
 To: arslist@ARSLIST.ORG
 Subject: Question: $LASTID$


 I'm trying to use $LASTID$, but i'm not getting the $LASTID$.

 I thought I read some where that you can now specify the Form that you
 want the LastID from - is this true - or am I just wishing :-)

 THANKS!

 Happy Friday!

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


 This message and any attachments are for the intended recipient(s) only and
 may contain privileged, confidential and/or proprietary information about
 Downey Savings or its customers, which Downey Savings does not intend to
 disclose to the public.  If you received this message by mistake, please
 notify the sender by reply e-mail and delete the message and attachments.


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


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


Re: Question: $LASTID$

2008-06-13 Thread Brian Gillock
You should be able to do a Direct SQL for NextID from which ever form you
need.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
Sent: Friday, June 13, 2008 3:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$

So since I am doing this in a filter this would explain why it is not
working.  Any suggestions / work arounds?

THANKS!

Ty


On Fri, Jun 13, 2008 at 4:23 PM, Rick Cook [EMAIL PROTECTED] wrote:
 ** The thing about $LASTID$ is that it can only be called in an Active
Link,
 because it grabs the last record created by that client.  The form
involved
 is set by the form name on the AL that calls the action.

 Rick

 On Fri, Jun 13, 2008 at 1:03 PM, Wheeler, Dylan
[EMAIL PROTECTED]
 wrote:

 I don't see anything about it being able to query a specific form in the
 7.0 docs, would be a great addition though :)

 -

 Dylan Wheeler
 Production Control Analyst Principal
 IT Operations
 Downey Savings  Loan Association, F.A.
 Email: [EMAIL PROTECTED]



 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Friday, June 13, 2008 11:37 AM
 To: arslist@ARSLIST.ORG
 Subject: Question: $LASTID$


 I'm trying to use $LASTID$, but i'm not getting the $LASTID$.

 I thought I read some where that you can now specify the Form that you
 want the LastID from - is this true - or am I just wishing :-)

 THANKS!

 Happy Friday!

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


 This message and any attachments are for the intended recipient(s) only
 and may contain privileged, confidential and/or proprietary information
 about Downey Savings or its customers, which Downey Savings does not
intend
 to disclose to the public.  If you received this message by mistake,
please
 notify the sender by reply e-mail and delete the message and attachments.




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

 __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

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


Re: Question: $LASTID$

2008-06-13 Thread T. Dee
I've never done that before Brian, could you kindly assist me with this?

THANKS!



On Fri, Jun 13, 2008 at 6:27 PM, Brian Gillock
[EMAIL PROTECTED] wrote:
 You should be able to do a Direct SQL for NextID from which ever form you
 need.

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Friday, June 13, 2008 3:00 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Question: $LASTID$

 So since I am doing this in a filter this would explain why it is not
 working.  Any suggestions / work arounds?

 THANKS!

 Ty


 On Fri, Jun 13, 2008 at 4:23 PM, Rick Cook [EMAIL PROTECTED] wrote:
 ** The thing about $LASTID$ is that it can only be called in an Active
 Link,
 because it grabs the last record created by that client.  The form
 involved
 is set by the form name on the AL that calls the action.

 Rick

 On Fri, Jun 13, 2008 at 1:03 PM, Wheeler, Dylan
 [EMAIL PROTECTED]
 wrote:

 I don't see anything about it being able to query a specific form in the
 7.0 docs, would be a great addition though :)

 -

 Dylan Wheeler
 Production Control Analyst Principal
 IT Operations
 Downey Savings  Loan Association, F.A.
 Email: [EMAIL PROTECTED]



 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Friday, June 13, 2008 11:37 AM
 To: arslist@ARSLIST.ORG
 Subject: Question: $LASTID$


 I'm trying to use $LASTID$, but i'm not getting the $LASTID$.

 I thought I read some where that you can now specify the Form that you
 want the LastID from - is this true - or am I just wishing :-)

 THANKS!

 Happy Friday!

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


 This message and any attachments are for the intended recipient(s) only
 and may contain privileged, confidential and/or proprietary information
 about Downey Savings or its customers, which Downey Savings does not
 intend
 to disclose to the public.  If you received this message by mistake,
 please
 notify the sender by reply e-mail and delete the message and attachments.



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

 __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

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


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


Question: $LASTID$

2007-06-25 Thread Tyrone Dee
I have a Filter that runs on Modify from Form A and pushes data from Form
A to Form B, this works fine.  I'm trying to grab the $LASTID$ of the
record that is creating during the PUSH to Form B.  I'm not having much
luck.  Could someone assist me with this?

Thanks!

T.

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


Re: Question: $LASTID$

2007-06-25 Thread Joe D'Souza
Ty,

Have you tried sending across a unique piece of information (such as a GUID)
during the push across and then querying form B for that unique piece of
information, and getting the Request Id of that entry?

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee
Sent: Monday, June 25, 2007 3:56 PM
To: arslist@ARSLIST.ORG
Subject: Question: $LASTID$


I have a Filter that runs on Modify from Form A and pushes data from Form
A to Form B, this works fine.  I'm trying to grab the $LASTID$ of the
record that is creating during the PUSH to Form B.  I'm not having much
luck.  Could someone assist me with this?

Thanks!

T.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.7/868 - Release Date: 6/25/2007
12:20 PM

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


Re: Question: $LASTID$

2007-06-25 Thread Tyrone Dee
I thought about that, but thought it would be quicker / easier just to use
LASTID - however, it does not seem to be working.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Monday, June 25, 2007 4:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$

Ty,

Have you tried sending across a unique piece of information (such as a GUID)
during the push across and then querying form B for that unique piece of
information, and getting the Request Id of that entry?

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee
Sent: Monday, June 25, 2007 3:56 PM
To: arslist@ARSLIST.ORG
Subject: Question: $LASTID$


I have a Filter that runs on Modify from Form A and pushes data from Form
A to Form B, this works fine.  I'm trying to grab the $LASTID$ of the
record that is creating during the PUSH to Form B.  I'm not having much
luck.  Could someone assist me with this?

Thanks!

T.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.7/868 - Release Date: 6/25/2007
12:20 PM


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

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


Re: Question: $LASTID$

2007-06-25 Thread Grooms, Frederick W
Remember a Push fields is Phase 2, so a Set Fields would never see it
unless you make the filter fire in Phase 1 

The method Joe lists is the safest 

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tyrone Dee
Sent: Monday, June 25, 2007 3:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$

I thought about that, but thought it would be quicker / easier just to
use LASTID - however, it does not seem to be working.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Monday, June 25, 2007 4:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$

Ty,

Have you tried sending across a unique piece of information (such as a
GUID) during the push across and then querying form B for that unique
piece of information, and getting the Request Id of that entry?

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee
Sent: Monday, June 25, 2007 3:56 PM
To: arslist@ARSLIST.ORG
Subject: Question: $LASTID$


I have a Filter that runs on Modify from Form A and pushes data from
Form A to Form B, this works fine.  I'm trying to grab the $LASTID$
of the record that is creating during the PUSH to Form B.  I'm not
having much luck.  Could someone assist me with this?

Thanks!

T.

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


Re: Question: $LASTID$

2007-06-25 Thread Joe D'Souza
Ty,

LASTID is the last id that is transacted, so in the event that there is some
workflow that is processing something elsewhere that resets LASTID, then the
last id may not be the current last id for the transaction you were hoping
for.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee
Sent: Monday, June 25, 2007 4:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$


I thought about that, but thought it would be quicker / easier just to use
LASTID - however, it does not seem to be working.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Monday, June 25, 2007 4:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: $LASTID$

Ty,

Have you tried sending across a unique piece of information (such as a GUID)
during the push across and then querying form B for that unique piece of
information, and getting the Request Id of that entry?

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee
Sent: Monday, June 25, 2007 3:56 PM
To: arslist@ARSLIST.ORG
Subject: Question: $LASTID$


I have a Filter that runs on Modify from Form A and pushes data from Form
A to Form B, this works fine.  I'm trying to grab the $LASTID$ of the
record that is creating during the PUSH to Form B.  I'm not having much
luck.  Could someone assist me with this?

Thanks!

T.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.7/868 - Release Date: 6/25/2007
12:20 PM

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