Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid with strange behaviour
Message
 
To
02/05/1999 16:03:32
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00214366
Message ID:
00214512
Views:
20
>>>I have a grid based on an updateable view which is tablebuffered.
>>>
>>>When a tabelupdate is executed which returns false because of some
>>>validationrule, my grid is greyed out and the data in it is cleared out. When
>>>I scroll through the grid, the data reappaers and I can continue working. How
>>>can I get rid of this behaviour ???
>
>>A REQUERY() should do all you need.
>
>Nope : a. doesn't work with uncommitted changes and b. this would recall the starting situaltion, what isn't what I need.
>
>>And I should add is always needed after a successful tableupdate(). Since you'll want to update your grid with what's really within the table. But why does your grid grey out, I don't know.
>
>
>I don't understand what you're trying to say here, can you explain further ??

Pascal,

After a failed TABLEUPDATE(), you don't have much choice left except a TABLEREVERT() or you could try to save the records one by one with the help of GETNEXTMODIFIED().

Anyway, when you're finished you'll want to REQUERY() the view in order to have it present you the data in its current state. That's all I wanted to say.

José
Previous
Reply
Map
View

Click here to load this message in the networking platform