Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: Terry Bottorff
  Where is Terry Bottorff?
 Cheyenne
 Wyoming - United States
 Terry Bottorff
 Tags
Subject: RE: Primary Key
Thread ID: 22002 Message ID: 22004 # Views: 32 # Ratings: 0
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Monday, April 07, 2003 1:59:25 PM         
   


> If I have a table that has an integer field (ikey) and a character field (cname) and the integer field is the primary key. Is there a way in code to set the ikey field not to the primary key - append records - fill the ikey field with the appropriate key - set in code ikey back to the primary key? I know how to do everything but set the ikey field "not to a primary key field" and then "set it to a primary key field". TIA.
>
> Buffiie

Hi Terry, is it an option for you to replace the key value of the records you want to append BEFORE appending them?
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

COMPLETE THREAD

Primary Key Posted by Terry Bottorff @ 4/7/2003 1:25:42 PM
RE: Primary Key Posted by Eric den Doop @ 4/7/2003 1:59:25 PM
RE: Primary Key Posted by Terry Bottorff @ 4/8/2003 2:35:31 PM
RE: Primary Key Posted by Eric den Doop @ 4/8/2003 2:59:05 PM
RE: Primary Key Posted by Terry Bottorff @ 4/8/2003 5:45:14 PM
RE: Primary Key Posted by Boudewijn Lutgerink @ 4/7/2003 2:49:50 PM
RE: Primary Key Posted by Terry Bottorff @ 4/8/2003 2:37:03 PM