Thanks for the response. I've have already tried all you suggested. I guess what I failed to mention was that when I modify a record in the view, everything works fine. The base table gets updated properly. It is when I insert a record in the view I get "Uniqueness of index ID has been violated". I assigned a unique ID to the new record prior to inserting it in the view. When I click 'Ignore' the new record still get's inserted. What is causing this error? Below is my SQL statemnt for creating the view:
SELECT NVL(tt_IdDesc,"Invalid transact ID") AS tt_idDesc, mx_ID, mx_Date, mx_FinSize, mx_SrcID, mx_SrcType, mx_Ac_ID, mx_tt_ID, mx_tt_Code, mx_AShares, mx_FX_ID, mx_FX_Rate, mx_Module, mx_Descr, mx_New, mx_PostAmt, mx_Reviewd
FROM mTrnsAct INNER JOIN TranType ON tt_ID == mx_tt_ID
WHERE mx_SrcID == ?nCo_ID ORDER BY mx_Date
My CURSORSETPROP()'s are:
TABLE : mTrnsAct
KEYFIELDLIST : mx_ID
UPDATABLEFIELDLIST : (all except tt_IDDesc)
SENDUPDATES : .T.
BUFFERING : 3
Everything works fine for my single table views. What am missing?
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