Vince, Don't forget to add the MEMO keyword to the end of the scatter name, gather name or you won't save or load any memo variables!!!
Sometimes a real gotcha and I don't know why M$ didn'e make the memo option a default setting with maybe "No Memo" as an option to opt out. Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Vince Teachout Sent: 11 March 2009 15:50 To: ProFox Email List Subject: Re: Autoincrement field Peter Cushing wrote: > Been using INSERT INTO xxx FROM MEMVAR for years but when you have > scattered to an object like say Thisform.oVars and you want to insert a > record, VFP7 does not give you the NAME option. I put in a bit of code > to get round it, but it would be nice to just do it directly. > > SELECT pohead > FOR lnCnt = 1 TO FCOUNT() > lValue = EVALUATE('thisform.oVars.'+FIELD(lnCnt)) > cTempfld = 'm.'+(FIELD(lnCnt)) > &cTempfld = lValue > NEXT > > INSERT INTO pohead FROM MEMVAR Peter, I'm not following the reason for your code above. Couldn't you do the same thing by: SELECT pohead SCATTER MEMVAR INSERT INTO pohead FROM MEMVAR ? [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/297058218d714a7eb8f10943efcd5...@develop ** 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.
