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
