lnHandle=Sqlstringconnect('DRIVER=SQL Server;'+; 'SERVER=(local);DATABASE=pubs;Trusted_Connection=Yes') SQLExec(lnHandle,'select * from dbo.authors','v_authors') CursorSetProp('KeyFieldList','au_id','v_authors') CursorSetProp('WhereType',1,'v_authors') CursorSetProp('Tables','authors','v_authors') CursorSetProp("UpdateNameList", ; "au_id authors.au_id,"+; "au_lname authors.au_lname,"+; "au_fname authors.au_fname,"+; "contract authors.contract",'V_authors') CursorSetProp('UpdatableFieldList','au_fname,au_lname,contract','v_authors') CursorSetProp('SendUpdates',.T.,'v_authors') CursorSetProp('Buffering',5,'v_authors') Browse Tableupdate(2,.T.,'v_authors') SQLExec(lnHandle,'select * from dbo.authors','afterupdate') SQLDisconnect(lnHandle) Select afterupdate BrowseCetin