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!

Regards,

Gil

Gilbert M. Hale

New Freedom Data Resources, Inc.

Pittsford, NY

585-359-8085 - Office (Rolls To Cellular)

585-202-4341 - Cellular/VoiceMail

gil@gilhale.com

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---