Hi, Vlad.

>
>This is called "Replication" and it is quite hard to make it as generic as possible. Take a look to the SQL Server replication and see how it is complex, here gurus are right. However, for single particular application when everything is on your control it is not that hard. I thought it would be better to develop your own small replication algorithm instead of workarounding offline views. For me the first thing is less complex than second. With custom program you also will be able to better organize things special to the application, like collisions managing to, for example, merge memo fields in case 2 useds changed memo field simultaneously etc. With generic approach and offline view it might be quite complex.
>
>If you want, I can spend my free time and write a simple replicator for VFP database, but tell on which basis it should work: timestamp or full match. Timestamp is the best approach, when each table have a timestamp field and application updates this field each time changes are made (this coul be done by default value for new records and update triggers in VFP database). Second approach is more generic and complex and have less performance, because it searches changed records using exact field to field match.
>

I'll take you up on that offer. Thanks! I think I would prefer the second option: full match.

Here is my question: I now understand about the problems of data collisions regarding memo fields. But, I'm not understanding the problem with other types of fields. The problem still doesn't seem intrinisic to the design. In other words, in a "normal" design User B could still overwrite the changes made by User A (character, numeric, date, etc). So, I would be interested in what you will write and hope that your solution helps me to understand the problem.

>> 3. I recently found an article/zip by Doug Hennig at the Stonefield site about how to implement a system similiar to what I wanted using CREATEOFFLINE. I've completely overhauled that class to make it more robust and generic.
>>
>
>Can you give ma a link?
>

Do you mean a link to Doug's code, or to what I've written? If you refer to mine, send me your email address and I'll send you a zip file. I have a couple of developers doing some testing for me now. I'd love to get your comments, as well. If you refer to Doug's code, here is the link (when you get there, look for "Implementing Offline Views"): http://www.stonefield.com/techpap.html

Thanks again for the help.

-Bri.