>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
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."