Author: MB Software Solutions General Account
Posted: 2008-06-26 at 09:43:31
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?