>>I have created a view programmatically, I am having 3 problems with this view. When changing one of the fields and trying to move to the next field I am receiving error number 1495, which is the key defined by the keyfield property is not unique.
>>
>>2. I also have an update conflict error 1585, I only get this error when I change a field, exit out and try to change it back.
>>
>>3. I am using a save or cancel button, my tableupdate or tablerevert are located in the controls. The view is still updating my table. No matter what option I select.
>>
>>
>>Anyone have any ideas about these problems
>>
>>
>>Thank you
>>
>>Holly Clawson
>
>1) What type of primary keys are you using? Are you changing a primary key field in your view of an existing record?
>
>2) Does it happen on any field? What are you exiting out of (a browse window)???
>
>3) Make sure you are using buffering mode 5, Optimistic Table Buffering.
>
>-Doug-

Doug,

I fixed the first problem. Although the second it happens on any field. I am taking the view and putting that into a grid. When I close my form and re-enter this is happening.

3. I thought with a view you did not have to use data buffering?

One more question, the view is paramterized view, I am testing this using the same data, It appears when I make the selection that the select statement of the view is not going back to the table and getting any information that has changed on that customer. So for example I can make a change exit the form, come back into the form select the same data, the change will appear in the grid, but that is not what is in the table. If I change something in the table, It will not update either, the only way I can get this to work right is change the name of the view that is created every time. Any Ideas on this problem?


Thank you

Holly Clawson