From: chris smith
Yorkshire CH CH
To: tushar Kanvinde
Visual FoxPro 6
General VFP Topics
Saturday, December 25, 2010 3:00:32 AM
This message was rated by:
> > 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.
yes I have a primary key in the base table and the view is requery() based on that primary integer field
Posted by chris smith @ 12/24/2010 1:07:58 PM
Posted by tushar @ 12/24/2010 1:23:27 PM
Posted by chris smith @ 12/25/2010 3:00:32 AM