Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
P-views and grids
Message
From
21/10/1998 15:02:37
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00148953
Message ID:
00149043
Views:
27
David,
1. The view's buffermodeoverride in the de is 5.
2. I only added NOFILTER when nothing else seemed to work :-|
3. I knew there was a problem because TABLEUPDATE( 0, .T., 'lvw_wlevel') returned .F. on just a few records. And only when I was creating more than 30 or so.
4. I added some code and now the code is well-behaved. But it could be accidental. What I've done is SCATTER NAME aErrors[] any record that fails the tableupdate and revert the record. Then, when I'm done with the scan loop in which I add the records, I check the array. If it has any "bad" record objects, I APPEND BLANK into the view, and GATHER FROM the object. And this works. But I distrust it < shrug >.

Any thoughts?

>Nancy,
>
>I never use NOFILTER on any p-view. When I drop fields from the view onto the form or the view into the DE I make sure the view's cursor buffering set to Table. Do not put the underlying table into the DE. After that TableUpdate() and TableRevert() do their jobs just fine.
>
>When you say the data isn't getting committed to the table how are you determining that? If you try to do a SELECT on the view you won't see changes I typically use a SCAN to do things like totals on the view.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform