Thanks a lot. Will you come to Hong Kong later? May I buy you a dinner for my thankfulness?

Sunny

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