>I have upsized a VFP application to use SQL data. The upsize produced remote views that appear to work well with the application except - I ahve a crystal report that prints in the middle of a routine and before the application would write the data to the table (data source for the report) before the report printed.
>
>Since the upsize the data in the cursor has been updated but not the actual data on the SQL Server. How do I force the remote view to update the table on the server?
>
>
>Thanks
>Gary Tarpley
You need to be sure that "send sql updates" is set to .T. in your remote view, and also have some fields selected as updatable. Then issue the tableupdate() command....
Forcing the update would be something like this:
llTableUpdate = TableUpdate(.T., .T., 'myviewname')
ICQ 10556 (ya), 254117