ProFox June 2016

profox@leafe.com

56 participants
61 discussions

Re: InteractiveChange and ProgrammaticChange Oddness
by Ken Dibble 15 Jun '16

15 Jun '16

>>Yes, I had only made the change in the InteractiveChange() method. >>But I expected that method to generate the error message. Instead, >>somehow, when I started typing, InteractiveChange() ran to the >>point where I set the control's Value to a string, executed that >>line, and then, instead of generating the error message, execution >>somehow jumped to the > ^^^^^^^ > The ProgrammaticChange event "[O]ccurs when the value of a > control is changed in code." You just changed the value of the > control, so the event fired. Ah.... Of course. Brain flatulence. Having changed the code in both methods, my error handler works, so I'm satisfied. Issue One remains--but may never be solved. Thanks. Ken Dibble www.stic-cil.org

1 0

Re: [NF] you know it is coming
by Alan Bourke 15 Jun '16

15 Jun '16

Heh, good one. I guarantee the first thing I'll be doing in whatever MS Office version that has LinkedIn welded into it will be turning it off. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Wed, 15 Jun 2016, at 05:03 AM, Gene Wirchenko wrote: > At 10:55 2016-06-14, Stephen Russell <srussell705(a)gmail.com> wrote: > >https://twitter.com/dantz/status/742336999084961792 > > Such evil. > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server]

3 2

[NF] Windows 10 Comic
by Gene Wirchenko 15 Jun '16

15 Jun '16

Dear Foxes: Tired of Microsoft pushiness over Windows 10? http://www.sandraandwoo.com/2016/06/09/0793-an-offer-you-cant-refuse-ww/ Sincerely, Gene Wirchenko

1 0

Copying Triggers
by Dave Crozier 15 Jun '16

15 Jun '16

Ladies and Gentlemen, Anyone know if there is a way to copy triggers over to a new table without having to enquire into the DBC container? I have found that the triggers are held against each table in the DBC in the record with "objectname field" set to the name of the table, being held in the table "Property field" (Memo) so you can get at the contents of the triggers but I don't really want to have to do this if there is a table copy command or equivalent that does it for you. I am not simply being lazy here as copying this memo field over using scatter/gather doesn't always seem to transfer the correct trigger info over into the destination table. We have recently started making use of triggers to automatically insert records into a M$ table mirror of the VFP Table to aid in converting over from VFP tables to M$ SQL tables and the inability to copy triggers over has bit me in the proverbial "ass". We have a small tag call to a SQL master object that updates the SQL table whenever the VFP base table is updated (Insert/Update and Delete). Dave

5 16

Re: A Blank Value for a Number?
by foxdev 15 Jun '16

15 Jun '16

My understanding is numeric fields can hold blank values. Isn't that what the BLANK FIELD command and ISBLANK () is all about ? -------- Original message --------From: Dave Thayer <davethayer(a)gmail.com> Date: 15/06/2016 00:49 (GMT+02:00) To: profoxtech(a)leafe.com Subject: Re: A Blank Value for a Number? On Tue, Jun 14, 2016 at 3:41 PM, Kurt Wendt <Kurt_Wendt(a)globetax.com> wrote: > OK - part of the code in the system pulls data from MS SQL. So - I was trying to mod this code - to add NULL as an option into the Select. But, I suspect I'm not doing it correctly. Was looking around in online help - but, could not quickly find the answer. So - I took a shot at trying to implement this. This is only Part of the line of code - but, you can see the attempt to define NULL: > SELECT d.secid ,d.sec_name AS sec_nam ,d.coi AS issue_cnty , > t.taxrate_el NULL FROM [dbo].[Dividends] as d JOIN [dbo].[Trandata] as t > ON t.dividend_id = d.dividend_id > Maybe something like ...CASE WHEN t.taxrate_el = 0 THEN NULL ELSE t.taxrate_el END AS taxrate_el FROM .... -- Dave Thayer Denver, CO _______________________________________________ Post Messages to: ProFox(a)leafe.com 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/CAAo+qoWtM6-H+A1G9g8ZQQuT_39gF1eh8g+… ** 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. Report [OT] Abuse: http://leafe.com/reportAbuse/CAAo+qoWtM6-H+A1G9g8ZQQuT_39gF1eh8g+rpQKcMkBqv…

