You have 2 forms: form1 which contains the field where you want to store the number of records you find in form2.
Create a temp field in form1: zTmp Create an optional field in form1 to hold the number of records found in form2: RowCount Create a filter attached to form1: 1st action: Set field from: Form1 No match: Set fields to $NULL$ Multiple match: Use 1st matching Set Field if: the query you had in your table field Set Fields: zTmp <-- $1$ 2nd action Set field from: Current Transaction Set Fields: RowCount <-- $LASTCOUNT$ Best regards, ARSmarts support team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 10 May 2010, at 18:48, Ravi wrote: > ** So, if I use the first way you mentioned: > Since, I don't have the dummy field, so do I need to add a temp field to that > form. > If so then still what should I be using to set the count? As the need is to > set count of number of rows in the table to a field.( > Table contains only one column but will have multiple rows) and then use > $LASTCOUNT$ ( As COLCOUNT is not working) ? > Please let me know. > Thank you. > > On Mon, May 10, 2010 at 9:09 AM, ARSmarts Support <[email protected]> > wrote: > ** > Hi, > > You can make a filter with 2 set field actions: > - the 1st one is just setting a dummy field with the result of the query you > want to count the results > - the 2nd one uses the $LASTCOUNT$ keyword > > or > you use a set field with SQL source, and write a query like SELECT > COUNT(Field1) FROM table_Name WHERE query > > Best regards, > ARSmarts support team > > > > ARSmarts, your most useful AR System companion. > www.ARSmarts.com > > On 10 May 2010, at 17:41, Raj wrote: > >> Hi All, >> Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields >> action of a Filter on Submit. Seems is it not working. Always setting >> the field to a constant value of 15. >> Would like to set the field with the number of rows in that particular >> table. Is the any other way around to do this? >> How can it be done with the help of Direct SQL ? >> >> Please advise. >> Thanks, >> Ravi >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > > > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
