Granted and true, But the question was will the other way work and it seems the answer there is yes although tcf improves the quality of the code.
-- 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: Robert Sfeir <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Mon, 29 Jul 2002 12:03:47 -0400 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: Can I do this? > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > TCF makes your code reusable, and you can load the TCF in the > application scope so it's used by everyone, therefore making your > application more object oriented and more efficient to use over all. > > Just my opinion. > > R > On Monday, July 29, 2002, at 11:47 AM, Steve Smith wrote: > >> Sounds like you're using a similar method to the one that I suggested >> and >> that you are on the right track. >> >> Let me know if you have any problems. >> >> 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 Dan Stein >> Sent: July 29, 2002 11:33 AM >> To: Multiple recipients of list witango-talk >> Subject: Re: Witango-Talk: Can I do this? >> >> >> 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 >> >> ________________________________________________________________________ >> 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) > > iD8DBQE9RWdnK/1j/4sLi/ARAo3EAJ47cr2uVsedpkWmZw/OJX0ZMXGZkgCgx4Z9 > MzfSoIRWmiJQIa1oHGi6jtk= > =QGbp > -----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
