Hi Matt,

You can GATHER NAME loCurrentJob FIELDS EXCEPT ipkey.

-Rick

-----Original Message-----

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On

Behalf Of Matt Slay

Sent: Saturday, December 27, 2008 9:39 PM

To: profoxtech@leafe.com

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]