ProFox

profox@leafe.com

2704 discussions

[NF] Windows 10 for less than $54!
by mbsoftwaresolutions＠mbsoftwaresolutions.com 16 Jun '16

16 Jun '16

Awhile back I ordered Win 7 Pro from Amazon and paid $54. Upon installation, it upgraded on demand to Win 10. :-) Cart Items SKU Qty Item Price Item Total Microsoft Windows 7 Professional 64 Bit Download (Download Files) PG-FQC00734S (291) 1 $53.98 USD $53.98 USD Subtotal: $53.98 USD Grand Total: $53.98 USD Just a heads up in case you needed to go that route.

5 14

A Blank Value for a Number?
by Kurt Wendt 16 Jun '16

16 Jun '16

I know - it's a Crazy request. Trying to figure out the Easiest way to try and do this - and hoping to Avoid having to do more complicated solutions like Office Automation to manipulate an Excel file. So - here's the deal. This system I work on - it outputs this Excel file. And, in the past - if there are certain records that have a Zero in a particular column - they would Manually wipe out the Zero - and also blank out several of the other fields in that Row. But, the new request is to make those things happen automatically during process when the Excel file gets exported. So that they do NOT have to manually blank out certain fields. But, of course, therein lies the problem. For the other rows of data - this particular field is supposed to be a numeric value. And, AFAIK - there really is NO Way to have a DBF or Cursor that has a Numeric field - and yet have blank values in it. As such, I suspect the answer is that this can't be done - to have a numeric data field hold any kind of blank data. They even suggested just a Dash. But, again - I figured it's not possible. However, I figured for the hell of it - I would post here - in case someone had an interesting insight that I hadn't thought of... Kurt Wendt Senior Systems Analyst [GlobeTax_SecondaryLogo_TwoColor_Lo]<https://www.globetax.com/> One New York Plaza - 34th Floor New York, NY 10004-1936, USA Tel. +1-212-747-9100 Direct +1-212-405-8246 www.GlobeTax.com<https://www.globetax.com/> GlobeTax does not provide or offer, and this is not, tax, investment or legal advice. This email and any attachments hereto is intended only for use by the addressee(s) and may contain confidential information. If you are not the intended recipient of this email, please immediately notify the sender at +1-212-747-9100 and permanently delete the original and any copies of this email. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png ---

8 21

InteractiveChange and ProgrammaticChange Oddness
by Ken Dibble 16 Jun '16

16 Jun '16

Hi folks, There are actually two odd issues here, but the second one, for which this subject is named, seems even stranger than the first: First Issue I have a textbox, in whose Init() I have this: THIS.AddProperty("OldValue",{}) THIS.Value = {} (Let's leave aside, for now, that I could set the default value in the property sheet instead of doing this, and I could use the Format property to enforce good Date types. I don't do that, and haven't in nearly 10 years of use.) There are some programmatic methods that can set this textbox's value to a Date coming from a Date field in one specific table without any "translation", or to an empty date, as I do above. The table does not accept NULLs. The InteractiveChange() method of this control (fires when the user is typing in the control) will compare THIS.Value to THIS.OldValue and if they are not the same, THIS.Value will be copied to THIS.OldValue, like so: IF THIS.Value <> THIS.OldValue THIS.OldValue = THIS.Value ENDIF There is identical code in the control's ProgrammaticChange() method, so that the two properties are kept in synch when some other piece of code changes the control's Value. I have verified that no code ever can change the control's Value or OldValue properties to anything that is not a Date. I have also confirmed that there is no somehow corrupted value in the relevant table's date column that is not a valid Date data type. Further, if the user tries to type anything other than a digit or a slash into the control, nothing happens, including that the InteractiveChange() code does not run. The cursor just sits there, waiting for the user to type a valid character. (Not directly relevant but just in case you ask, I also can confirm that the standard un-trappable "Bad date" error will occur if the user's entry consists only of dights and slashes that do not correspond to a valid date.) This is ancient code and it has not been changed in many, many years. But today, for the first time (at least since my program started emailing me when it crashes about a year ago) the line: IF THIS.Value <> THIS.OldValue triggered Error 107 ("Operator/operand type mismatch") in the InteractiveChange() method. That is the first odd issue. I cannot figure out for the life of me how that could happen. Second Issue The code in the InteractiveChange() and ProgrammaticChange() methods of this textbox was originally identical. In order to add an error handler that displays a message, resets the values to empty dates, and does not crash the program, I added: IF TYPE("THIS.Value") <> "D" OR TYPE("THIS.OldValue") <> "D" *Issue some message THIS.Value = {} THIS.OldValue = {} ENDIF to the InteractiveChange() method before it gets to the property value-comparison line. Then I inserted THIS.Value = "Foobar" Above that block to test my change and ran the program. I began typing into the textbox. I immediately got Error 107 from the **ProgrammaticChange()** method. 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 ProgrammaticChange() method, where Error 107 occurred on: IF THIS.Value <> THIS.OldValue ???? I don't believe that InteractiveChange() is supposed to call ProgrammaticChange() or vice-versa. That's why there are two separate methods. I have often said that the VFP order of events does not always proceed as advertised, and I guess here is proof. Any thoughts? Thanks and I hope you are amused. Ken Dibble www.stic-cil.org

4 6

[NF] Looking to Python Data manipulation?
by Stephen Russell 16 Jun '16

16 Jun '16

Book DescriptionPython for Data Analysis is concerned with the nuts and bolts of manipulating, processing, cleaning, and crunching data in Python. It is also a practical, modern introduction to scientific computing in Python, tailored for data-intensive applications. This is a book about the parts of the Python language and libraries you'll need to effectively solve a broad set of data analysis problems. This book is not an exposition on analytical methods using Python as the implementation language. http://it-ebooks.info/book/1041/ -- 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 ---

1 0

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

15 Jun '16

Oh I have a facebook account. It just goes nowhere near other logins Al -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Gene Wirchenko Sent: 15 June 2016 19:22 To: profoxtech(a)leafe.com Subject: RE: [NF] you know it is coming At 02:16 2016-06-15, "Allen Pollard" <profox(a)gatwicksoftware.com> wrote: >Too right. All these sites that say sign on with facebook too. No way I have protection. I tried to sign up on Facebook so that I could find out when my local uni's games club met. The sign-up failed. Why, I do not know.

1 0

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

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox