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

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 = '' Select your field, make sure it's a numeric field, and set it to $1$ - 1. $1$ being th

Re: BBQ tour

2008-06-14 Thread Bradford Bingel
First, all our wishes for your son's successful deployment and safe return to US soil. Semper Fidelis, young man. Now, on to the "BBQ Tour" . . . three recommended stops: - In Carson City NV, try Red's Old 395 Grill . . . doesn't look like much from the outside, but the bar area will blow

Re: BBQ tour

2008-06-14 Thread Timothy Powell
Rick, In Tuscaloosa, AL, is the original Dreamland BBQ. Best ribs I've ever had. http://www.dreamlandbbq.com/ In Lexington, NC, try Lexington BBQ http://www.ibiblio.org/ch-scene/bbq/lexington.html or Smiley's http://www.smileyslexingtonbbq.com/ Lastly, in Starkville, MS is a wonderful plac

Re: OT: BBQ tour

2008-06-14 Thread Rick Ponzo
Hey Rick, I don't know how you plan to get down south, but if you pass thorough Arizona you'll want to try Joe's Real BBQ (http://www.joesrealbbq.com/). This place has been on many of the cooking channels nationally. If you are going south down the coast through California then you'll want

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: Can't move the Change ticket's Status beyond Request For Authorization.

2008-06-14 Thread lann
Thanks Lisa. The approval process definitions are OTB ones and no change has been made to them. For Request For Authorization Status -Phase-(Review Phase) The definition is as follows: Review Phase Approved-Request For Change Rejected-Request For Authorization No Approvers-Request For Change I ev