Thanks a lot. You gave me a great information. I am searching Foxpro Advisior site now.

Wish you always have a good time.

ps.Could I ask you if I have question on this topic again? If you have no time, please tell me. I don't want to bother you.

Sunny

>>Where can I get such information?
>>
>>Sunny
>
>We just reference it on Help system then supported by an issue of Foxpro Advisor sometime on 1997 (Miriam Liskin/Malcol Rubel if not mistaken). Anyway it is not as complicated subject matter as expected.
>
>Jess
>
>>
>>>>Could you tell me how to create off-line view and reload to the main system, please?
>>>>
>>>>Sunny
>>>>
>>>>>>I have a database in my home computer. I want to update the database, which is storing inside office's SQL Server, from my database once weekly.
>>>>>>
>>>>>>Normally, I work on my home computer, because connecting to the office endlessly is impossible. All updated information is storing in my home computer. I must transfer the updated information to office at least once a week.
>>>>>>
>>>>>> I know SQL/Vfp can use some kind of method to connect and interchange the information. But I read through the Developer's Guide of Vfp5.0, couldn't find it. Can anyone tell me how to do?
>>>>>>
>>>>>>Sunny
>>>>>
>>>>>What we are using on our Insurance Systems is Off-line Views, where all agents have their own laptop with system module installed update data then reload again.
>>>
>>>You can look into CREATEOFFLINE(), DROPOFFLINE(), USE feature of VFP5. It is a long discussion here on UT.