> So what's it do? Is it like a SCATTER? > Th implementation looks similar to using SCATTER, but for this situation SCATTER/GATHER was apparently not quite what I needed. I use SCATTER/GATHER for other purposes in my code, and it works well. But in this case I think it must have been a performance issue (Pentium 75Mhz PCs with 16Mg RAM!) and/or because it was easier to work with the REPLACE command with two table in a relationship where the Parent table was being updated by the Child table. From about a decade ago it is a bit hazy, and since it is working so nicely with fairly large sets I am planning to leave it alone.
Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions > General Account > Sent: Thursday, June 26, 2008 9:44 AM > To: [EMAIL PROTECTED] > Subject: Re: Undocumented syntax, works great, but it is driving me > nuts.Where did it come from? Why can't I find reference to it? > > > Gil Hale wrote: > > Good Day, All! > > > > I am using some very old VFP3 code as the underpinnings for a > new project > > (very stable code, still in use daily all around the country), and came > > across a command using a syntax I can't find in either the VFP9 > help file or > > VFP7 Hacker's Guide electronic documentation. It looks a bit clunky > > compared to how I implement the command in my current code, but > I do believe > > it was set up the way shown below as I was writing against an ORACLE > > read/write cursor back then (now a VFP table) and was having > problems with > > the ODBC driver when it came to trying to record data into the > target cursor > > without doing some strange shuffling around. Anyway, here is > what it looks > > like: > > > > . > > . > > . > > > > SELECT xiSORCursor > > mThisRecord = RECNO('xiSORCursor') > > > > REPLACE cVIN with mVIN, ; > > cAdvisor WITH mAdvisor, ; > > cSORNum with mSORNum, ; > > cCancelDat with mCancelDat, ; > > cCustNum with mCustNum, ; > > RECORD mThisRecord > > . > > . > > . > > > > The syntax question involves my use of the "RECORD mThisRecord" > part of the > > REPLACE command. I cant find any reference to tacking that > onto the REPLACE > > command, yet it still compiles in VFP9 and runs fine. So, this > is more of a > > "curiosity thing" than a "it is broken, now what?" matter. I > do not want to > > remove that unknown part of the code, as it is working fine and > had to have > > been put there by myself long ago for a pretty good reason. > > > > Thanks for the anticipated shedding of light! > > > So what's it do? Is it like a SCATTER? > > [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/[EMAIL PROTECTED] ** 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.
