Here VFP9 SP1. Take a look at
set AUTOINCERROR OFF Using it you no more have the need to bother writing on the autoinc field, because it is read-only. So you can continue to use your familiar gather istruction. -- Gianni On Sat, 27 Dec 2008 21:38:34 -0600, Matt Slay <[email protected]> wrote: >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/[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.
