Matt: Why don't you... **select your record... SCATTER NAME loCurrentJob loCurrentJob.JobNo = lcNewJobNo INSERT INTO Jobs FROM NAME loCurrentJob
Regards, Jack Skelley ________________________________________ From: [email protected] [[email protected]] On Behalf Of Matt Slay [[email protected]] Sent: Saturday, December 27, 2008 10:38 PM To: [email protected] Subject: Help with GATHER and AutoInc fields Need some guidance here... I am trying to copy the data in one record to a new record in the same table, then change the JobNo field to some new Job umber that I already have and validated as unique. The problem is that the table has an AutoInc field named "ipkey", and VFP does not want to let me do a GATHER for obvious reasons. So, I understand why it has this limitation because of autoinc, I just want to know how one normally works around it. Presently, to get around it, I am doing a REPLACE command on every field except ipkey, but I was hoping to use the SCATTER NAME / GATHER NAME method to avoid having to list out every field, and so I would have code that is independent of the field names. Here's what I wanted to use: Select 0 Use Jobs order jobno ... navigate to the desired record .. SCATTER NAME loCurrentJob Append Blank Gather NAME loCurrentJob replace JobNo with lcNewJobNo && a passed in value, already validated --- 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/0b957900b2b8194d998a441195b66038380881a...@drdsrv03.drdad.thenewarkarena.com ** 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.
