Excuse me. I feel a little bit shame because I can't use odbc to update a vfp table by Excel. (What's wrong of me!?)

I am using Excel97 to retrieve external database for updating a vfp table. The retriving procedure was very successful. Then, I update the records. No problem. But when I save it by 'Save' button, Excel hasn't update my vfp table at the same time.

Sorry, bother you again.

(We are not only have good Chinese Food, also have very good Philipino Food, Japanese Food, Korean Food,..... You can eat(not walk) around the world.)

Sunny

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