Hi All
Before we start this just figured it would make sense to reach out to you guys for any general advice or pointers you can give.
We have a typical multiuser VFP application using a DBC with DBF’s and local views.
The forms that interact with this data all have a DE and for the deployed versions we have DPATHMGR sorting the DE paths out making everything work.
We have no immediate need to change anything about from front end , it’s relatively straight forward and most of the code is based around TABLEUPDATE and TABLEREVERT.
Our mission is just to loose the DBFs and move the data to SQL as our first pass. No intentions to make use of SQL things like stored procedures , we just want to treat it as a data dump for the moment.
So after using VFPX/UpsizingWizard our initial thoughts are to replace the local view with remote views and then continue with the current method of CRUD via the views.
Anything you feel is worth a heads up on for us to consider before we get on with it?
Regards
Chris
No, that's pretty much it. I think the only issue I had is if you're using incrementing keys in vfp. IIRC, you need to remove that field from the view, and add it to the backend instead, then don't reference it. I seem to recall some issues with maybe Memo General and/or Blob? Basically few problems and what there were were obvious (crash) and easily fixed. Good luck!
On Sunday, November 24th, 2024 at 9:42 AM, Chris Davis chrisd@actongate.co.uk wrote:
Hi All
Before we start this just figured it would make sense to reach out to you guys for any general advice or pointers you can give.
We have a typical multiuser VFP application using a DBC with DBF’s and local views.
The forms that interact with this data all have a DE and for the deployed versions we have DPATHMGR sorting the DE paths out making everything work.
We have no immediate need to change anything about from front end , it’s relatively straight forward and most of the code is based around TABLEUPDATE and TABLEREVERT.
Our mission is just to loose the DBFs and move the data to SQL as our first pass. No intentions to make use of SQL things like stored procedures , we just want to treat it as a data dump for the moment.
So after using VFPX/UpsizingWizard our initial thoughts are to replace the local view with remote views and then continue with the current method of CRUD via the views.
Anything you feel is worth a heads up on for us to consider before we get on with it?
Regards
Chris
[excessive quoting removed by server]
TWFrZSBzdXJlIHlvdSBhcmUgdXNpbmcgdGhlIGxhdGVzdCB2ZXJzaW9uIG9mIHRoZSBVVyB3aGljaCBpcyBhdmFpbGFibGUgZnJvbSBWRlBYLiBBIGxvdCBvZiBxdWlya3MgaGF2ZSBiZWVuIGZpeGVkIGFuZCBpdOKAmXMgYWxzbyBtdWNoIGZhc3Rlci4NClRoZSB1cHNpemluZyB3aXphcmQgd2lsbCBjcmVhdGUgdGhlIHJlbW90ZSB2aWV3cyBmb3IgeW91Lg0KVGhlcmXigJlzIG5vIHN1Y2ggdGhpbmcgYXMgYW4gZW1wdHkgZGF0ZSBpbiBTUUwgc28gaWYgeW91IGhhdmUgdGhlbSBpbiB5b3VyIFZGUCBkYXRhIHlvdSBoYXZlIHNvbWUgY2hvaWNlcy4NCkkgaGlnaGx5IHJlY29tbWVuZCByZWFkaW5nIHRoZSAgZmluZSBtYW51YWwuIPCfmIoNCg0KLS0NCg0KcmsNCg0KRnJvbTogUHJvZm94VGVjaCA8cHJvZm94dGVjaC1ib3VuY2VzQGxlYWZlLmNvbT4gT24gQmVoYWxmIE9mIENocmlzIERhdmlzDQpTZW50OiBTdW5kYXksIE5vdmVtYmVyIDI0LCAyMDI0IDk6NDIgQU0NClRvOiBwcm9mb3h0ZWNoQGxlYWZlLmNvbQ0KU3ViamVjdDogRGF0YWJhc2UgTWlncmF0aW9uIFBvaW50ZXJzDQoNCkhpIEFsbA0KDQpCZWZvcmUgd2Ugc3RhcnQgdGhpcyBqdXN0IGZpZ3VyZWQgaXQgd291bGQgbWFrZSBzZW5zZSB0byByZWFjaCBvdXQgdG8geW91IGd1eXMgZm9yIGFueSBnZW5lcmFsIGFkdmljZSBvciBwb2ludGVycyB5b3UgY2FuIGdpdmUuDQoNCldlIGhhdmUgYSB0eXBpY2FsIG11bHRpdXNlciBWRlAgYXBwbGljYXRpb24gdXNpbmcgYSBEQkMgd2l0aCBEQkbigJlzIGFuZCBsb2NhbCB2aWV3cy4NCg0KVGhlIGZvcm1zIHRoYXQgaW50ZXJhY3Qgd2l0aCB0aGlzIGRhdGEgYWxsIGhhdmUgYSBERSBhbmQgZm9yIHRoZSBkZXBsb3llZCB2ZXJzaW9ucyB3ZSBoYXZlIERQQVRITUdSIHNvcnRpbmcgdGhlIERFIHBhdGhzIG91dCBtYWtpbmcgZXZlcnl0aGluZyB3b3JrLg0KDQpXZSBoYXZlIG5vIGltbWVkaWF0ZSBuZWVkIHRvIGNoYW5nZSBhbnl0aGluZyBhYm91dCBmcm9tIGZyb250IGVuZCAsIGl04oCZcyByZWxhdGl2ZWx5IHN0cmFpZ2h0IGZvcndhcmQgYW5kIG1vc3Qgb2YgdGhlIGNvZGUgaXMgYmFzZWQgYXJvdW5kIFRBQkxFVVBEQVRFIGFuZCBUQUJMRVJFVkVSVC4NCg0KT3VyIG1pc3Npb24gaXMganVzdCB0byBsb29zZSB0aGUgREJGcyBhbmQgbW92ZSB0aGUgZGF0YSB0byBTUUwgYXMgb3VyIGZpcnN0IHBhc3MuIE5vIGludGVudGlvbnMgdG8gbWFrZSB1c2Ugb2YgU1FMIHRoaW5ncyBsaWtlIHN0b3JlZCBwcm9jZWR1cmVzICwgd2UganVzdCB3YW50IHRvIHRyZWF0IGl0IGFzIGEgZGF0YSBkdW1wIGZvciB0aGUgbW9tZW50Lg0KDQpTbyBhZnRlciB1c2luZyBWRlBYL1Vwc2l6aW5nV2l6YXJkIG91ciBpbml0aWFsIHRob3VnaHRzIGFyZSB0byByZXBsYWNlIHRoZSBsb2NhbCB2aWV3IHdpdGggcmVtb3RlIHZpZXdzIGFuZCB0aGVuIGNvbnRpbnVlIHdpdGggdGhlIGN1cnJlbnQgbWV0aG9kIG9mIENSVUQgdmlhIHRoZSB2aWV3cy4NCg0KQW55dGhpbmcgeW91IGZlZWwgaXMgd29ydGggYSBoZWFkcyB1cCBvbiBmb3IgdXMgdG8gY29uc2lkZXIgYmVmb3JlIHdlIGdldCBvbiB3aXRoIGl0Pw0KDQpSZWdhcmRzDQoNCkNocmlzDQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KUG9zdCBNZXNzYWdlcyB0bzogUHJvRm94QGxlYWZlLmNvbTxtYWlsdG86UHJvRm94QGxlYWZlLmNvbT4NClN1YnNjcmlwdGlvbiBNYWludGVuYW5jZTogaHR0cHM6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3Byb2ZveDxodHRwczovL3VybC51cy5tLm1pbWVjYXN0cHJvdGVjdC5jb20vcy9hMkltQ004RTJKdXFsb0tRVVF0Vkg4VUdKcD9kb21haW49bWFpbC5sZWFmZS5jb20+DQpPVC1mcmVlIHZlcnNpb24gb2YgdGhpcyBsaXN0OiBodHRwczovL21haWwubGVhZmUuY29tL21haWxtYW4vbGlzdGluZm8vcHJvZm94dGVjaDxodHRwczovL3VybC51cy5tLm1pbWVjYXN0cHJvdGVjdC5jb20vcy8xRkRUQ05rRTJZUzBSbksyYzB1b0h5LU1WbD9kb21haW49bWFpbC5sZWFmZS5jb20+DQpTZWFyY2hhYmxlIEFyY2hpdmU6IGh0dHBzOi8vbGVhZmUuY29tL2FyY2hpdmVzPGh0dHBzOi8vdXJsLnVzLm0ubWltZWNhc3Rwcm90ZWN0LmNvbS9zLzFXU3pDT1lFMlB1cEdQVjZTQUNsSEdXTXZwP2RvbWFpbj1sZWFmZS5jb20+DQpUaGlzIG1lc3NhZ2U6IGh0dHBzOi8vbGVhZmUuY29tL2FyY2hpdmVzL2J5TUlEL0REMEVBM0I3LTFDRkEtNEIyNS05QzAwLTJBNDRDREE5NDhBRkBhY3RvbmdhdGUuY28udWs8aHR0cHM6Ly91cmwudXMubS5taW1lY2FzdHByb3RlY3QuY29tL3MvbXpwN0NQTk05eklLbERZN2laRjBIeFNJWDk/ZG9tYWluPWxlYWZlLmNvbT4NCioqIEFsbCBwb3N0aW5ncywgdW5sZXNzIGV4cGxpY2l0bHkgc3RhdGVkIG90aGVyd2lzZSwgYXJlIHRoZSBvcGluaW9ucyBvZiB0aGUgYXV0aG9yLCBhbmQgZG8gbm90IGNvbnN0aXR1dGUgbGVnYWwgb3IgbWVkaWNhbCBhZHZpY2UuIFRoaXMgc3RhdGVtZW50IGlzIGFkZGVkIHRvIHRoZSBtZXNzYWdlcyBmb3IgdGhvc2UgbGF3eWVycyB3aG8gYXJlIHRvbyBzdHVwaWQgdG8gc2VlIHRoZSBvYnZpb3VzLg0K--- StripMime Report -- processed MIME parts ---multipart/alternative text/plain (text body -- kept) text/html---
What Richard said! It translates to:
Make sure you are using the latest version of the UW which is available from VFPX. A lot of quirks have been fixed and it’s also much faster. The upsizing wizard will create the remote views for you. There’s no such thing as an empty date in SQL so if you have them in your VFP data you have some choices. I highly recommend reading the fine manual. 😊
--
rk
On Mon, Nov 25, 2024 at 7:34 AM Richard Kaye rkaye@invaluable.com wrote:
TWFrZSBzdXJlIHlvdSBhcmUgdXNpbmcgdGhlIGxhdGVzdCB2ZXJzaW9uIG9mIHRoZSBVVyB3aGlj aCBpcyBhdmFpbGFibGUgZnJvbSBWRlBYLiBBIGxvdCBvZiBxdWlya3MgaGF2ZSBiZWVuIGZpeGVk IGFuZCBpdOKAmXMgYWxzbyBtdWNoIGZhc3Rlci4NClRoZSB1cHNpemluZyB3aXphcmQgd2lsbCBj cmVhdGUgdGhlIHJlbW90ZSB2aWV3cyBmb3IgeW91Lg0KVGhlcmXigJlzIG5vIHN1Y2ggdGhpbmcg YXMgYW4gZW1wdHkgZGF0ZSBpbiBTUUwgc28gaWYgeW91IGhhdmUgdGhlbSBpbiB5b3VyIFZGUCBk YXRhIHlvdSBoYXZlIHNvbWUgY2hvaWNlcy4NCkkgaGlnaGx5IHJlY29tbWVuZCByZWFkaW5nIHRo ZSAgZmluZSBtYW51YWwuIPCfmIoNCg0KLS0NCg0KcmsNCg0KRnJvbTogUHJvZm94VGVjaCA8cHJv Zm94dGVjaC1ib3VuY2VzQGxlYWZlLmNvbT4gT24gQmVoYWxmIE9mIENocmlzIERhdmlzDQpTZW50 OiBTdW5kYXksIE5vdmVtYmVyIDI0LCAyMDI0IDk6NDIgQU0NClRvOiBwcm9mb3h0ZWNoQGxlYWZl LmNvbQ0KU3ViamVjdDogRGF0YWJhc2UgTWlncmF0aW9uIFBvaW50ZXJzDQoNCkhpIEFsbA0KDQpC ZWZvcmUgd2Ugc3RhcnQgdGhpcyBqdXN0IGZpZ3VyZWQgaXQgd291bGQgbWFrZSBzZW5zZSB0byBy ZWFjaCBvdXQgdG8geW91IGd1eXMgZm9yIGFueSBnZW5lcmFsIGFkdmljZSBvciBwb2ludGVycyB5 b3UgY2FuIGdpdmUuDQoNCldlIGhhdmUgYSB0eXBpY2FsIG11bHRpdXNlciBWRlAgYXBwbGljYXRp b24gdXNpbmcgYSBEQkMgd2l0aCBEQkbigJlzIGFuZCBsb2NhbCB2aWV3cy4NCg0KVGhlIGZvcm1z IHRoYXQgaW50ZXJhY3Qgd2l0aCB0aGlzIGRhdGEgYWxsIGhhdmUgYSBERSBhbmQgZm9yIHRoZSBk ZXBsb3llZCB2ZXJzaW9ucyB3ZSBoYXZlIERQQVRITUdSIHNvcnRpbmcgdGhlIERFIHBhdGhzIG91 dCBtYWtpbmcgZXZlcnl0aGluZyB3b3JrLg0KDQpXZSBoYXZlIG5vIGltbWVkaWF0ZSBuZWVkIHRv IGNoYW5nZSBhbnl0aGluZyBhYm91dCBmcm9tIGZyb250IGVuZCAsIGl04oCZcyByZWxhdGl2ZWx5 IHN0cmFpZ2h0IGZvcndhcmQgYW5kIG1vc3Qgb2YgdGhlIGNvZGUgaXMgYmFzZWQgYXJvdW5kIFRB QkxFVVBEQVRFIGFuZCBUQUJMRVJFVkVSVC4NCg0KT3VyIG1pc3Npb24gaXMganVzdCB0byBsb29z ZSB0aGUgREJGcyBhbmQgbW92ZSB0aGUgZGF0YSB0byBTUUwgYXMgb3VyIGZpcnN0IHBhc3MuIE5v IGludGVudGlvbnMgdG8gbWFrZSB1c2Ugb2YgU1FMIHRoaW5ncyBsaWtlIHN0b3JlZCBwcm9jZWR1 cmVzICwgd2UganVzdCB3YW50IHRvIHRyZWF0IGl0IGFzIGEgZGF0YSBkdW1wIGZvciB0aGUgbW9t ZW50Lg0KDQpTbyBhZnRlciB1c2luZyBWRlBYL1Vwc2l6aW5nV2l6YXJkIG91ciBpbml0aWFsIHRo b3VnaHRzIGFyZSB0byByZXBsYWNlIHRoZSBsb2NhbCB2aWV3IHdpdGggcmVtb3RlIHZpZXdzIGFu ZCB0aGVuIGNvbnRpbnVlIHdpdGggdGhlIGN1cnJlbnQgbWV0aG9kIG9mIENSVUQgdmlhIHRoZSB2 aWV3cy4NCg0KQW55dGhpbmcgeW91IGZlZWwgaXMgd29ydGggYSBoZWFkcyB1cCBvbiBmb3IgdXMg dG8gY29uc2lkZXIgYmVmb3JlIHdlIGdldCBvbiB3aXRoIGl0Pw0KDQpSZWdhcmRzDQoNCkNocmlz DQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KUG9zdCBN ZXNzYWdlcyB0bzogUHJvRm94QGxlYWZlLmNvbTxtYWlsdG86UHJvRm94QGxlYWZlLmNvbT4NClN1 YnNjcmlwdGlvbiBNYWludGVuYW5jZTogaHR0cHM6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFuL2xp c3RpbmZvL3Byb2ZveDxodHRwczovL3VybC51cy5tLm1pbWVjYXN0cHJvdGVjdC5jb20vcy9hMklt Q004RTJKdXFsb0tRVVF0Vkg4VUdKcD9kb21haW49bWFpbC5sZWFmZS5jb20+DQpPVC1mcmVlIHZl cnNpb24gb2YgdGhpcyBsaXN0OiBodHRwczovL21haWwubGVhZmUuY29tL21haWxtYW4vbGlzdGlu Zm8vcHJvZm94dGVjaDxodHRwczovL3VybC51cy5tLm1pbWVjYXN0cHJvdGVjdC5jb20vcy8xRkRU Q05rRTJZUzBSbksyYzB1b0h5LU1WbD9kb21haW49bWFpbC5sZWFmZS5jb20+DQpTZWFyY2hhYmxl IEFyY2hpdmU6IGh0dHBzOi8vbGVhZmUuY29tL2FyY2hpdmVzPGh0dHBzOi8vdXJsLnVzLm0ubWlt ZWNhc3Rwcm90ZWN0LmNvbS9zLzFXU3pDT1lFMlB1cEdQVjZTQUNsSEdXTXZwP2RvbWFpbj1sZWFm ZS5jb20+DQpUaGlzIG1lc3NhZ2U6IGh0dHBzOi8vbGVhZmUuY29tL2FyY2hpdmVzL2J5TUlEL0RE MEVBM0I3LTFDRkEtNEIyNS05QzAwLTJBNDRDREE5NDhBRkBhY3RvbmdhdGUuY28udWs8aHR0cHM6 Ly91cmwudXMubS5taW1lY2FzdHByb3RlY3QuY29tL3MvbXpwN0NQTk05eklLbERZN2laRjBIeFNJ WDk/ZG9tYWluPWxlYWZlLmNvbT4NCioqIEFsbCBwb3N0aW5ncywgdW5sZXNzIGV4cGxpY2l0bHkg c3RhdGVkIG90aGVyd2lzZSwgYXJlIHRoZSBvcGluaW9ucyBvZiB0aGUgYXV0aG9yLCBhbmQgZG8g bm90IGNvbnN0aXR1dGUgbGVnYWwgb3IgbWVkaWNhbCBhZHZpY2UuIFRoaXMgc3RhdGVtZW50IGlz IGFkZGVkIHRvIHRoZSBtZXNzYWdlcyBmb3IgdGhvc2UgbGF3eWVycyB3aG8gYXJlIHRvbyBzdHVw aWQgdG8gc2VlIHRoZSBvYnZpb3VzLg0K
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Thank you Vincent/Richard and Ted for the translation 😊
I will start with the UW and see how I get on, thank you.
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Ted Roche Sent: 25 November 2024 12:42 To: profoxtech@leafe.com Cc: profoxtech@leafe.com Subject: Re: Database Migration Pointers
What Richard said! It translates to:
Make sure you are using the latest version of the UW which is available from VFPX. A lot of quirks have been fixed and it’s also much faster. The upsizing wizard will create the remote views for you. There’s no such thing as an empty date in SQL so if you have them in your VFP data you have some choices. I highly recommend reading the fine manual. 😊
--
rk
On Mon, Nov 25, 2024 at 7:34 AM Richard Kaye rkaye@invaluable.com wrote:
TWFrZSBzdXJlIHlvdSBhcmUgdXNpbmcgdGhlIGxhdGVzdCB2ZXJzaW9uIG9mIHRoZSBVVy B3aGlj aCBpcyBhdmFpbGFibGUgZnJvbSBWRlBYLiBBIGxvdCBvZiBxdWlya3MgaGF2ZSBiZWVuIG ZpeGVk IGFuZCBpdOKAmXMgYWxzbyBtdWNoIGZhc3Rlci4NClRoZSB1cHNpemluZyB3aXphcmQgd2 lsbCBj cmVhdGUgdGhlIHJlbW90ZSB2aWV3cyBmb3IgeW91Lg0KVGhlcmXigJlzIG5vIHN1Y2ggdG hpbmcg YXMgYW4gZW1wdHkgZGF0ZSBpbiBTUUwgc28gaWYgeW91IGhhdmUgdGhlbSBpbiB5b3VyIF ZGUCBk YXRhIHlvdSBoYXZlIHNvbWUgY2hvaWNlcy4NCkkgaGlnaGx5IHJlY29tbWVuZCByZWFkaW 5nIHRo ZSAgZmluZSBtYW51YWwuIPCfmIoNCg0KLS0NCg0KcmsNCg0KRnJvbTogUHJvZm94VGVjaC A8cHJv Zm94dGVjaC1ib3VuY2VzQGxlYWZlLmNvbT4gT24gQmVoYWxmIE9mIENocmlzIERhdmlzDQ pTZW50 OiBTdW5kYXksIE5vdmVtYmVyIDI0LCAyMDI0IDk6NDIgQU0NClRvOiBwcm9mb3h0ZWNoQG xlYWZl LmNvbQ0KU3ViamVjdDogRGF0YWJhc2UgTWlncmF0aW9uIFBvaW50ZXJzDQoNCkhpIEFsbA 0KDQpC ZWZvcmUgd2Ugc3RhcnQgdGhpcyBqdXN0IGZpZ3VyZWQgaXQgd291bGQgbWFrZSBzZW5zZS B0byBy ZWFjaCBvdXQgdG8geW91IGd1eXMgZm9yIGFueSBnZW5lcmFsIGFkdmljZSBvciBwb2ludG VycyB5 b3UgY2FuIGdpdmUuDQoNCldlIGhhdmUgYSB0eXBpY2FsIG11bHRpdXNlciBWRlAgYXBwbG ljYXRp b24gdXNpbmcgYSBEQkMgd2l0aCBEQkbigJlzIGFuZCBsb2NhbCB2aWV3cy4NCg0KVGhlIG Zvcm1z IHRoYXQgaW50ZXJhY3Qgd2l0aCB0aGlzIGRhdGEgYWxsIGhhdmUgYSBERSBhbmQgZm9yIH RoZSBk ZXBsb3llZCB2ZXJzaW9ucyB3ZSBoYXZlIERQQVRITUdSIHNvcnRpbmcgdGhlIERFIHBhdG hzIG91 dCBtYWtpbmcgZXZlcnl0aGluZyB3b3JrLg0KDQpXZSBoYXZlIG5vIGltbWVkaWF0ZSBuZW VkIHRv IGNoYW5nZSBhbnl0aGluZyBhYm91dCBmcm9tIGZyb250IGVuZCAsIGl04oCZcyByZWxhdG l2ZWx5 IHN0cmFpZ2h0IGZvcndhcmQgYW5kIG1vc3Qgb2YgdGhlIGNvZGUgaXMgYmFzZWQgYXJvdW 5kIFRB QkxFVVBEQVRFIGFuZCBUQUJMRVJFVkVSVC4NCg0KT3VyIG1pc3Npb24gaXMganVzdCB0by Bsb29z ZSB0aGUgREJGcyBhbmQgbW92ZSB0aGUgZGF0YSB0byBTUUwgYXMgb3VyIGZpcnN0IHBhc3 MuIE5v IGludGVudGlvbnMgdG8gbWFrZSB1c2Ugb2YgU1FMIHRoaW5ncyBsaWtlIHN0b3JlZCBwcm 9jZWR1 cmVzICwgd2UganVzdCB3YW50IHRvIHRyZWF0IGl0IGFzIGEgZGF0YSBkdW1wIGZvciB0aG UgbW9t ZW50Lg0KDQpTbyBhZnRlciB1c2luZyBWRlBYL1Vwc2l6aW5nV2l6YXJkIG91ciBpbml0aW FsIHRo b3VnaHRzIGFyZSB0byByZXBsYWNlIHRoZSBsb2NhbCB2aWV3IHdpdGggcmVtb3RlIHZpZX dzIGFu ZCB0aGVuIGNvbnRpbnVlIHdpdGggdGhlIGN1cnJlbnQgbWV0aG9kIG9mIENSVUQgdmlhIH RoZSB2 aWV3cy4NCg0KQW55dGhpbmcgeW91IGZlZWwgaXMgd29ydGggYSBoZWFkcyB1cCBvbiBmb3 IgdXMg dG8gY29uc2lkZXIgYmVmb3JlIHdlIGdldCBvbiB3aXRoIGl0Pw0KDQpSZWdhcmRzDQoNCk Nocmlz DQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KUG 9zdCBN ZXNzYWdlcyB0bzogUHJvRm94QGxlYWZlLmNvbTxtYWlsdG86UHJvRm94QGxlYWZlLmNvbT 4NClN1 YnNjcmlwdGlvbiBNYWludGVuYW5jZTogaHR0cHM6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbW FuL2xp c3RpbmZvL3Byb2ZveDxodHRwczovL3VybC51cy5tLm1pbWVjYXN0cHJvdGVjdC5jb20vcy 9hMklt Q004RTJKdXFsb0tRVVF0Vkg4VUdKcD9kb21haW49bWFpbC5sZWFmZS5jb20+DQpPVC1mcm Q004RTJKdXFsb0tRVVF0Vkg4VUdKcD9kb21haW49bWFpbC5sZWFmZS5jb20+VlIHZl cnNpb24gb2YgdGhpcyBsaXN0OiBodHRwczovL21haWwubGVhZmUuY29tL21haWxtYW4vbG lzdGlu Zm8vcHJvZm94dGVjaDxodHRwczovL3VybC51cy5tLm1pbWVjYXN0cHJvdGVjdC5jb20vcy 8xRkRU Q05rRTJZUzBSbksyYzB1b0h5LU1WbD9kb21haW49bWFpbC5sZWFmZS5jb20+DQpTZWFyY2 Q05rRTJZUzBSbksyYzB1b0h5LU1WbD9kb21haW49bWFpbC5sZWFmZS5jb20+hhYmxl IEFyY2hpdmU6IGh0dHBzOi8vbGVhZmUuY29tL2FyY2hpdmVzPGh0dHBzOi8vdXJsLnVzLm 0ubWlt ZWNhc3Rwcm90ZWN0LmNvbS9zLzFXU3pDT1lFMlB1cEdQVjZTQUNsSEdXTXZwP2RvbWFpbj 1sZWFm ZS5jb20+DQpUaGlzIG1lc3NhZ2U6IGh0dHBzOi8vbGVhZmUuY29tL2FyY2hpdmVzL2J5TU ZS5jb20+lEL0RE MEVBM0I3LTFDRkEtNEIyNS05QzAwLTJBNDRDREE5NDhBRkBhY3RvbmdhdGUuY28udWs8aH R0cHM6 Ly91cmwudXMubS5taW1lY2FzdHByb3RlY3QuY29tL3MvbXpwN0NQTk05eklLbERZN2laRj BIeFNJ WDk/ZG9tYWluPWxlYWZlLmNvbT4NCioqIEFsbCBwb3N0aW5ncywgdW5sZXNzIGV4cGxpY2 l0bHkg c3RhdGVkIG90aGVyd2lzZSwgYXJlIHRoZSBvcGluaW9ucyBvZiB0aGUgYXV0aG9yLCBhbm QgZG8g bm90IGNvbnN0aXR1dGUgbGVnYWwgb3IgbWVkaWNhbCBhZHZpY2UuIFRoaXMgc3RhdGVtZW 50IGlz IGFkZGVkIHRvIHRoZSBtZXNzYWdlcyBmb3IgdGhvc2UgbGF3eWVycyB3aG8gYXJlIHRvby BzdHVw aWQgdG8gc2VlIHRoZSBvYnZpb3VzLg0K
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CACW6n4uDtCh8F_B850wpbz_oBsPL+on9gL=WnsV=Qe... ** 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.
WW914oCZZCB0aGluayBieSBub3cgSSB3b3VsZCByZW1lbWJlciB0byBtYWtlIHN1cmUgTG9va291dCB1c2VzIHBsYWluIHRleHQuIEJ1dCB5b3XigJlkIHRoaW5rIHdyb25nLi4NCg0KVGhhbmtzLCBUZWQuDQoNCi0tDQoNCnJrDQoNCkZyb206IFByb2ZveFRlY2ggPHByb2ZveHRlY2gtYm91bmNlc0BsZWFmZS5jb20+IE9uIEJlaGFsZiBPZiBUZWQgUm9jaGUNClNlbnQ6IE1vbmRheSwgTm92ZW1iZXIgMjUsIDIwMjQgNzo0MiBBTQ0KVG86IHByb2ZveHRlY2hAbGVhZmUuY29tDQpDYzogcHJvZm94dGVjaEBsZWFmZS5jb20NClN1YmplY3Q6IFJlOiBEYXRhYmFzZSBNaWdyYXRpb24gUG9pbnRlcnMNCg0KV2hhdCBSaWNoYXJkIHNhaWQhIEl0IHRyYW5zbGF0ZXMgdG86DQoNCk1ha2Ugc3VyZSB5b3UgYXJlIHVzaW5nIHRoZSBsYXRlc3QgdmVyc2lvbiBvZiB0aGUgVVcgd2hpY2ggaXMNCmF2YWlsYWJsZSBmcm9tIFZGUFguIEEgbG90IG9mIHF1aXJrcyBoYXZlIGJlZW4gZml4ZWQgYW5kIGl04oCZcyBhbHNvDQptdWNoIGZhc3Rlci4NClRoZSB1cHNpemluZyB3aXphcmQgd2lsbCBjcmVhdGUgdGhlIHJlbW90ZSB2aWV3cyBmb3IgeW91Lg0KVGhlcmXigJlzIG5vIHN1Y2ggdGhpbmcgYXMgYW4gZW1wdHkgZGF0ZSBpbiBTUUwgc28gaWYgeW91IGhhdmUgdGhlbSBpbg0KeW91ciBWRlAgZGF0YSB5b3UgaGF2ZSBzb21lIGNob2ljZXMuDQpJIGhpZ2hseSByZWNvbW1lbmQgcmVhZGluZyB0aGUgZmluZSBtYW51YWwuIPCfmIoNCg0KLS0NCg0KcmsNCg0KT24gTW9uLCBOb3YgMjUsIDIwMjQgYXQgNzozNOKAr0FNIFJpY2hhcmQgS2F5ZSA8cmtheWVAaW52YWx1YWJsZS5jb208bWFpbHRvOnJrYXllQGludmFsdWFibGUuY29tPj4gd3JvdGU6DQo+DQo+IFRXRnJaU0J6ZFhKbElIbHZkU0JoY21VZ2RYTnBibWNnZEdobElHeGhkR1Z6ZENCMlpYSnphVzl1SUc5bUlIUm9aU0JWVnlCM2FHbGoNCj4gYUNCcGN5QmhkbUZwYkdGaWJHVWdabkp2YlNCV1JsQllMaUJCSUd4dmRDQnZaaUJ4ZFdseWEzTWdhR0YyWlNCaVpXVnVJR1pwZUdWaw0KPiBJR0Z1WkNCcGRPS0FtWE1nWVd4emJ5QnRkV05vSUdaaGMzUmxjaTROQ2xSb1pTQjFjSE5wZW1sdVp5QjNhWHBoY21RZ2QybHNiQ0JqDQo+IGNtVmhkR1VnZEdobElISmxiVzkwWlNCMmFXVjNjeUJtYjNJZ2VXOTFMZzBLVkdobGNtWGlnSmx6SUc1dklITjFZMmdnZEdocGJtY2cNCj4gWVhNZ1lXNGdaVzF3ZEhrZ1pHRjBaU0JwYmlCVFVVd2djMjhnYVdZZ2VXOTFJR2hoZG1VZ2RHaGxiU0JwYmlCNWIzVnlJRlpHVUNCaw0KPiBZWFJoSUhsdmRTQm9ZWFpsSUhOdmJXVWdZMmh2YVdObGN5NE5Da2tnYUdsbmFHeDVJSEpsWTI5dGJXVnVaQ0J5WldGa2FXNW5JSFJvDQo+IFpTQWdabWx1WlNCdFlXNTFZV3d1SVBDZm1Jb05DZzBLTFMwTkNnMEtjbXNOQ2cwS1JuSnZiVG9nVUhKdlptOTRWR1ZqYUNBOGNISnYNCj4gWm05NGRHVmphQzFpYjNWdVkyVnpRR3hsWVdabExtTnZiVDRnVDI0Z1FtVm9ZV3htSUU5bUlFTm9jbWx6SUVSaGRtbHpEUXBUWlc1MA0KPiBPaUJUZFc1a1lYa3NJRTV2ZG1WdFltVnlJREkwTENBeU1ESTBJRGs2TkRJZ1FVME5DbFJ2T2lCd2NtOW1iM2gwWldOb1FHeGxZV1psDQo+IExtTnZiUTBLVTNWaWFtVmpkRG9nUkdGMFlXSmhjMlVnVFdsbmNtRjBhVzl1SUZCdmFXNTBaWEp6RFFvTkNraHBJRUZzYkEwS0RRcEMNCj4gWldadmNtVWdkMlVnYzNSaGNuUWdkR2hwY3lCcWRYTjBJR1pwWjNWeVpXUWdhWFFnZDI5MWJHUWdiV0ZyWlNCelpXNXpaU0IwYnlCeQ0KPiBaV0ZqYUNCdmRYUWdkRzhnZVc5MUlHZDFlWE1nWm05eUlHRnVlU0JuWlc1bGNtRnNJR0ZrZG1salpTQnZjaUJ3YjJsdWRHVnljeUI1DQo+IGIzVWdZMkZ1SUdkcGRtVXVEUW9OQ2xkbElHaGhkbVVnWVNCMGVYQnBZMkZzSUcxMWJIUnBkWE5sY2lCV1JsQWdZWEJ3YkdsallYUnANCj4gYjI0Z2RYTnBibWNnWVNCRVFrTWdkMmwwYUNCRVFrYmlnSmx6SUdGdVpDQnNiMk5oYkNCMmFXVjNjeTROQ2cwS1ZHaGxJR1p2Y20xeg0KPiBJSFJvWVhRZ2FXNTBaWEpoWTNRZ2QybDBhQ0IwYUdseklHUmhkR0VnWVd4c0lHaGhkbVVnWVNCRVJTQmhibVFnWm05eUlIUm9aU0JrDQo+IFpYQnNiM2xsWkNCMlpYSnphVzl1Y3lCM1pTQm9ZWFpsSUVSUVFWUklUVWRTSUhOdmNuUnBibWNnZEdobElFUkZJSEJoZEdoeklHOTENCj4gZENCdFlXdHBibWNnWlhabGNubDBhR2x1WnlCM2IzSnJMZzBLRFFwWFpTQm9ZWFpsSUc1dklHbHRiV1ZrYVdGMFpTQnVaV1ZrSUhSdg0KPiBJR05vWVc1blpTQmhibmwwYUdsdVp5QmhZbTkxZENCbWNtOXRJR1p5YjI1MElHVnVaQ0FzSUdsMDRvQ1pjeUJ5Wld4aGRHbDJaV3g1DQo+IElITjBjbUZwWjJoMElHWnZjbmRoY21RZ1lXNWtJRzF2YzNRZ2IyWWdkR2hsSUdOdlpHVWdhWE1nWW1GelpXUWdZWEp2ZFc1a0lGUkINCj4gUWt4RlZWQkVRVlJGSUdGdVpDQlVRVUpNUlZKRlZrVlNWQzROQ2cwS1QzVnlJRzFwYzNOcGIyNGdhWE1nYW5WemRDQjBieUJzYjI5eg0KPiBaU0IwYUdVZ1JFSkdjeUJoYm1RZ2JXOTJaU0IwYUdVZ1pHRjBZU0IwYnlCVFVVd2dZWE1nYjNWeUlHWnBjbk4wSUhCaGMzTXVJRTV2DQo+IElHbHVkR1Z1ZEdsdmJuTWdkRzhnYldGclpTQjFjMlVnYjJZZ1UxRk1JSFJvYVc1bmN5QnNhV3RsSUhOMGIzSmxaQ0J3Y205alpXUjENCj4gY21WeklDd2dkMlVnYW5WemRDQjNZVzUwSUhSdklIUnlaV0YwSUdsMElHRnpJR0VnWkdGMFlTQmtkVzF3SUdadmNpQjBhR1VnYlc5dA0KPiBaVzUwTGcwS0RRcFRieUJoWm5SbGNpQjFjMmx1WnlCV1JsQllMMVZ3YzJsNmFXNW5WMmw2WVhKa0lHOTFjaUJwYm1sMGFXRnNJSFJvDQo+IGIzVm5hSFJ6SUdGeVpTQjBieUJ5WlhCc1lXTmxJSFJvWlNCc2IyTmhiQ0IyYVdWM0lIZHBkR2dnY21WdGIzUmxJSFpwWlhkeklHRnUNCj4gWkNCMGFHVnVJR052Ym5ScGJuVmxJSGRwZEdnZ2RHaGxJR04xY25KbGJuUWdiV1YwYUc5a0lHOW1JRU5TVlVRZ2RtbGhJSFJvWlNCMg0KPiBhV1YzY3k0TkNnMEtRVzU1ZEdocGJtY2dlVzkxSUdabFpXd2dhWE1nZDI5eWRHZ2dZU0JvWldGa2N5QjFjQ0J2YmlCbWIzSWdkWE1nDQo+IGRHOGdZMjl1YzJsa1pYSWdZbVZtYjNKbElIZGxJR2RsZENCdmJpQjNhWFJvSUdsMFB3MEtEUXBTWldkaGNtUnpEUW9OQ2tOb2NtbHoNCj4gRFFwZlgxOWZYMTlmWDE5ZlgxOWZYMTlmWDE5ZlgxOWZYMTlmWDE5ZlgxOWZYMTlmWDE5ZlgxOWZYMTlmWDE5Zlh3MEtVRzl6ZENCTg0KPiBaWE56WVdkbGN5QjBiem9nVUhKdlJtOTRRR3hsWVdabExtTnZiVHh0WVdsc2RHODZVSEp2Um05NFFHeGxZV1psTG1OdmJUNE5DbE4xDQo+IFluTmpjbWx3ZEdsdmJpQk5ZV2x1ZEdWdVlXNWpaVG9nYUhSMGNITTZMeTl0WVdsc0xteGxZV1psTG1OdmJTOXRZV2xzYldGdUwyeHANCj4gYzNScGJtWnZMM0J5YjJadmVEeG9kSFJ3Y3pvdkwzVnliQzUxY3k1dExtMXBiV1ZqWVhOMGNISnZkR1ZqZEM1amIyMHZjeTloTWtsdA0KPiBRMDA0UlRKS2RYRnNiMHRSVlZGMFZrZzRWVWRLY0Q5a2IyMWhhVzQ5YldGcGJDNXNaV0ZtWlM1amIyMCtEUXBQVkMxbWNtVmxJSFpsDQo+IGNuTnBiMjRnYjJZZ2RHaHBjeUJzYVhOME9pQm9kSFJ3Y3pvdkwyMWhhV3d1YkdWaFptVXVZMjl0TDIxaGFXeHRZVzR2YkdsemRHbHUNCj4gWm04dmNISnZabTk0ZEdWamFEeG9kSFJ3Y3pvdkwzVnliQzUxY3k1dExtMXBiV1ZqWVhOMGNISnZkR1ZqZEM1amIyMHZjeTh4UmtSVQ0KPiBRMDVyUlRKWlV6QlNia3N5WXpCMWIwaDVMVTFXYkQ5a2IyMWhhVzQ5YldGcGJDNXNaV0ZtWlM1amIyMCtEUXBUWldGeVkyaGhZbXhsDQo+IElFRnlZMmhwZG1VNklHaDBkSEJ6T2k4dmJHVmhabVV1WTI5dEwyRnlZMmhwZG1WelBHaDBkSEJ6T2k4dmRYSnNMblZ6TG0wdWJXbHQNCj4gWldOaGMzUndjbTkwWldOMExtTnZiUzl6THpGWFUzcERUMWxGTWxCMWNFZFFWalpUUVVOc1NFZFhUWFp3UDJSdmJXRnBiajFzWldGbQ0KPiBaUzVqYjIwK0RRcFVhR2x6SUcxbGMzTmhaMlU2SUdoMGRIQnpPaTh2YkdWaFptVXVZMjl0TDJGeVkyaHBkbVZ6TDJKNVRVbEVMMFJFDQo+IE1FVkJNMEkzTFRGRFJrRXRORUl5TlMwNVF6QXdMVEpCTkRSRFJFRTVORGhCUmtCaFkzUnZibWRoZEdVdVkyOHVkV3M4YUhSMGNITTYNCj4gTHk5MWNtd3VkWE11YlM1dGFXMWxZMkZ6ZEhCeWIzUmxZM1F1WTI5dEwzTXZiWHB3TjBOUVRrMDVla2xMYkVSWk4ybGFSakJJZUZOSg0KPiBXRGsvWkc5dFlXbHVQV3hsWVdabExtTnZiVDROQ2lvcUlFRnNiQ0J3YjNOMGFXNW5jeXdnZFc1c1pYTnpJR1Y0Y0d4cFkybDBiSGtnDQo+IGMzUmhkR1ZrSUc5MGFHVnlkMmx6WlN3Z1lYSmxJSFJvWlNCdmNHbHVhVzl1Y3lCdlppQjBhR1VnWVhWMGFHOXlMQ0JoYm1RZ1pHOGcNCj4gYm05MElHTnZibk4wYVhSMWRHVWdiR1ZuWVd3Z2IzSWdiV1ZrYVdOaGJDQmhaSFpwWTJVdUlGUm9hWE1nYzNSaGRHVnRaVzUwSUdseg0KPiBJR0ZrWkdWa0lIUnZJSFJvWlNCdFpYTnpZV2RsY3lCbWIzSWdkR2h2YzJVZ2JHRjNlV1Z5Y3lCM2FHOGdZWEpsSUhSdmJ5QnpkSFZ3DQo+IGFXUWdkRzhnYzJWbElIUm9aU0J2WW5acGIzVnpMZzBLDQo+DQo+DQo+IC0tLSBTdHJpcE1pbWUgUmVwb3J0IC0tIHByb2Nlc3NlZCBNSU1FIHBhcnRzIC0tLQ0KPiBtdWx0aXBhcnQvYWx0ZXJuYXRpdmUNCj4gdGV4dC9wbGFpbiAodGV4dCBib2R5IC0tIGtlcHQpDQo+IHRleHQvaHRtbA0KPiAtLS0NCj4NCltleGNlc3NpdmUgcXVvdGluZyByZW1vdmVkIGJ5IHNlcnZlcl0NCg0KX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NClBvc3QgTWVzc2FnZXMgdG86IFByb0ZveEBsZWFmZS5jb208bWFpbHRvOlByb0ZveEBsZWFmZS5jb20+DQpTdWJzY3JpcHRpb24gTWFpbnRlbmFuY2U6IGh0dHBzOi8vbWFpbC5sZWFmZS5jb20vbWFpbG1hbi9saXN0aW5mby9wcm9mb3g8aHR0cHM6Ly91cmwudXMubS5taW1lY2FzdHByb3RlY3QuY29tL3MvNGMxeUN2Mll6OGg3WE5ZSmZvdGdIUWZzWEg/ZG9tYWluPW1haWwubGVhZmUuY29tPg0KT1QtZnJlZSB2ZXJzaW9uIG9mIHRoaXMgbGlzdDogaHR0cHM6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3Byb2ZveHRlY2g8aHR0cHM6Ly91cmwudXMubS5taW1lY2FzdHByb3RlY3QuY29tL3MvUzJCZUN3cEVBS3VHcDhxNWk4dXpISkxlNDQ/ZG9tYWluPW1haWwubGVhZmUuY29tPg0KU2VhcmNoYWJsZSBBcmNoaXZlOiBodHRwczovL2xlYWZlLmNvbS9hcmNoaXZlczxodHRwczovL3VybC51cy5tLm1pbWVjYXN0cHJvdGVjdC5jb20vcy9oNmN5Q3hrVkIyUzFPTTdwZjJDb0h5QndObD9kb21haW49bGVhZmUuY29tPg0KVGhpcyBtZXNzYWdlOiBodHRwczovL2xlYWZlLmNvbS9hcmNoaXZlcy9ieU1JRC9DQUNXNm40dUR0Q2g4Rl9CODUwd3Biel9vQnNQTCtvbjlnTD1XbnNWPVFlc2hKQUFVNEFAbWFpbC5nbWFpbC5jb208aHR0cHM6Ly91cmwudXMubS5taW1lY2FzdHByb3RlY3QuY29tL3MvTWlYYUN5UDZEOVRyblg4R1R5RmdIeHN2MnY/ZG9tYWluPWxlYWZlLmNvbT4NCioqIEFsbCBwb3N0aW5ncywgdW5sZXNzIGV4cGxpY2l0bHkgc3RhdGVkIG90aGVyd2lzZSwgYXJlIHRoZSBvcGluaW9ucyBvZiB0aGUgYXV0aG9yLCBhbmQgZG8gbm90IGNvbnN0aXR1dGUgbGVnYWwgb3IgbWVkaWNhbCBhZHZpY2UuIFRoaXMgc3RhdGVtZW50IGlzIGFkZGVkIHRvIHRoZSBtZXNzYWdlcyBmb3IgdGhvc2UgbGF3eWVycyB3aG8gYXJlIHRvbyBzdHVwaWQgdG8gc2VlIHRoZSBvYnZpb3VzLg0K--- StripMime Report -- processed MIME parts ---multipart/alternative text/plain (text body -- kept) text/html---
I just turned 65. Clearly time to stop using computers and just tell people to get off my lawn.
What I said in reply to Ted was "You'd think I would remember to tell Lookout to use Plain text. But you'd think wrong..."
Thanks, Ted.
--
rk
:-D LOL!
On Monday, November 25th, 2024 at 10:06 AM, Richard Kaye rkaye@invaluable.com wrote:
I just turned 65. Clearly time to stop using computers and just tell people to get off my lawn.
What I said in reply to Ted was "You'd think I would remember to tell Lookout to use Plain text. But you'd think wrong..."
Thanks, Ted.
--
rk
[excessive quoting removed by server]
Were those encrypted ssns?
On Mon, Nov 25, 2024 at 9:07 AM Richard Kaye rkaye@invaluable.com wrote:
I just turned 65. Clearly time to stop using computers and just tell people to get off my lawn.
What I said in reply to Ted was "You'd think I would remember to tell Lookout to use Plain text. But you'd think wrong..."
Thanks, Ted.
--
rk
[excessive quoting removed by server]
No. Lookout's HTML format instead of plain text. No PPI; just VFP advice.
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Stephen Russell Sent: Tuesday, November 26, 2024 11:41 AM To: profoxtech@leafe.com Subject: Re: Database Migration Pointers
Were those encrypted ssns?
On Mon, Nov 25, 2024 at 9:07 AM Richard Kaye mailto:rkaye@invaluable.com wrote:
I just turned 65. Clearly time to stop using computers and just tell people to get off my lawn.
What I said in reply to Ted was "You'd think I would remember to tell Lookout to use Plain text. But you'd think wrong..."
Thanks, Ted.
--
rk
[excessive quoting removed by server]
_______________________________________________ Post Messages to: mailto:ProFox@leafe.com Subscription Maintenance: https://url.us.m.mimecastprotect.com/s/1ME4COYE2PupGLPDcPtlHG8kMU?domain=mai... OT-free version of this list: https://url.us.m.mimecastprotect.com/s/AWzPCPNM9zIKl1DBiru0Hx0LCf?domain=mai... Searchable Archive: https://url.us.m.mimecastprotect.com/s/vMTiCQWN26Hkx1DnS9CEHG1Hef?domain=lea... This message: https://url.us.m.mimecastprotect.com/s/Su-9CR6M0PhvVDKwC0F3H1mD0i?domain=lea... ** 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.
What Stephen? Encrypted Social Security #'s??
Really?
That's pretty funny!!!
But, hey - it's Great to see you popping your head up in here Stephen. As I too on occasion do...
L8r G8rs, -Kurt https://gofund.me/898257a9
On Fri, Nov 29, 2024 at 5:04 AM Stephen Russell srussell705@gmail.com wrote:
Were those encrypted ssns?
On Mon, Nov 25, 2024 at 9:07 AM Richard Kaye rkaye@invaluable.com wrote:
I just turned 65. Clearly time to stop using computers and just tell people to get off my lawn.
What I said in reply to Ted was "You'd think I would remember to tell Lookout to use Plain text. But you'd think wrong..."
Thanks, Ted.
--
rk
[excessive quoting removed by server]
I'm getting these encoded, so don't know what they say.
On Monday, November 25th, 2024 at 10:02 AM, Richard Kaye rkaye@invaluable.com wrote:
WW914oCZZCB0aGluayBieSBub3cgSSB3b3VsZCByZW1lbWJlciB0byBtYWtlIHN1cmUgTG9va291 dCB1c2VzIHBsYWluIHRleHQuIEJ1dCB5b3XigJlkIHRoaW5rIHdyb25nLi4NCg0KVGhhbmtzLCBU ZWQuDQoNCi0tDQoNCnJrDQoNCkZyb206IFByb2ZveFRlY2ggPHByb2ZveHRlY2gtYm91bmNlc0Bs ZWFmZS5jb20+IE9uIEJlaGFsZiBPZiBUZWQgUm9jaGUNClNlbnQ6IE1vbmRheSwgTm92ZW1iZXIg MjUsIDIwMjQgNzo0MiBBTQ0KVG86IHByb2ZveHRlY2hAbGVhZmUuY29tDQpDYzogcHJvZm94dGVj aEBsZWFmZS5jb20NClN1YmplY3Q6IFJlOiBEYXRhYmFzZSBNaWdyYXRpb24gUG9pbnRlcnMNCg0K V2hhdCBSaWNoYXJkIHNhaWQhIEl0IHRyYW5zbGF0ZXMgdG86DQoNCk1ha2Ugc3VyZSB5b3UgYXJl IHVzaW5nIHRoZSBsYXRlc3QgdmVyc2lvbiBvZiB0aGUgVVcgd2hpY2ggaXMNCmF2YWlsYWJsZSBm cm9tIFZGUFguIEEgbG90IG9mIHF1aXJrcyBoYXZlIGJlZW4gZml4ZWQgYW5kIGl04oCZcyBhbHNv DQptdWNoIGZhc3Rlci4NClRoZSB1cHNpemluZyB3aXphcmQgd2lsbCBjcmVhdGUgdGhlIHJlbW90 ZSB2aWV3cyBmb3IgeW91Lg0KVGhlcmXigJlzIG5vIHN1Y2ggdGhpbmcgYXMgYW4gZW1wdHkgZGF0 ZSBpbiBTUUwgc28gaWYgeW91IGhhdmUgdGhlbSBpbg0KeW91ciBWRlAgZGF0YSB5b3UgaGF2ZSBz b21lIGNob2ljZXMuDQpJIGhpZ2hseSByZWNvbW1lbmQgcmVhZGluZyB0aGUgZmluZSBtYW51YWwu IPCfmIoNCg0KLS0NCg0KcmsNCg0KT24gTW9uLCBOb3YgMjUsIDIwMjQgYXQgNzozNOKAr0FNIFJp Y2hhcmQgS2F5ZSA8cmtheWVAaW52YWx1YWJsZS5jb208bWFpbHRvOnJrYXllQGludmFsdWFibGUu Y29tPj4gd3JvdGU6DQo+DQo+IFRXRnJaU0J6ZFhKbElIbHZkU0JoY21VZ2RYTnBibWNnZEdobElH eGhkR1Z6ZENCMlpYSnphVzl1SUc5bUlIUm9aU0JWVnlCM2FHbGoNCj4gYUNCcGN5QmhkbUZwYkdG aWJHVWdabkp2YlNCV1JsQllMaUJCSUd4dmRDQnZaaUJ4ZFdseWEzTWdhR0YyWlNCaVpXVnVJR1pw ZUdWaw0KPiBJR0Z1WkNCcGRPS0FtWE1nWVd4emJ5QnRkV05vSUdaaGMzUmxjaTROQ2xSb1pTQjFj SE5wZW1sdVp5QjNhWHBoY21RZ2QybHNiQ0JqDQo+IGNtVmhkR1VnZEdobElISmxiVzkwWlNCMmFX VjNjeUJtYjNJZ2VXOTFMZzBLVkdobGNtWGlnSmx6SUc1dklITjFZMmdnZEdocGJtY2cNCj4gWVhN Z1lXNGdaVzF3ZEhrZ1pHRjBaU0JwYmlCVFVVd2djMjhnYVdZZ2VXOTFJR2hoZG1VZ2RHaGxiU0Jw YmlCNWIzVnlJRlpHVUNCaw0KPiBZWFJoSUhsdmRTQm9ZWFpsSUhOdmJXVWdZMmh2YVdObGN5NE5D a2tnYUdsbmFHeDVJSEpsWTI5dGJXVnVaQ0J5WldGa2FXNW5JSFJvDQo+IFpTQWdabWx1WlNCdFlX NTFZV3d1SVBDZm1Jb05DZzBLTFMwTkNnMEtjbXNOQ2cwS1JuSnZiVG9nVUhKdlptOTRWR1ZqYUNB OGNISnYNCj4gWm05NGRHVmphQzFpYjNWdVkyVnpRR3hsWVdabExtTnZiVDRnVDI0Z1FtVm9ZV3ht SUU5bUlFTm9jbWx6SUVSaGRtbHpEUXBUWlc1MA0KPiBPaUJUZFc1a1lYa3NJRTV2ZG1WdFltVnlJ REkwTENBeU1ESTBJRGs2TkRJZ1FVME5DbFJ2T2lCd2NtOW1iM2gwWldOb1FHeGxZV1psDQo+IExt TnZiUTBLVTNWaWFtVmpkRG9nUkdGMFlXSmhjMlVnVFdsbmNtRjBhVzl1SUZCdmFXNTBaWEp6RFFv TkNraHBJRUZzYkEwS0RRcEMNCj4gWldadmNtVWdkMlVnYzNSaGNuUWdkR2hwY3lCcWRYTjBJR1pw WjNWeVpXUWdhWFFnZDI5MWJHUWdiV0ZyWlNCelpXNXpaU0IwYnlCeQ0KPiBaV0ZqYUNCdmRYUWdk RzhnZVc5MUlHZDFlWE1nWm05eUlHRnVlU0JuWlc1bGNtRnNJR0ZrZG1salpTQnZjaUJ3YjJsdWRH VnljeUI1DQo+IGIzVWdZMkZ1SUdkcGRtVXVEUW9OQ2xkbElHaGhkbVVnWVNCMGVYQnBZMkZzSUcx MWJIUnBkWE5sY2lCV1JsQWdZWEJ3YkdsallYUnANCj4gYjI0Z2RYTnBibWNnWVNCRVFrTWdkMmww YUNCRVFrYmlnSmx6SUdGdVpDQnNiMk5oYkNCMmFXVjNjeTROQ2cwS1ZHaGxJR1p2Y20xeg0KPiBJ SFJvWVhRZ2FXNTBaWEpoWTNRZ2QybDBhQ0IwYUdseklHUmhkR0VnWVd4c0lHaGhkbVVnWVNCRVJT QmhibVFnWm05eUlIUm9aU0JrDQo+IFpYQnNiM2xsWkNCMlpYSnphVzl1Y3lCM1pTQm9ZWFpsSUVS UVFWUklUVWRTSUhOdmNuUnBibWNnZEdobElFUkZJSEJoZEdoeklHOTENCj4gZENCdFlXdHBibWNn WlhabGNubDBhR2x1WnlCM2IzSnJMZzBLRFFwWFpTQm9ZWFpsSUc1dklHbHRiV1ZrYVdGMFpTQnVa V1ZrSUhSdg0KPiBJR05vWVc1blpTQmhibmwwYUdsdVp5QmhZbTkxZENCbWNtOXRJR1p5YjI1MElH VnVaQ0FzSUdsMDRvQ1pjeUJ5Wld4aGRHbDJaV3g1DQo+IElITjBjbUZwWjJoMElHWnZjbmRoY21R Z1lXNWtJRzF2YzNRZ2IyWWdkR2hsSUdOdlpHVWdhWE1nWW1GelpXUWdZWEp2ZFc1a0lGUkINCj4g UWt4RlZWQkVRVlJGSUdGdVpDQlVRVUpNUlZKRlZrVlNWQzROQ2cwS1QzVnlJRzFwYzNOcGIyNGdh WE1nYW5WemRDQjBieUJzYjI5eg0KPiBaU0IwYUdVZ1JFSkdjeUJoYm1RZ2JXOTJaU0IwYUdVZ1pH RjBZU0IwYnlCVFVVd2dZWE1nYjNWeUlHWnBjbk4wSUhCaGMzTXVJRTV2DQo+IElHbHVkR1Z1ZEds dmJuTWdkRzhnYldGclpTQjFjMlVnYjJZZ1UxRk1JSFJvYVc1bmN5QnNhV3RsSUhOMGIzSmxaQ0J3 Y205alpXUjENCj4gY21WeklDd2dkMlVnYW5WemRDQjNZVzUwSUhSdklIUnlaV0YwSUdsMElHRnpJ R0VnWkdGMFlTQmtkVzF3SUdadmNpQjBhR1VnYlc5dA0KPiBaVzUwTGcwS0RRcFRieUJoWm5SbGNp QjFjMmx1WnlCV1JsQllMMVZ3YzJsNmFXNW5WMmw2WVhKa0lHOTFjaUJwYm1sMGFXRnNJSFJvDQo+ IGIzVm5hSFJ6SUdGeVpTQjBieUJ5WlhCc1lXTmxJSFJvWlNCc2IyTmhiQ0IyYVdWM0lIZHBkR2dn Y21WdGIzUmxJSFpwWlhkeklHRnUNCj4gWkNCMGFHVnVJR052Ym5ScGJuVmxJSGRwZEdnZ2RHaGxJ R04xY25KbGJuUWdiV1YwYUc5a0lHOW1JRU5TVlVRZ2RtbGhJSFJvWlNCMg0KPiBhV1YzY3k0TkNn MEtRVzU1ZEdocGJtY2dlVzkxSUdabFpXd2dhWE1nZDI5eWRHZ2dZU0JvWldGa2N5QjFjQ0J2YmlC bWIzSWdkWE1nDQo+IGRHOGdZMjl1YzJsa1pYSWdZbVZtYjNKbElIZGxJR2RsZENCdmJpQjNhWFJv SUdsMFB3MEtEUXBTWldkaGNtUnpEUW9OQ2tOb2NtbHoNCj4gRFFwZlgxOWZYMTlmWDE5ZlgxOWZY MTlmWDE5ZlgxOWZYMTlmWDE5ZlgxOWZYMTlmWDE5ZlgxOWZYMTlmWDE5Zlh3MEtVRzl6ZENCTg0K PiBaWE56WVdkbGN5QjBiem9nVUhKdlJtOTRRR3hsWVdabExtTnZiVHh0WVdsc2RHODZVSEp2Um05 NFFHeGxZV1psTG1OdmJUNE5DbE4xDQo+IFluTmpjbWx3ZEdsdmJpQk5ZV2x1ZEdWdVlXNWpaVG9n YUhSMGNITTZMeTl0WVdsc0xteGxZV1psTG1OdmJTOXRZV2xzYldGdUwyeHANCj4gYzNScGJtWnZM M0J5YjJadmVEeG9kSFJ3Y3pvdkwzVnliQzUxY3k1dExtMXBiV1ZqWVhOMGNISnZkR1ZqZEM1amIy MHZjeTloTWtsdA0KPiBRMDA0UlRKS2RYRnNiMHRSVlZGMFZrZzRWVWRLY0Q5a2IyMWhhVzQ5YldG cGJDNXNaV0ZtWlM1amIyMCtEUXBQVkMxbWNtVmxJSFpsDQo+IGNuTnBiMjRnYjJZZ2RHaHBjeUJz YVhOME9pQm9kSFJ3Y3pvdkwyMWhhV3d1YkdWaFptVXVZMjl0TDIxaGFXeHRZVzR2YkdsemRHbHUN Cj4gWm04dmNISnZabTk0ZEdWamFEeG9kSFJ3Y3pvdkwzVnliQzUxY3k1dExtMXBiV1ZqWVhOMGNI SnZkR1ZqZEM1amIyMHZjeTh4UmtSVQ0KPiBRMDVyUlRKWlV6QlNia3N5WXpCMWIwaDVMVTFXYkQ5 a2IyMWhhVzQ5YldGcGJDNXNaV0ZtWlM1amIyMCtEUXBUWldGeVkyaGhZbXhsDQo+IElFRnlZMmhw ZG1VNklHaDBkSEJ6T2k4dmJHVmhabVV1WTI5dEwyRnlZMmhwZG1WelBHaDBkSEJ6T2k4dmRYSnNM blZ6TG0wdWJXbHQNCj4gWldOaGMzUndjbTkwWldOMExtTnZiUzl6THpGWFUzcERUMWxGTWxCMWNF ZFFWalpUUVVOc1NFZFhUWFp3UDJSdmJXRnBiajFzWldGbQ0KPiBaUzVqYjIwK0RRcFVhR2x6SUcx bGMzTmhaMlU2SUdoMGRIQnpPaTh2YkdWaFptVXVZMjl0TDJGeVkyaHBkbVZ6TDJKNVRVbEVMMFJF DQo+IE1FVkJNMEkzTFRGRFJrRXRORUl5TlMwNVF6QXdMVEpCTkRSRFJFRTVORGhCUmtCaFkzUnZi bWRoZEdVdVkyOHVkV3M4YUhSMGNITTYNCj4gTHk5MWNtd3VkWE11YlM1dGFXMWxZMkZ6ZEhCeWIz UmxZM1F1WTI5dEwzTXZiWHB3TjBOUVRrMDVla2xMYkVSWk4ybGFSakJJZUZOSg0KPiBXRGsvWkc5 dFlXbHVQV3hsWVdabExtTnZiVDROQ2lvcUlFRnNiQ0J3YjNOMGFXNW5jeXdnZFc1c1pYTnpJR1Y0 Y0d4cFkybDBiSGtnDQo+IGMzUmhkR1ZrSUc5MGFHVnlkMmx6WlN3Z1lYSmxJSFJvWlNCdmNHbHVh Vzl1Y3lCdlppQjBhR1VnWVhWMGFHOXlMQ0JoYm1RZ1pHOGcNCj4gYm05MElHTnZibk4wYVhSMWRH VWdiR1ZuWVd3Z2IzSWdiV1ZrYVdOaGJDQmhaSFpwWTJVdUlGUm9hWE1nYzNSaGRHVnRaVzUwSUds eg0KPiBJR0ZrWkdWa0lIUnZJSFJvWlNCdFpYTnpZV2RsY3lCbWIzSWdkR2h2YzJVZ2JHRjNlV1Z5 Y3lCM2FHOGdZWEpsSUhSdmJ5QnpkSFZ3DQo+IGFXUWdkRzhnYzJWbElIUm9aU0J2WW5acGIzVnpM ZzBLDQo+DQo+DQo+IC0tLSBTdHJpcE1pbWUgUmVwb3J0IC0tIHByb2Nlc3NlZCBNSU1FIHBhcnRz IC0tLQ0KPiBtdWx0aXBhcnQvYWx0ZXJuYXRpdmUNCj4gdGV4dC9wbGFpbiAodGV4dCBib2R5IC0t IGtlcHQpDQo+IHRleHQvaHRtbA0KPiAtLS0NCj4NCltleGNlc3NpdmUgcXVvdGluZyByZW1vdmVk IGJ5IHNlcnZlcl0NCg0KX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX18NClBvc3QgTWVzc2FnZXMgdG86IFByb0ZveEBsZWFmZS5jb208bWFpbHRvOlByb0ZveEBs ZWFmZS5jb20+DQpTdWJzY3JpcHRpb24gTWFpbnRlbmFuY2U6IGh0dHBzOi8vbWFpbC5sZWFmZS5j b20vbWFpbG1hbi9saXN0aW5mby9wcm9mb3g8aHR0cHM6Ly91cmwudXMubS5taW1lY2FzdHByb3Rl Y3QuY29tL3MvNGMxeUN2Mll6OGg3WE5ZSmZvdGdIUWZzWEg/ZG9tYWluPW1haWwubGVhZmUuY29t Pg0KT1QtZnJlZSB2ZXJzaW9uIG9mIHRoaXMgbGlzdDogaHR0cHM6Ly9tYWlsLmxlYWZlLmNvbS9t YWlsbWFuL2xpc3RpbmZvL3Byb2ZveHRlY2g8aHR0cHM6Ly91cmwudXMubS5taW1lY2FzdHByb3Rl Y3QuY29tL3MvUzJCZUN3cEVBS3VHcDhxNWk4dXpISkxlNDQ/ZG9tYWluPW1haWwubGVhZmUuY29t Pg0KU2VhcmNoYWJsZSBBcmNoaXZlOiBodHRwczovL2xlYWZlLmNvbS9hcmNoaXZlczxodHRwczov L3VybC51cy5tLm1pbWVjYXN0cHJvdGVjdC5jb20vcy9oNmN5Q3hrVkIyUzFPTTdwZjJDb0h5QndO bD9kb21haW49bGVhZmUuY29tPg0KVGhpcyBtZXNzYWdlOiBodHRwczovL2xlYWZlLmNvbS9hcmNo aXZlcy9ieU1JRC9DQUNXNm40dUR0Q2g4Rl9CODUwd3Biel9vQnNQTCtvbjlnTD1XbnNWPVFlc2hK QUFVNEFAbWFpbC5nbWFpbC5jb208aHR0cHM6Ly91cmwudXMubS5taW1lY2FzdHByb3RlY3QuY29t L3MvTWlYYUN5UDZEOVRyblg4R1R5RmdIeHN2MnY/ZG9tYWluPWxlYWZlLmNvbT4NCioqIEFsbCBw b3N0aW5ncywgdW5sZXNzIGV4cGxpY2l0bHkgc3RhdGVkIG90aGVyd2lzZSwgYXJlIHRoZSBvcGlu aW9ucyBvZiB0aGUgYXV0aG9yLCBhbmQgZG8gbm90IGNvbnN0aXR1dGUgbGVnYWwgb3IgbWVkaWNh bCBhZHZpY2UuIFRoaXMgc3RhdGVtZW50IGlzIGFkZGVkIHRvIHRoZSBtZXNzYWdlcyBmb3IgdGhv c2UgbGF3eWVycyB3aG8gYXJlIHRvbyBzdHVwaWQgdG8gc2VlIHRoZSBvYnZpb3VzLg0K
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Besides what the others said in code and uncoded messages (lol), I recall having to have the remote views database locally (instead of a common location on the network) due to VFP locking something which would cause issues.
Good luck! --Michael
On 11/24/2024 9:42 AM, Chris Davis wrote:
Hi All
Before we start this just figured it would make sense to reach out to you guys for any general advice or pointers you can give.
We have a typical multiuser VFP application using a DBC with DBF’s and local views.
The forms that interact with this data all have a DE and for the deployed versions we have DPATHMGR sorting the DE paths out making everything work.
We have no immediate need to change anything about from front end , it’s relatively straight forward and most of the code is based around TABLEUPDATE and TABLEREVERT.
Our mission is just to loose the DBFs and move the data to SQL as our first pass. No intentions to make use of SQL things like stored procedures , we just want to treat it as a data dump for the moment.
So after using VFPX/UpsizingWizard our initial thoughts are to replace the local view with remote views and then continue with the current method of CRUD via the views.
Anything you feel is worth a heads up on for us to consider before we get on with it?
Regards
Chris
[excessive quoting removed by server]
There's a Hentzenwerke book about upsizing your apps to MySQL. It covers a lot of the little gotchas. If you poke around I bet there's a copy floating around somewhere.
Eric
On Fri, Nov 29, 2024 at 3:52 PM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
Besides what the others said in code and uncoded messages (lol), I recall having to have the remote views database locally (instead of a common location on the network) due to VFP locking something which would cause issues.
Good luck! --Michael
On 11/24/2024 9:42 AM, Chris Davis wrote:
Hi All
Before we start this just figured it would make sense to reach out to
you guys for any general advice or pointers you can give.
We have a typical multiuser VFP application using a DBC with DBF’s and
local views.
The forms that interact with this data all have a DE and for the
deployed versions we have DPATHMGR sorting the DE paths out making everything work.
We have no immediate need to change anything about from front end , it’s
relatively straight forward and most of the code is based around TABLEUPDATE and TABLEREVERT.
Our mission is just to loose the DBFs and move the data to SQL as our
first pass. No intentions to make use of SQL things like stored procedures , we just want to treat it as a data dump for the moment.
So after using VFPX/UpsizingWizard our initial thoughts are to replace
the local view with remote views and then continue with the current method of CRUD via the views.
Anything you feel is worth a heads up on for us to consider before we
get on with it?
Regards
Chris
[excessive quoting removed by server]
When I had to upsize to M$ SQL I developed a set of triggers that actioned the SQL updates as they occurred in the Fox DB files. This meant that I was running with two sets of data for ease of use and I gradually dropped the .dbf files once the data in SQL DB was confirmed to be correct. It worked well with little if no speed penalty. I can dig out the trigger procedures if you want. Dave
On Mon, 2 Dec 2024, 13:10 Eric Selje, Eric@saltydogllc.com wrote:
There's a Hentzenwerke book about upsizing your apps to MySQL. It covers a lot of the little gotchas. If you poke around I bet there's a copy floating around somewhere.
Eric
On Fri, Nov 29, 2024 at 3:52 PM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
Besides what the others said in code and uncoded messages (lol), I recall having to have the remote views database locally (instead of a common location on the network) due to VFP locking something which would cause issues.
Good luck! --Michael
On 11/24/2024 9:42 AM, Chris Davis wrote:
Hi All
Before we start this just figured it would make sense to reach out to
you guys for any general advice or pointers you can give.
We have a typical multiuser VFP application using a DBC with DBF’s and
local views.
The forms that interact with this data all have a DE and for the
deployed versions we have DPATHMGR sorting the DE paths out making everything work.
We have no immediate need to change anything about from front end ,
it’s
relatively straight forward and most of the code is based around TABLEUPDATE and TABLEREVERT.
Our mission is just to loose the DBFs and move the data to SQL as our
first pass. No intentions to make use of SQL things like stored
procedures
, we just want to treat it as a data dump for the moment.
So after using VFPX/UpsizingWizard our initial thoughts are to replace
the local view with remote views and then continue with the current
method
of CRUD via the views.
Anything you feel is worth a heads up on for us to consider before we
get on with it?
Regards
Chris
[excessive quoting removed by server]
Please Dave if you don’t mind, I guess that was followed by code changes once the .dbf was dropped to update SQL direct?
Regards
Chris.
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Dave Crozier Sent: 18 December 2024 11:58 To: profoxtech@leafe.com Subject: Re: Database Migration Pointers
When I had to upsize to M$ SQL I developed a set of triggers that actioned the SQL updates as they occurred in the Fox DB files. This meant that I was running with two sets of data for ease of use and I gradually dropped the .dbf files once the data in SQL DB was confirmed to be correct. It worked well with little if no speed penalty. I can dig out the trigger procedures if you want. Dave
On Mon, 2 Dec 2024, 13:10 Eric Selje, Eric@saltydogllc.com wrote:
There's a Hentzenwerke book about upsizing your apps to MySQL. It covers a lot of the little gotchas. If you poke around I bet there's a copy floating around somewhere.
Eric
On Fri, Nov 29, 2024 at 3:52 PM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
Besides what the others said in code and uncoded messages (lol), I recall having to have the remote views database locally (instead of a common location on the network) due to VFP locking something which would cause issues.
Good luck! --Michael
On 11/24/2024 9:42 AM, Chris Davis wrote:
Hi All
Before we start this just figured it would make sense to reach out to
you guys for any general advice or pointers you can give.
We have a typical multiuser VFP application using a DBC with DBF’s and
local views.
The forms that interact with this data all have a DE and for the
deployed versions we have DPATHMGR sorting the DE paths out making everything work.
We have no immediate need to change anything about from front end ,
it’s
relatively straight forward and most of the code is based around TABLEUPDATE and TABLEREVERT.
Our mission is just to loose the DBFs and move the data to SQL as our
first pass. No intentions to make use of SQL things like stored
procedures
, we just want to treat it as a data dump for the moment.
So after using VFPX/UpsizingWizard our initial thoughts are to replace
the local view with remote views and then continue with the current
method
of CRUD via the views.
Anything you feel is worth a heads up on for us to consider before we
get on with it?
Regards
Chris
[excessive quoting removed by server]
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CA+=YCLW3JGnrSXOPfNT7=u+dAtWrvBg9aoM3_590yS... ** 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.
Yes, the triggers can be controlled and turned on/off when the SQL solution has been validated. Removing the VFP specific features leaves the functionality intact and your conversion is done!
I had just over 1300 programs to convert and test which took about 4 months once I had defined the logic to apply.
Dave
On Thu, 19 Dec 2024, 12:47 Chris Davis, chrisd@actongate.co.uk wrote:
Please Dave if you don’t mind, I guess that was followed by code changes once the .dbf was dropped to update SQL direct?
Regards
Chris.
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Dave Crozier Sent: 18 December 2024 11:58 To: profoxtech@leafe.com Subject: Re: Database Migration Pointers
When I had to upsize to M$ SQL I developed a set of triggers that actioned the SQL updates as they occurred in the Fox DB files. This meant that I was running with two sets of data for ease of use and I gradually dropped the .dbf files once the data in SQL DB was confirmed to be correct. It worked well with little if no speed penalty. I can dig out the trigger procedures if you want. Dave
On Mon, 2 Dec 2024, 13:10 Eric Selje, Eric@saltydogllc.com wrote:
There's a Hentzenwerke book about upsizing your apps to MySQL. It covers a lot of the little gotchas. If you poke around I bet there's a copy floating around somewhere.
Eric
On Fri, Nov 29, 2024 at 3:52 PM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
Besides what the others said in code and uncoded messages (lol), I recall having to have the remote views database locally (instead of a common location on the network) due to VFP locking something which would cause issues.
Good luck! --Michael
On 11/24/2024 9:42 AM, Chris Davis wrote:
Hi All
Before we start this just figured it would make sense to reach out to
you guys for any general advice or pointers you can give.
We have a typical multiuser VFP application using a DBC with DBF’s and
local views.
The forms that interact with this data all have a DE and for the
deployed versions we have DPATHMGR sorting the DE paths out making everything work.
We have no immediate need to change anything about from front end ,
it’s
relatively straight forward and most of the code is based around TABLEUPDATE and TABLEREVERT.
Our mission is just to loose the DBFs and move the data to SQL as our
first pass. No intentions to make use of SQL things like stored
procedures
, we just want to treat it as a data dump for the moment.
So after using VFPX/UpsizingWizard our initial thoughts are to replace
the local view with remote views and then continue with the current
method
of CRUD via the views.
Anything you feel is worth a heads up on for us to consider before we
get on with it?
Regards
Chris
[excessive quoting removed by server]
-
Chris Davis -
Dave Crozier -
Eric Selje -
Kurt Wendt -
MB Software Solutions, LLC -
Richard Kaye -
Stephen Russell -
Ted Roche -
Vincent Teachout