General information
Category:
Coding, syntax & commands
>>Hi Jim :
>>
>>I see what you are saying. WHen I threw togather the sample code I neglected that. But right now I don't even get that far.
>>1. I set up an updatable view of the 2.6 table.
>>2. I buffer the View. CURSORSETPROP("buffering", 5, "ViewA")
>>3. I do an APPEND BLANK on the view
>>4. Do a Replace on the view.
>>5. Then Table update the View. TABLEUPDATE(0,.T.,"ViewA").
>>
>>The View has the new record in it, but the base tables does not.
>>If I REQUERY("ViewA"), I get the error "Table buffer for alias "ViewA" contains uncommited changes." Any ideas?
>>
>>Ed
>
>Ed,
>
>How are you setting up the updatable view? What is the primary key being used for the 2.6 table? Are you using the view designer or code?
I'm Using the View Designer. From the Update Criteria Tab, I selected the table. I then set the the primary key in a field called "DNIS". Then I pressed the Update All button, checked the Send SQL Updates chckbox, and selected the key and selected the "Key and Update Fields" radio button.
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