ProFox

profox@leafe.com

2704 discussions

Re: Declaring variable as "Empty" ???
by Gene Wirchenko 31 Jan '18

31 Jan '18

At 12:00 2018-01-30, Stephen Russell <srussell705(a)gmail.com> wrote: >Still trying to think of why you would use it. Likewise. If I want a data object, I usually also want methods. I subclass custom so I can have this. At the very least, I want the object initialised so I want .init(). Having to initialise outside of the object is not very OOP! [snip] Sincerely, Gene Wirchenko

1 0

Foxpro/Programming Training Question
by Paul H. Tarver 30 Jan '18

30 Jan '18

If you had an opportunity to teach a novice who is interested in learning programming in general and specifically with Visual Foxpro who has limited previous programming knowledge and experience, where would you start and are there some preferred VFP training materials/books/videos that are recommended. In my opinion there are two issues: 1) Basic Programming Skills and 2) VFP specific skills, and I'm interested in your suggestions in how to meet both of those needs. Plus if there are other issues, let me know that as well. Thanks in advance! Paul --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

11 15

RE: Foxpro/Programming Training Question
by Paul H. Tarver 29 Jan '18

29 Jan '18

Thanks Ken. I own a bunch of Hentzenwerke books and I too found them invaluable, but I read them as an experienced Foxpro programmer not a novice, so I use them more as reference material and for examples than anything else. In fact, on a recent project, I used a little book titled "Using SQLite to Bypass The 2 GB .DBF Filesize Limit" book by Whil Hentzen and edited by our very own Ted Roche to create a unique solution for a client I actually installed this morning (Thanks for the helpful hints Ted!). I too was self-taught starting with TRS-80 Basic, moving to GWBasic, Dbase II, FoxBase, Foxpro for Dos, VFP 6.0 and finally VFP 9.0. I'm able to read and understand C++, C#, Python and several other general purpose languages. I get that anyone can sit down with a manual or videos and learn how to write a "Hello, World!" program, but what I can't figure out is how to teach someone how to figure out a solution where no solution currently exists, or more likely, how to take a solution/example and re-purpose it to solve a different need. Anyway, sounds like we have similar backgrounds, and I'm glad to get to know you through this forum! Paul -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ken Dibble Sent: Friday, January 26, 2018 9:49 AM To: profoxtech(a)leafe.com Subject: Re: Foxpro/Programming Training Question >In my opinion there are two issues: 1) Basic Programming Skills and 2) >VFP specific skills, and I'm interested in your suggestions in how to >meet both of those needs. Plus if there are other issues, let me know that as well. I'm completely self-taught (and sometimes it shows). I don't have much to offer on basic programming skills. I played around with Basic in my youth briefly, and I got some formal instruction in C++ later in life but never used it to produce anything more than training exercises. I've briefly tinkered with Python--enough to convince myself that I could learn it if I had to, though I've never had to. But for VFP, I first taught myself dbXL using the examples in the manual, and when I had to move from DOS into Windows I taught myself VFP. The Hentzenwerke books were invaluable to me; I'm sure I never would have developed any real-world-usable skills without them. Especially: Hacker's Guide to Visual Foxpro 6.0 (THANKS TED!!!) The Fundamentals by Whil Hentzen Effective Techniques for Application Development with Visual Foxpro (Booth & Sawyer: RIP Ms. Booth) To a lesser extent: Advanced Object Oriented Programming with Visual Foxpro 6.0 - Marcus Egger Debugging Visual Foxpro Applications (Nancy Folsom; whatever happened to her?) Visual Foxpro Report Writer - Cathy Pountney Ken Dibble www.stic-cil.org [excessive quoting removed by server]

4 5

Re: Foxpro/Programming Training Question
by Ted Roche 27 Jan '18

27 Jan '18

