Yep, I don't see why the need for the tcf either. The reason this is done is that the school cancels a course because not enough people signed up.
So first I update the course record to mark it cancelled. Then I search in line items to find everyone who signed up for the course. The results of that search as used to produce a report for the business off that tells them who they need to send check to for refunds. Then I need to insert a "payment' which is the refund amount into line items so there invoice record will show that they have a credit. Later when the check is actually issued they will apply the refund sent to the line items table and it will balance out the invoice. I have not done the tcf yet waiting to see if it is really needed. I have not had a chance to test the way I have it set up which is Build array from the resultset For loop through the array to create the records in line items All happen right after the search action even though results are displayed as report. Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: "Steve Smith" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Mon, 29 Jul 2002 11:15:02 -0400 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: RE: Witango-Talk: Can I do this? > > I don't need the answer to this problem myself, but I'm curious as to why a > TCF is required. If I understand the problem correctly, a search is > performed, results are obtained, and an insert into a related table is done > using values from each of the search result records. > > My answer would be to simply assign <@NUMROWS> from the search results to a > local variable (say l_numrows), assign the @@resultset to another local > variable (say la_results) and then have a for loop immediately after the > search which used @@local$l_numrows from the search as the upper limit and > say l_counter as the counter variable. In the FOR loop action group have an > INSERT action which used <@VAR NAME='la_results[l_counter,x] SCOPE='LOCAL'> > for the inserted values where x changes for each field being inserted. > > Perhaps Dan could provide more details as to the purpose of this insert > because I'm also curious as to why something like this would be done. > > Hope this helps, > > Steve Smith > > Skadt Information Solutions > Office: (519) 624-4388 > GTA: (416) 606-3885 > Fax: (519) 624-3353 > Cell: (416) 606-3885 > Email: [EMAIL PROTECTED] > Web: http://www.skadt.com > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Sfeir > Sent: July 29, 2002 10:27 AM > To: Multiple recipients of list witango-talk > Subject: Re: Witango-Talk: Can I do this? > > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Yes BUT you have to use a TCF and create a method in the TCF which > accepts the values you want to submit, and have the method do the > insert. There are 2 ways of calling a method: > 1- Drag the method action fill in the data > 2- <@CALLMETHOD> which allows you to do the same but from within an > <@ROWS> or what ever loop you want to use > > R > On Monday, July 29, 2002, at 09:08 AM, Dan Stein wrote: > >> I have a search action that displays a list of people that get credits >> to >> their account. >> >> Can I put a for loop right after the search action and insert a new >> record >> into line items for each row of the results returned in the search >> action. >> >> I do this all the time with a form and post arg from the search action >> results, but will the for loop work without the post arg from the form >> and >> will my report still display? >> >> Dan >> -- >> Dan Stein >> Digital Software Solutions >> 799 Evergreen Circle >> Telford PA 18969 >> Land: 215-799-0192 >> Mobile: 610-256-2843 >> Fax 413-410-9682 >> FMP, WiTango, EDI,SQL 2000 >> [EMAIL PROTECTED] >> www.dss-db.com >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.7 (Darwin) > > iD8DBQE9RVC2K/1j/4sLi/ARAthfAJ0QjzUSOhpb8MzHk0+6eubR+fMMywCgqaIF > oJuRprTLXM+Z2LObuzGx3Ec= > =j8jh > -----END PGP SIGNATURE----- > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