3 2

Re: A Blank Value for a Number?
by foxdev 15 Jun '16

15 Jun '16

SSBiZWxpZXZlIEJST1dTRSByZXNwZWN0cyBhbmQgbWFpbnRhaW5zIHRoZSBFTVBUWSAoKSBzdGF0ZS4KLS0tLS0tLS0gT3JpZ2luYWwgbWVzc2FnZSAtLS0tLS0tLUZyb206ICJXb2xsZW5oYXVwdCwgQ2hyaXN0b2YiIDxjaHJpc3RvZi53b2xsZW5oYXVwdEBmb3hwZXJ0LmNvbT4gRGF0ZTogMTUvMDYvMjAxNiAgMTQ6MTcgIChHTVQrMDI6MDApIFRvOiBwcm9mb3h0ZWNoQGxlYWZlLmNvbSBTdWJqZWN0OiBSZTogQSBCbGFuayBWYWx1ZSBmb3IgYSBOdW1iZXI/IApGb3hQcm8gc3VwcG9ydHMgYmxhbmsgdmFsdWVzIGluIERCRiBmaWxlcy4gTnVtZXJpYyB2YWx1ZXMgYXJlIGJsYW5rIGJ5CmRlZmF1bHQgYW5kIGNhbiBiZSBibGFua2VkIHVzaW5nIHRoZSBCTEFOSyBjb21tYW5kLiBUaGUgSVNCTEFOSygpIGZ1bmN0aW9uCnRlbGxzIHlvdSBpZiBhIG51bWVyaWMgZmllbGQgaXMgemVybyBvciBibGFuay4KCldoZW4geW91IHVzZSBHQVRIRVIsIFJFUExBQ0Ugb3IgSU5TRVJUIGFuZCBhIG1lbW9yeSB2YWx1ZSBpcyBwcmVzZW50IGZvcgp0aGlzIGNvbHVtbiwgdGhlbiB5b3UgZW5kIHVwIHdpdGggYSB6ZXJvIGluIHRoZSBjb2x1bW4uIFRvIG1haW50YWluIGEgYmxhbmsKdmFsdWUgeW91IG11c3Qgbm90IHdyaXRlIGFueXRoaW5nIGludG8gaXQsIGF0IGFsbC4gQW55IGtpbmQgb2YgVUkgYm91bmQKZWRpdGluZyB3aGV0aGVyIGluIEJST1dTRSwgRURJVCBvciBhcyBhIENvbnRyb2xTb3VyY2Ugd2lsbCBhbHNvIHJlc3VsdCBpbgp0aGUgZmllbGQgYmVjb21pbmcgemVyby4gVGhhdCdzIGJlY2F1c2Ugd2UgZG8gbm90IGhhdmUgYmxhbmsgdmFsdWVzIGluCm1lbW9yeS4KCldoZW4gb3RoZXIgc3lzdGVtcyByZWFkIERCRiBmaWxlcyBhbmQgZG8gbm90IGhhdmUgYSBjb25jZXB0IG9mIGJsYW5rCm51bWVyaWMgdmFsdWUsIHRoZW4gdXN1YWxseSB0aGUgYmxhbmsgZmllbGQgaXMgcmVwbGFjZWQgYnkgMCBmb3IgbnVtZXJpYwp2YWx1ZXMgb3Igc29tZSBtaW5pbXVtIGRhdGUgZm9yIGRhdGUgYW5kIHRpbWUgdmFsdWVzLgoKLk5VTEwuIGlzIHRoZSBzdGFuZGFyZCB3YXkgb2YgZG9pbmcgdGhpcyB3aXRoIGFsbW9zdCBhbnkgb3RoZXIgZGF0YWJhc2UKc3lzdGVtLCB0aG91Z2guCgotLSAKQ2hyaXN0b2YKCgotLS0gU3RyaXBNaW1lIFJlcG9ydCAtLSBwcm9jZXNzZWQgTUlNRSBwYXJ0cyAtLS0KbXVsdGlwYXJ0L2FsdGVybmF0aXZlCsKgIHRleHQvcGxhaW4gKHRleHQgYm9keSAtLSBrZXB0KQrCoCB0ZXh0L2h0bWwKLS0tCgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpQb3N0IE1lc3NhZ2VzIHRvOiBQcm9Gb3hAbGVhZmUuY29tClN1YnNjcmlwdGlvbiBNYWludGVuYW5jZTogaHR0cDovL21haWwubGVhZmUuY29tL21haWxtYW4vbGlzdGluZm8vcHJvZm94Ck9ULWZyZWUgdmVyc2lvbiBvZiB0aGlzIGxpc3Q6IGh0dHA6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3Byb2ZveHRlY2gKU2VhcmNoYWJsZSBBcmNoaXZlOiBodHRwOi8vbGVhZmUuY29tL2FyY2hpdmVzL3NlYXJjaC9wcm9mb3gKVGhpcyBtZXNzYWdlOiBodHRwOi8vbGVhZmUuY29tL2FyY2hpdmVzL2J5TUlEL3Byb2ZveC9DQUw0UUpoaGJONjZVOFJnZXZ1UDZHVlQrVlJvSmY5K0wzWnU9ZGo3NjUtM3ZBc1lqamdAbWFpbC5nbWFpbC5jb20KKiogQWxsIHBvc3RpbmdzLCB1bmxlc3MgZXhwbGljaXRseSBzdGF0ZWQgb3RoZXJ3aXNlLCBhcmUgdGhlIG9waW5pb25zIG9mIHRoZSBhdXRob3IsIGFuZCBkbyBub3QgY29uc3RpdHV0ZSBsZWdhbCBvciBtZWRpY2FsIGFkdmljZS4gVGhpcyBzdGF0ZW1lbnQgaXMgYWRkZWQgdG8gdGhlIG1lc3NhZ2VzIGZvciB0aG9zZSBsYXd5ZXJzIHdobyBhcmUgdG9vIHN0dXBpZCB0byBzZWUgdGhlIG9idmlvdXMuCgpSZXBvcnQgW09UXSBBYnVzZTogaHR0cDovL2xlYWZlLmNvbS9yZXBvcnRBYnVzZS9DQUw0UUpoaGJONjZVOFJnZXZ1UDZHVlQrVlJvSmY5K0wzWnU9ZGo3NjUtM3ZBc1lqamdAbWFpbC5nbWFpbC5jb20K--- StripMime Report -- processed MIME parts ---multipart/alternative text/plain (text body -- kept) text/html---

