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