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?
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