Information générale
Catégorie:
Codage, syntaxe et commandes
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement