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.
