General information
Category:
Forms & Form designer
>>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
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