Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: Help with Gather and AutoInc field
Thread ID: 209377 Message ID: 209392 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 28, 2008 10:06:17 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/

Never alter a cursor. Instead do not select the ipkey column. Altering cursors can make you drop long field names.

Regards
Tushar

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