Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: chris smith
  Where is chris smith?
 Yorkshire CH CH
 Barbados
 chris smith
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: tableupdate(.t.,.t.)
Thread ID: 288831 Message ID: 288869 # Views: 30 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Saturday, December 25, 2010 3:00:32 AM         
   


> > Hi All
> >
> > I am using a local view and when I save a new record to the table with the tableupdate(.t.,.t.) it saves right away, however if I navigate to a record in the table(well requery() a record to the local view) make a change then save with the tableupdate(.t.,.t.) it takes about 15 seconds to save....(this is unacceptable) the table contains about 1/4 millions+ records....I find that when I use tableupdate(.t.) (just one .t. as the parameter), the editing and saving works as it should....My question is why does the tableupdate(.t.,.t.) take so long to save an edited record?
> >
> > Chris Smith
>
> Have you specified a primary key to the view. What is the WhereType for the view.
>
> Regards
> Tushar

thanks

yes I have a primary key in the base table and the view is requery() based on that primary integer field


cheer

Chris Smith

ENTIRE THREAD

tableupdate(.t.,.t.) Posted by chris smith @ 12/24/2010 1:07:58 PM
RE: tableupdate(.t.,.t.) Posted by tushar @ 12/24/2010 1:23:27 PM
RE: tableupdate(.t.,.t.) Posted by chris smith @ 12/25/2010 3:00:32 AM