On Tue, Jun 24, 2014 at 2:35 PM, Mike Copeland <[email protected]> wrote:
> Thanks Stephen. > > From what I've been able to find (i.e. Google) there may be a way to run a > Python or Perl script on the server that would query the database manager > for whatever change is being monitored, and then somehow (insert magic > beans here) signal back to 'interested workstations' (i.e. subscribers) > that things have changed. > > Based on my limited knowledge of network protocols, I'm beginning to think > that if the workstation simply checks for changes in the data (via > timestamp or some trigger as you mentioned), the traffic is about as low as > possible. > > If I'm not mistaken, the VFP SPT process is always initiated from the > workstation...never from the server. > > ---------------------- > Placing code in the proper place will make life easier. Calling a stored procedure on the DB is usually how companies operate trying to keep from getting hacked. Within your sproc you query first for timestamp of table you are updating. If that value = to the param you just set in you update. If not the same you message back that someone else beat you to the update. Your sproc usually needs to return the Pkey of the table to you allowing your use of said data in child tables. I would just return -PKey value to keep things simple for the client *as well as all of the current data for that row.* Now you identify if your change(s) is/are different from theirs. In reality I would never consider trying to put the control of who is looking at what data anywhere. Instead I would just identify if someone changed it while I was trying to make an edit. Can this app be run multiple times on a PC? Did an emergency come up that required my attention and 4 hours later I see that I didn't hit save. Foxpro is fast when it contains the data and a little slower when it is fetching from non fox environments. This becomes huge in no time at all. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYKFg6RFS+ptHS1HrvEXR4Y+m1CObUgKEjgBS=bt=-g...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
