>DBC contains 10000 Record and I'm facing problem with updatable view.
>
>When I create any single table paramatrize updatable view as a new item in DBC , after some time it's automatically work as readonly view.I don't know why it's working this way, If you have any suggesion help me lot.
>
>Thanks in advance
Is the actual view not updatable or is the ReadOnly property of the cursor in the DE getting changed to true? What about the ReadOnly properties of the controls [grid, textboxes, etc.]?
If you open the view from the command window, what do the following return? --
? DBGetProp('MyView', 'View', 'SendUpdates') and
? DBGetProp('MyView', 'View', 'UpdateType'). You can also use this function to retrieve Updatable and UpdateName for fields in the view. If you make a change to the data and issue
? TableUpdate(.t.,.t.) from the command window, is the return value true?
Make sure you are not executing any code that recreates the view without setting all the appropriate properties to make the view updatable.
Mark McCasland
Midlothian, TX USA