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
 tushar Kanvinde
 To: chris smith
  Where is chris smith?
 Yorkshire CH CH
 chris smith
Subject: RE: tableupdate(.t.,.t.)
Thread ID: 288831 Message ID: 288837 # Views: 44 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Friday, December 24, 2010 1:23:27 PM         

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



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