Kevin, I am confused too... Your solution worked fine and I am not sure why I was having problems. Some days are tougher than others - I'm sure you've been there.
As an aside... thanks for "Data From Scratch". I was not aware of CamStudio. It is a helluva tool. Your keyboard sounds brought back very fond memories of my old Northgate Keyboard. Remember them? Back in the dark ages they were about $60 or so. Guaranteed for life and "had the control key where God meant it to be." Thanks again, Carl -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Cully Sent: Wednesday, August 23, 2006 1:21 PM To: [email protected] Subject: Re: Add Record To View I'm confused. Is your APPEND BLANK working? or not? I like the "SCATTER NAME" method. SELECT cTableName SCATTER NAME loNew FIELDS EXCEPT myPK, myDate MEMO loNew.myDate = DATE() loNew.PK = THIS.GetNextPKValue() INSERT INTO cTableName FROM NAME loNew Would this work for you? Kevin Cully CULLY Technologies, LLC Sponsor of Fox Forward 2006! http://foxforward.net BD Operating Systems, Inc. wrote: > I am working with a form with private data sessions. The only item in the > data environment is a view. There is no problem with appending a blank > record, getting input values, and saving. > > But.... I want to add a record, which is a duplicate of a previously added > record - except for the date field. I go the record to be duplicated and > scatter, append a blank record, then gather. I tried to "insert into xxxx > from memvar" - no luck either way. > > How is this done? > > Thanks.... > > Carl Lindner > > > [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 ** 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.
