Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate in View
Message
From
09/08/2000 17:50:47
 
 
To
09/08/2000 17:40:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00403088
Message ID:
00403103
Views:
14
>Do you have any RI on the base tables of this view?
>
>>I have a form with a Grid (using View, updateable, buffermode = 5)... before the grid appears, on the form it prompts the user to enter a value to retrieve records from the table (100,000+ records) then a grid appears (a view with anywhere between a couple records to a few hundred records)... in testing my view retrieved 248 records, I made a change to just one record... clicked save (=tableupdate(1,.T.,"TAcustView")), a message "Running query...." with a progress bar appeared, and it went into a loop 9 times then it finished. I tried again with a different value, changed one record, it looped 11 times. Another value, it retrieved just a few records, it looped once. That's really strange... why? I checked the modified records (as well as the appended records) and all appears OK... but I find it puzzling that =tableupdate would "requery" too many times....

Not at all whatsoever.
Thanks!
~d
J
Previous
Reply
Map
View

Click here to load this message in the networking platform