>If you come here, please let me know. I swear I am a good guide if you don't mind my poor English.:)
>
>Sunny
Your English is just the same as mine. It sounds like Foxpro Language which is much clearer than Assembly or C... :<)
>
>>>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."