RECORD is documented as one of the scope clauses & afaik always has been.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gil Hale Sent: Thursday, June 26, 2008 7:37 AM To: [EMAIL PROTECTED] Subject: Undocumented syntax, works great,but it is driving me nuts. Where did it come from? Why can't I find reference to it? 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 [EMAIL PROTECTED] --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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.
