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