If you come here, please let me know. I swear I am a good guide if you don't mind my poor English.:)

Sunny

>>Thanks a lot. Will you come to Hong Kong later? May I buy you a dinner for my thankfulness?
>>
>>Sunny
>>
>
>Thanks in advance! Chinese foods are really great. We just went there last February 18-20, 1998, and I do not know when will be the next trip. Maybe I'll just inform you by e-mail, not because of the dinner (better if there is, just kidding..), but rather I want to have some friends their in Hongkong.
>
>>>>Could you tell me how to reset the view parameters?
>>>
>>>Sunny,
>>>
>>>What Mike is saying is applicable only if your view is parameterized. But a remote view (source of the offline view) cannot be repopulated unless you drop the offline view first using DROPOFFLINE().
>>>
>>>Resetting view parameter is as simple as changing the value of the variable you used.
>>>
>>>prefdate = "any_value"
>>>=REQUERY("myview")
>>>
>>>where: prefdate is the view parameter you declared at FILTER tab portion upond defining your SQL view.
>>>
>>>Your View SQL statement should be like this:
>>>
>>>SELECT mytable.field1, etc. FROM mytable WHERE mytable.field1 = ?prefdate
>>>
>>>declare your prefdate variable as PUBLIC then initialize it to avoid asking you to enter a value of prefdate upon execution.
>>>
>>>>>>Now, I know the way to use offline view and update SQL server database. However, I am still looking for the way to update remote view which is store inside the user's workstation. Should I create the remote view and offline view again, shouldn't I?
>>>>>>
>>>>>>Sunny
>>>>>
>>>>>Sunny,
>>>>>
>>>>>It's my understanding that once the offline view is placed online (with the USE command) it becomes just a regular every-day remote view. If you want to repopulate it, reset your view parameters and issue a REQUERY(). Then you can take the view offline again.
>>>>>
>>>>>-Mike