Hi,
Why not keep away from direct-sql when it is not absolutely neccessary?
FLTR
ACTION
SET-FIELDS from FormX ('1' > "0")
myResult = $1$
ACTION
SET-FIELDS from CURRENT TRANSACTION
myResult = $LASTCOUNT$
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Raj,
>
> What is the reason you need that counter? Just to have a total count of
> tickets in form 1?? Or is there another reason?
>
> If you just want a count, I wouldn't create a form. I would have a hidden
> field that did a select count(*) from whatever view name that table has in
> the underlying database..
>
> Cheers
>
> Joe
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]]on Behalf Of Raj
> Sent: Thursday, April 15, 2010 8:04 PM
> To: [email protected]
> Subject: need to design a counter
>
>
> Hello all,
> There is an integer field on form1.
> need to design a counter which increments the count by one for every
> submit on form2.
> So, need to write a filter on submit of form 2 which increments the
> integer field on form 1 by 1 for every submit on form 2.please advise.
> thanks,
> Raj
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