3 3

RE: [NF] you know it is coming
by foxdev 15 Jun '16

15 Jun '16

+1 -------- Original message --------From: Allen Pollard <profox(a)gatwicksoftware.com> Date: 15/06/2016 12:16 (GMT+02:00) To: profoxtech(a)leafe.com Subject: RE: [NF] you know it is coming Too right. All these sites that say sign on with facebook too. No way Al -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 15 June 2016 10:36 To: profoxtech(a)leafe.com Subject: Re: [NF] you know it is coming Heh, good one. I guarantee the first thing I'll be doing in whatever MS Office version that has LinkedIn welded into it will be turning it off. _______________________________________________ Post Messages to: ProFox(a)leafe.com 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/003401d1c6e6$a5674000$f035c000$@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. Report [OT] Abuse: http://leafe.com/reportAbuse/003401d1c6e6$a5674000$f035c000$@com

1 0

Re: [NF] you know it is coming
by Gene Wirchenko 15 Jun '16

15 Jun '16

At 10:55 2016-06-14, Stephen Russell <srussell705(a)gmail.com> wrote: >https://twitter.com/dantz/status/742336999084961792 Such evil. Sincerely, Gene Wirchenko

1 0

VFP9SP2 error trying to open project: "Project file ... is in the wrong version."
by mbsoftwaresolutions＠mbsoftwaresolutions.com 14 Jun '16

14 Jun '16

This project has been under VFP9SP2 for years now. Somehow, the PJX/PJT files must have gotten corrupted. We use SourceGear Vault for VCS. I'm going to grab that last saved project files from the Vault but I just wondered if anyone else has ever come across this error? I might try to manually hack the PJX table first. (The hesitation is that I'm not exactly sure the Vault has the latest PJX, although what's there should be 99.9% right.)

3 2

[NF] you know it is coming
by Stephen Russell 14 Jun '16

14 Jun '16

https://twitter.com/dantz/status/742336999084961792 -- 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 ---

2 1

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox June 2016