Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Matt Slay
  Where is Matt Slay?
 Birmingham
 Alabama - United States
 Matt Slay
 Tags
Subject: RE: Help with Gather and AutoInc field
Thread ID: 209377 Message ID: 209378 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 28, 2008 6:28:57 AM         
   


> 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 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

Hi Matt, I cannot find a way to do it via SCATTER and GATHER commands but since you said the reason is that you want something that is independent of field names, maybe you will like this, maybe not:

DupRecord(jobs.ipkey)

*********
Function DupRecord(liipkey)
*********
SELECT * FROM Jobs WHERE ipkey = m.liipkey INTO CURSOR junk READWRITE 
ALTER table junk drop COLUMN ipkey
SELECT Jobs
APPEND FROM DBF("junk")
USE IN SELECT("junk")
Return



NOT TESTED!

Jun Tangunan
http://weblogs.foxite.com/sandstorm36/

ENTIRE THREAD

Help with Gather and AutoInc field Posted by Matt Slay @ 12/28/2008 4:50:36 AM
RE: Help with Gather and AutoInc field Posted by Jun Tangunan @ 12/28/2008 6:28:57 AM
RE: Help with Gather and AutoInc field Posted by tushar @ 12/28/2008 10:06:17 AM
RE: Help with Gather and AutoInc field Posted by Matt Slay @ 12/28/2008 9:24:39 PM
RE: Help with Gather and AutoInc field Posted by Koen Piller @ 12/28/2008 8:49:44 AM