Re: DBF Synchronization

2012-05-07 Thread Stephen Russell
On Mon, May 7, 2012 at 8:28 AM, Jeff Johnson wrote: > Excuse me if this was recently discussed because I thought it was, but > couldn't find it.  I want to synchronize several VFP9 dbf files.  A user > uses her laptop and then when she returns to the office want's to > synchronize the dbf's with t

Re: DBF Synchronization

2012-05-07 Thread Kevin Cully
It'd really help if you used UUIDs (GUIDs) as the primary keys as well. SYS(2015) is the VFP poor-man's UUID function (emphasis on poor) but I'd recommend getting one of the UUID functions in case record creation grows to many per second or more. On 05/07/2012 10:54 AM, Stephen Russell wrote: >

RE: DBF Synchronization

2012-05-07 Thread José Enrique Llopis
I have on a project a Journal table where i write the modifications Just send the journal to another system and recover it to replicate all the changes made on the first computer. I have on every table to sync a field named SYNCTAG C(12) with the DefaultValue versynccode("TABLENAME") The d

Re: DBF Synchronization

2012-05-07 Thread Paul McNett
On 5/7/12 8:03 AM, Stephen Russell wrote: > On Mon, May 7, 2012 at 10:01 AM, Kevin Cully > wrote: >> It'd really help if you used UUIDs (GUIDs) as the primary keys as well. >> > - > > I second this statement. Third. ___ Post Messa

Re: DBF Synchronization

2012-05-07 Thread Rafael Copquin
I have a syncronization table with fields to capture the modified table's name, the type of modification (N= new record, D= deleted record, M=modified record), a datetime field and a Syncronized field (logical) Every time an update occurs in any table, the operation is recorded in the syncroni

RE: DBF Synchronization

2012-05-07 Thread José Enrique Llopis
Thanks Pepe Llopis -Mensaje original- De: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] En nombre de Eurico Chagas Filho Enviado el: lunes, 07 de mayo de 2012 19:15 Para: ProFox Email List Asunto: Re: DBF Synchronization Nice, thanks for the code. E. --- StripMime

Re: DBF Synchronization

2012-05-07 Thread AndyD
offline views? AndyD 8-)₹ On 07/05/2012 14:28, Jeff Johnson wrote: > I want to synchronize several VFP9 dbf files. A user > uses her laptop and then when she returns to the office want's to > synchronize the dbf's with the server. A full two way synchronization > > TIA >

Re: DBF Synchronization

2012-05-07 Thread MB Software Solutions, LLC
On 5/7/2012 10:54 AM, Stephen Russell wrote: > On Mon, May 7, 2012 at 8:28 AM, Jeff Johnson wrote: >> Excuse me if this was recently discussed because I thought it was, but >> couldn't find it. I want to synchronize several VFP9 dbf files. A user >> uses her laptop and then when she returns to t

Re: DBF Synchronization

2012-05-07 Thread MB Software Solutions, LLC
On 5/7/2012 1:40 PM, AndyD wrote: > offline views? I saw that in VFP Help years ago but I thought I had heard somewhere that they didn't work as well as you might think? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fa

Re: DBF Synchronization

2012-05-08 Thread Paul McNett
On 5/7/12 2:39 PM, MB Software Solutions, LLC wrote: > Good points, but begs the question: is this a 1-way synch or 2-way? In > other words, are changes on the laptop only going to the server, or is > it possible for server changes to be newer than the laptop and thus you > go that direction (fro

RE: DBF Synchronization

2012-05-08 Thread José Enrique Llopis
20:26 Para: profox@leafe.com Asunto: Re: DBF Synchronization On 5/7/12 2:39 PM, MB Software Solutions, LLC wrote: > Good points, but begs the question: is this a 1-way synch or 2-way? In > other words, are changes on the laptop only going to the server, or is > it possible for server chang

Re: DBF Synchronization

2012-05-08 Thread Stephen Russell
On Tue, May 8, 2012 at 1:25 PM, Paul McNett wrote: > On 5/7/12 2:39 PM, MB Software Solutions, LLC wrote: >> Good points, but begs the question:  is this a 1-way synch or 2-way?  In >> other words, are changes on the laptop only going to the server, or is >> it possible for server changes to be ne

Re: DBF Synchronization

2012-05-08 Thread Paul McNett
On 5/8/12 1:02 PM, Stephen Russell wrote: > >> > 5) syncing a client to a server should block other clients from syncing >> > at the same time > Not sure about only one at a time. Makes Monday morning a bitch when > the sales team is all present. I guess that isn't really a hard requirement,

Re: DBF Synchronization

2012-05-08 Thread MB Software Solutions, LLC
On 5/8/2012 4:02 PM, Stephen Russell wrote: >> 5) syncing a client to a server should block other clients from syncing at >> the same time > > Not sure about only one at a time. Makes Monday morning a bitch when > the sales team is all present. Salesman #1 updates Acme Company customer record

Re: DBF Synchronization

2012-05-08 Thread Paul McNett
On 5/8/12 1:16 PM, MB Software Solutions, LLC wrote: > On 5/8/2012 4:02 PM, Stephen Russell wrote: >>> >> 5) syncing a client to a server should block other clients from syncing >>> >> at the same time >> > >> > Not sure about only one at a time. Makes Monday morning a bitch when >> > the s

Re: DBF Synchronization

2012-05-08 Thread MB Software Solutions, LLC
On 5/8/2012 4:20 PM, Paul McNett wrote: > On 5/8/12 1:16 PM, MB Software Solutions, LLC wrote: >> On 5/8/2012 4:02 PM, Stephen Russell wrote: >> 5) syncing a client to a server should block other clients from >> syncing at the same time Not sure about only one at a time.

Re: DBF Synchronization

2012-05-08 Thread Rafael Copquin
But the thing is, why should one salesperson step on the toes of another salesperson? I mean, the ACME Co should be served by one person, because it is located in the geographical area assigned to her/him by management. Another salesperson would be assigned another co and so on. Unless, clients

Re: DBF Synchronization

2012-05-09 Thread Thierry Nivelet
If you installed FoxInCloud Adaptation Assistant, you've got a free DBC /DBF synchronization class See \Tools\ab\abData.prg: DEFINE CLASS abDataSyncVFP AS Custom relies on a timestamp field to be defined in property .cTimeStampField Thierry Nivelet FoxInCloud Give your VFP app a second life in

Re: DBF Synchronization

2012-05-09 Thread Thierry Nivelet
precision: you need to install FAA *and* adapt your application to FiC or install FoxInCloud Application Server, trial edition both softwares are free to use. Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 09/05/12 10:49, Thierry Nivelet a écr

Re: Re: DBF Synchronization

2012-05-08 Thread AndyD
I looked at in some depth a few years ago and as far as I can remember the main problem was lack of decent documentation, I didn't use it in anger because in the end I convinced the user to move the backend to SQL Server and wrote a small fairly limited web app for the remote users. AndyD 8-)₹