=CURSORSETPROP("Buffering", 5, "vueTable") DBSetProp('VUETABLE', 'View', 'UpdateType', 1) DBSetProp('VUETABLE', 'View', 'WhereType', 3) DBSetProp('VUETABLE', 'View', 'FetchMemo', .T.) DBSetProp('VUETABLE', 'View', 'SendUpdates', .T.) DBSetProp('VUETABLE', 'View', 'UseMemoSize', 255) DBSetProp('VUETABLE', 'View', 'FetchSize', 100) DBSetProp('VUETABLE', 'View', 'MaxRecords', -1) DBSetProp('VUETABLE', 'View', 'Tables', 'QorM') DBSetProp('VUETABLE', 'View', 'Prepared', .F.) DBSetProp('VUETABLE', 'View', 'CompareMemo', .T.) DBSetProp('VUETABLE', 'View', 'FetchAsNeeded', .F.) DBSetProp('VUETABLE', 'View', 'FetchSize', 100) DBSetProp('VUETABLE', 'View', 'Comment', "") DBSetProp('VUETABLE', 'View', 'BatchUpdateCount', 1) DBSetProp('VUETABLE', 'View', 'ShareConnection', .F.) *!* Field Level Properties for VUETABLE FOR gnCount = 1 TO FCOUNT( ) && Loop for number of fields DBSetProp("vueTable."+FIELD(gnCount), 'Field', 'KeyField', .F.) DBSetProp("vueTable."+FIELD(gnCount), 'Field', 'Updatable', .T.) DBSetProp("vueTable."+FIELD(gnCount), 'Field', 'UpdateName', 'QorM.'+FIELD(gnCount)) NEXT *!* Set the key field to SSN coz previous step makes is not updatable DBSETPROP("vueTable.ssn","FIELD","KEYFIELD",.T.) DBSETPROP("vueTable.ssn","FIELD","UPDATABLE",.T.) DBSETPROP("vueTable.ssn","FIELD","UPDATENAME",'QorM.ssn')in my save method of my form
llSucess=TABLEUPDATE(.t.) IF llSucess *WAIT WINDOW 'Sucessfully Saved' TIMEOUT .5 ELSE MESSAGEBOX('Sorry Record Not saved',16,'Oops Sorry') ENDIFthe data gets saved in the view,but when i close the form and use the base table i dont see the data get updated.