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 wel

Re: Question: $LASTID$

2008-06-14 Thread Wheeler, Dylan
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 nam

Re: Question: $LASTID$

2008-06-14 Thread Brian Gillock
e 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 SQ

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.

Re: Question: $LASTID$

2008-06-13 Thread T. Dee
> 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 no

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

Re: Question: $LASTID$

2008-06-13 Thread T. Dee
[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:

Re: Question: $LASTID$

2008-06-13 Thread Rick Cook
mail: [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

Re: Question: $LASTID$

2008-06-13 Thread Wheeler, Dylan
l 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 whe

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! _

Re: Question: $LASTID$

2007-06-25 Thread Joe D'Souza
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

Re: Question: $LASTID$

2007-06-25 Thread Grooms, Frederick W
: 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

Re: Question: $LASTID$

2007-06-25 Thread Tyrone Dee
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-

Re: Question: $LASTID$

2007-06-25 Thread Joe D'Souza
) [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

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. ___