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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only