My part of the project - is the creation of the Invoices based upon the Orders or Pick Tickets. For the final creation of the EDI Type Invoice file that gets transmitted - that's not my problem - it's the job for another programmer here...
:-) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Virgil Bierschwale Sent: Wednesday, March 24, 2010 5:46 PM To: [email protected] Subject: Re: Large # Rec's, Cursors & UR Opinion... Didn't I understand that you are going to create a EDI type file submission so that you can send it to somebody else? Must have missed that part as I was working on Pete's article.. On 3/24/2010 4:36 PM, Kurt Wendt wrote: > FYI - the processing is only for a single invoice at a time... > > Also - as R or R mentioned - as long as I don't have a big records > (maybe 10 fields in a record) or Memo fields (don't need them in this > particular cursor) - the supposedly the Cursor should stay purely in > Memory... > > -K- > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Virgil Bierschwale > Sent: Wednesday, March 24, 2010 5:37 PM > > you'll see why when you start debugging it and totaling up the invoices > for multiple sites, multiple invoices, etc...<grin> > > > On 3/24/2010 4:08 PM, Kurt Wendt wrote: > >> But - Virgil - Cursors act largely like a Temp DBF - so, I see no >> > reason > >> not to use a Cursor over a Temp DBF - exact in the case of what I am >> trying to figure out here. As in - will it slow things down too much - >> with too many records and TOO Many Queries made to it - during the >> processing of a SINGLE Invoice... >> >> -K- >> >> -----Original Message----- >> From: [email protected] >> > [mailto:[email protected]] > >> On Behalf Of Virgil Bierschwale >> Sent: Wednesday, March 24, 2010 5:03 PM >> >> thats why you're going to end up doing it exactly like what I just >> spelled out... >> too much to keep track of in cursors. >> >> I'm sure others will disagree, but the old ways work best some times >> > in > >> my opinion. >> >> >> On 3/24/2010 3:45 PM, Kurt Wendt wrote: >> >> >>> Virgil - understand that I'm not writing a full invoicing program - >>> >>> >> but, >> >> >>> rather - I need to plug-in code within the whole invoicing that >>> >>> >> already >> >> >>> exists. And there are Multiple programs - due to multiple types of >>> Invoicing (by Pick Tickets, or by specific lines, or by store, or by >>> Style, etc.). >>> >>> Although, maybe you are just saying to use Temp DBF's - as opposed to >>> >>> >> my >> >> >>> using a Cursor? >>> >>> -K- >>> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a14071a1...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
