>Thanks for your reply! I modified your code to use my data source. It's still not saving the change I make to the field "Paginated". Am I crazy or what? The code is below for your review. Any help would be appreciated.
>
>lnHandle=Sqlstringconnect('DRIVER=SQL Server;SERVER=sqlserver;'+;
> 'DATABASE=MacroPro;Trusted_Connection=Yes')
>
>SQLExec(lnHandle,'select * from dbo.routes','v_routes')
>CursorSetProp('KeyFieldList','id','v_routes')
>CursorSetProp('WhereType',1,'v_routes')
>CursorSetProp('Tables','routes','v_routes')
>
>CursorSetProp("UpdateNameList", ;
> "paginated routes.paginated",'V_routes')
>
>CursorSetProp('UpdatableFieldList','paginated','v_routes')
>CursorSetProp('SendUpdates',.T.,'v_routes')
>CursorSetProp('Buffering',5,'v_routes')
>
>Browse title "before Update - edit"
>Tableupdate(2,.T.,'v_routes')
>SQLExec(lnHandle,'select * from dbo.routes','afterupdate')
>SQLDisconnect(lnHandle)
>Select afterupdate
>Browse title "After update"
I repeat :) Add keyfield to updatenamelist.
CursorSetProp("UpdateNameList", ;
"id routes.id,paginated routes.paginated",'V_routes')
Cetin