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