Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Matt Slay
  Where is Matt Slay?
 Birmingham
 Alabama - United States
 Matt Slay
 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: 209439 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 28, 2008 9:24:39 PM         
   


Thanks guys - Also, I wanted to share these suggestions from Sergey on Universal Thread:

Hi Matt,

You can use SET AUTOINCERROR OFF to suppress the error or you can use REMOVEPROPERTY() to remove "ipkey" from loCurrentJob object.
I'm not sure why do you want to use REPLACE after GATHER if you can change/set properties of the loCurrentJob object before GATHER.





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