On Sat, Jan 27, 2018 at 11:49 AM, Ken Dibble <krdibble(a)stny.rr.com> wrote: > >> > Hacker's Guide to Visual Foxpro 6.0 (THANKS TED!!!) >> >> Please thank Tamar. The book blurb said it was "exhaustive and >> irreverent." I was the irreverent part. By the time it shipped, Tamar >> was exhausted. > > > These days I get exhausted just lifting that mighty tome off from and onto > the bookshelf over my desk. We have a half-dozen of these around the office, and mostly use them to hold up monitors :) I say again, use the HTML-Help, Luke. May the Fox Be With You, Ted -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

1 0

Re: Foxpro/Programming Training Question
by Ken Dibble 27 Jan '18

27 Jan '18

> > Hacker's Guide to Visual Foxpro 6.0 (THANKS TED!!!) > >Please thank Tamar. The book blurb said it was "exhaustive and >irreverent." I was the irreverent part. By the time it shipped, Tamar >was exhausted. These days I get exhausted just lifting that mighty tome off from and onto the bookshelf over my desk. Thanks also to Tamar, whom I had the pleasure of meeting once. Ken

1 0

Re: Foxpro/Programming Training Question
by Ted Roche 27 Jan '18

27 Jan '18

On Fri, Jan 26, 2018 at 10:48 AM, Ken Dibble <krdibble(a)stny.rr.com> wrote: > > > Hacker's Guide to Visual Foxpro 6.0 (THANKS TED!!!) Please thank Tamar. The book blurb said it was "exhaustive and irreverent." I was the irreverent part. By the time it shipped, Tamar was exhausted. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

2 1

MariaDB
by Chris Davis 26 Jan '18

26 Jan '18

Hi All Just wondered if anyone out there is using MariaDB as a back end but using remote views in a DBC with it? I have a server working, a database and table created ... I can do "select * from mytable" using sqlexec but I can't create a remote view with the same table on. Any help you could give would be appreciated. Thanks Chris. ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 21

Re: Indexes on VFP tables--when do they get updated
by Gene Wirchenko 26 Jan '18

26 Jan '18

At 08:15 2018-01-25, mbsoftwaresolutions(a)mbsoftwaresolutions.com wrote: >On 2018-01-24 18:39, Fernando D. Bozzo wrote: >>When the index is evaluated initially, VFP knows exactly what fields affect >>what index, so really just affected indexes are updated. >>It's easy to test it. just make an old index (IDX) on two different fields: >>CREATE TABLE test (field1 C(10), field2 I) >>INDEX on field1 TO test_f1 additive >>INDEX on field2 TO test_f2 additive >>Add some data, wait a minute, replace one of the fields and do a FLUSH >>FORCE, and you will see that only the affected index changes his timestamp. >I don't think that's a fair test to use IDX files since this example >uses a CDX file, and it's all in the same file. I think it *is* a fair test for exactly that reason. If you see only one of the IDX index files change, that suggests that VFP only updates an index where it would make a difference. I grant that it could be that that optimisation does not exist in the CDX handling, but how likely do you think that is? Sincerely, Gene Wirchenko

6 6

Indexes on VFP tables--when do they get updated
by mbsoftwaresolutions＠mbsoftwaresolutions.com 25 Jan '18

25 Jan '18

Question for you legends of the Fox (data): Say Table1 has "X" number of indexes. Program code does something like the following: IF Condition1 THEN REPLACE Field1 with SomeValue in Table1 ENDIF IF Condition2 THEN REPLACE Field48 with Datetime() in Table1 ENDIF Are each of the "X" indexes updated for each replace, even if those indexes do not include any reference to Field1 or Field48, or only indexes that are affected by the data value change? I understand that ADDing and DELETEing records updated all indexes; I would think the UPDATEs--regardless of what fields updated--would cause index updates for every indexed field on every update as well. tia, --Michael

7 16

Timers in VFP
by mbsoftwaresolutions＠mbsoftwaresolutions.com 25 Jan '18

25 Jan '18

I've got a timer in a very small "listener" app that checks a web service and changes data in the local database based on WS returned records. I vaguely recall somebody saying timers in VFP were bad (at some point). Was it a memory leak or something? Tapping into this list's vast years of experience with this question. So far, my app works flawlessly, pretty much on timer cue, and doesn't appear to have any memory issues. Was just curious about this vague recollection. Thanks.

7 9

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox