ProFox July 2016

profox@leafe.com

58 participants
62 discussions

Re: ProFox Support Request #987654321
by Gene Wirchenko 27 Jul '16

27 Jul '16

At 08:49 2016-07-22, Ted Roche <tedroche(a)gmail.com> wrote: >Thank you for contacting ProFox Support Request. Your delight with >FoxPro is important to us. Please note that we are not Microsoft. >In order to better serve you, please supply the following information. >While these steps seem onerous, 83.7% of people who want to contact >ProFox support find these steps solve the problem without the need to >post to ProFox, so this is the fastest path to solving your problem. 0) Please read http://www.catb.org/~esr/faqs/smart-questions.html How To Ask Questions The Smart Way By Eric Steven Raymond and http://radio-weblogs.com/0117767/stories/2004/05/19/whyIDontAnswerYourQuest… Why I Don't Answer Your Questions By Ted Roche >1. Have you turned it off and back on again? > >Most problem with computers occur because of some transient condition >caused by a faulty process gumming up the works, an update in the >background causing strange behavior, a file lock that failed to >release, or a runaway task that has consumed all of a resource. >Restarting the computer often solves this problem. If you cannot >reproduce the problem after rebooting, it's unlikely anyone else will >be able to, either. > >If you are working with a separate client and server machines, restart >them both. Keep a set of test data so that you can restore to a known point. >2. Search for the problem on the internet or the ProFox archive. > >If you haven't tried to search for solutions, consider doing that >before posting to the forum. It's likely your issue has been seen >before, and a solution can be found on the internet. Note that profox >has a searchable archive, and your solution is likely in there. > >The exact text of the error message is a good search term to start >with. Omit the information specific to your app, like the table or >field name or record number. > >If that fails, consider asking for help on the list. The following >steps will lead to a faster, more accurate solution and then we can >all get back to work. > >By writing an email that includes steps 3 through 7, most people >realize they failed to try something else, and fix their problems >before having to post. There's no faster solution than the one you >don't have to wait for. > >3. Describe the steps you have taken. > >In order to reproduce the problems you see, others need to be able to >take the same steps. > >If you can't reproduce the problem, say that. > >If it was working but then stopped working, say that. > >If you've never gotten it to work, say that. > >Attempt to provide a small code sample that shows the problem. a >simple CREATE TABLE, INSERT statements and then your demo code will >let others test the problem, and determine if their proposed solution >solves the problem. Right away, we'll all know if this is a problem >with your machine or configuration, or with everyone's. > >4. Explain what you expect to see, and what you see instead. > >"It doesn't work" is not a bug report. How can you tell it doesn't >work, and what did you expect it to do? If your SELECT statement >returns no records, it may be working fine, but not doing what you >expect. If it throws an error 1234, report the error number and any >messages. If it crashes the machine, describe what you see. > >If you see this on only one machine, say so. If it happens on all the >machines, say that. If it works on the file server that has the data, >but not the workstations, please tell us that. > >5. Describe the problem you are trying to solve > >People often get themselves into trouble because they have come up >with a solution to a problem and the solution keeps throwing different >problems at them. It may be that your initial solution isn't the best >one, or may not solve the problem at all. You may not understand what >the command is doing, as some are badly misnamed. Explain why you are >doing what you're doing, and be open to suggestions that there are >better ways to get to the solution you need. > >If you tell us "Don't ask why" or "Don't suggest I do it another way," >you're asking us not to help. If we're smart, we won't. > >6. Be nice. > >People are voluntarily donating their time and expertise to solving >your problem. They may misunderstand or suggest inappropriate >solutions or miss clues you have provided. Be patient. You are likely >under a deadline and a little frantic. Understand that being rude just >decreases the likelihood that anyone will help you solve your problem. > >7. Describe solutions you have tried, or resources you have used. > >It's likely people will suggest the first answer found by searching >the internet. If you've already tried that, say so. If you've looked >up the error message, and tried the workarounds suggested, say that. >Otherwise, you're just wasting everyone's time. > >8. Report if you find the solution. > >The ProFox forum is only as valuable as the problems that are solved. >Report if you figure it out, or if a proposed solution fixes it. Others may be interested in your problem, because they have run into it, too. If you post a "Never mind. I solved it.", the "Never mind." will probably be applied to your next question. You might not want that. Sincerely, Gene Wirchenko

3 3

SSD Hard Drives
by Chris Davis 26 Jul '16

26 Jul '16

Is there any reason why a fox pro app using DBF's would be significantly slower on a machine using a SSD drive? Thanks Chris Davis Acton Gate Systems Limited Hilton Hall Business Centre Hilton Lane Essington West Midlands WV11 2BQ M: 07966 020473 *: chrisd(a)actongate.co.uk Web<mailto:chrisd@actongate.co.uk%0bWeb>: www.actongate.co.uk<http://www.actongate.co.uk/> ______________________________________________________________________ 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 ---

4 4

Windows 10 and Append General
by Sytze de Boer 26 Jul '16

26 Jul '16

So I have used this approach for 20 years and it has always worked My client prepares an invoice using Word The file is "INV"+alltrim(str(invnum))+".DOC" E.g. INV12345.DOC The system says append general rtfgen from &newfile LINK It is then easy to print this on the report It seems this no longer works with Win10 My thoughts at this time are to no longer store the data in a General field, and to print the DOC file as part of the report. BUT, I can't figure how to do that. I can print pictures, BMP's, Gif's etc, but not a Doc file Can anyone throw some light on this, or offer some suggestions? -- Kind regards, Sytze de Boer --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

8 13

Re: Going from DBF to SQL in frameworks
by Brant E. Layton 26 Jul '16

26 Jul '16

Hi Tracy, Data stored in DBFs is most likely the limiting factor. Possible scenarios are: 1. switch to SQL, then rewrite into a new environment later 2. rewrite into a new environment, bring the use of DBFs into the new environment (perhaps not supported) 3. rewrite into new environment, converting data to SQL (or whatever) at the same time as the new environment goes live It seems that #3 would be the best, but probably requires the most resource and is the most risky. If #2 isn't possible, do #1. #2 seems like it would be creating a new problem along the way. |Brant Layton| |480.964.1316| On 7/23/2016 6:58 PM, profoxtech-request(a)leafe.com wrote: > Send ProfoxTech mailing list submissions to > profoxtech(a)leafe.com > > To subscribe or unsubscribe via the World Wide Web, visit > http://mail.leafe.com/mailman/listinfo/profoxtech > or, via email, send a message with subject or body 'help' to > profoxtech-request(a)leafe.com > > You can reach the person managing the list at > profoxtech-owner(a)leafe.com > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of ProfoxTech digest..." > > > This list is a distilled version of the main ProFox list. All messages with [OT] in the subject line have been distilled out, leaving just technical discussions. > > You cannot post directly to this list. Instead, please direct all replies to profox(a)leafe.com. > > > Today's Topics: > > 1. Re: [NF] Evernote vs OneNote (Man-wai Chang) > 2. Re: [NF] Windows 10 upgrade out to lunch (Man-wai Chang) > 3. Re: Going from DBF to SQL in frameworks (Man-wai Chang) > 4. RE: [NF] Windows 10 upgrade out to lunch (Allen Pollard) > 5. Re: [NF] Evernote vs OneNote (Charles Hart Enzer, M.D.) > 6. Re: [NF] Evernote vs OneNote (Stephen Russell) > 7. Re: [NF] Evernote vs OneNote (Charles Hart Enzer, M.D.) > 8. Re: Going from DBF to SQL in frameworks (Tracy Pearson) > 9. Re: [NF] Evernote vs OneNote (Malcolm Greene) > 10. Re: [NF] Evernote vs OneNote (Charles Hart Enzer, M.D.) > 11. Re: [NF] Evernote vs OneNote (Man-wai Chang) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 23 Jul 2016 17:16:34 +0800 > From: Man-wai Chang <changmw(a)gmail.com> > To: profoxtech(a)leafe.com > Subject: Re: [NF] Evernote vs OneNote > Message-ID: > <CAGv=MJCv_P4HJFxn-TaacS-HvssLZR5BYwDxyFPTgwqb9C9pUA(a)mail.gmail.com> > Content-Type: text/plain; charset="us-ascii" > > I am using TreePad Lite as notes taking program. > > Never used EverNote! > > OneNote got OCR, if I remember correctly. And I have never attempted it. > > On Sat, Jul 23, 2016 at 5:21 AM, Charles Hart Enzer, M.D. > <cenzer(a)gmail.com> wrote: >> What are the Advantages of Evernote? >> What are the Advantages of OneNote? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

FoxBin2Prg conversion error question
by Richard Kaye 25 Jul '16

25 Jul '16

Hi Fernando, Since I know you've been hanging around here in ProFox I thought I'd post my question here. If there's a better place, please let me know. :) I've got a VCX that is generating errors when I run it through FB2P. It's indicating there are duplicate objects in the VCX and does not generate the VC2 file. (See log example below.) I have used the cleanup option in the class browser but it hasn't helped. I've also USEd the VCX and run both PACK and PACK MEMO. Can you advise on the best way to get past this error? * Duplicated Object "gridiron.invgrid.invgrid" @Recno 139, (1st.Recno:17) -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 7

Going from DBF to SQL in frameworks
by Tracy Pearson 25 Jul '16

25 Jul '16

A couple different projects I know about are looking to convert from using DBFs to an SQL backend. One project is using the Visual ProMatrix framework. The other is using Codemine. If you have any input about a transition with these, please speak up. Thank you.

4 3

RE: Going from DBF to SQL in frameworks
by Kent Belan 25 Jul '16

25 Jul '16

We are in the process of converting from DBF to SQL. This will allow us to continue to use the VFP front end UI until we can convert to .Net. We are using West-Wind business objects for the middle tier. This allows us to run in DBF mode or SQL mode. In theory you just have to flip a switch to work in either data format but unfortunately there is much more work required, at least in our program. Kent -----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: Saturday, July 23, 2016 9:20 AM To: profox(a)leafe.com Subject: Re: Going from DBF to SQL in frameworks These are 2 established programs that were built with the framework. They are separate companies that approached me with the question about converting to an SQL back end. I have not done this. My request is if someone has done this, I'd like to hear some feedback about the project. It sounds like both companies will want a rewrite in the future. They are looking for information to know which route to take. Convert to SQL then write new modules, or just rewrite dealing with dbf issues. Tracy On July 23, 2016 5:23:17 AM EDT, Man-wai Chang <changmw(a)gmail.com> wrote: >If you are fluent with VFP, you might consider building your own >SIMPLIFIED framework. Most commercial frameworks are way too >complicated. > >Commercial frameworks are good if and only if your needs are simple. >When you need to do heavy customization, it would be as messy as if >there was no framework. :) > >On Fri, Jul 22, 2016 at 10:00 PM, Tracy Pearson <tracy(a)powerchurch.com> >wrote: >> A couple different projects I know about are looking to convert from >using >> DBFs to an SQL backend. >> >> One project is using the Visual ProMatrix framework. >> The other is using Codemine. -- Sent from my Android device with K-9 Mail. Please excuse my brevity. [excessive quoting removed by server]

1 0

Re: ProFox Support Request #987654321
by Gene Wirchenko 24 Jul '16

24 Jul '16

At 13:00 2016-07-22, Ted Roche <tedroche(a)gmail.com> wrote: >On Fri, Jul 22, 2016 at 1:24 PM, Gene Wirchenko <genew(a)telus.net> wrote: > > > > 0) Please read > > http://www.catb.org/~esr/faqs/smart-questions.html > > How To Ask Questions The Smart Way > > By Eric Steven Raymond > > and > > > > > http://radio-weblogs.com/0117767/stories/2004/05/19/whyIDontAnswerYourQuest… > > Why I Don't Answer Your Questions > > By Ted Roche > > > >An excellent suggestion! > >I'm astounded the radio-weblogs.com site is still up. They've been >out-of-business/in statis/bought by somebody else for a decade now. > >An updated link, same content: > >http://blog.tedroche.com/2004/05/19/dont-answer-questions/ Thank you for the update. > > Keep a set of test data so that you can restore to a known point. > > > > > > Others may be interested in your problem, because they have run into > > it, too. > > > > If you post a "Never mind. I solved it.", the "Never mind." will > > probably be applied to your next question. You might not want that. > >Well said! Well, I know I sure feel that way. We are a community, but some do not appear to have caught on. Sincerely, Gene Wirchenko

1 0

[NF] Evernote vs OneNote
by Charles Hart Enzer, M.D. 24 Jul '16

24 Jul '16

What are the Advantages of Evernote? What are the Advantages of OneNote? Thank you. *Shai / שי Charles Hart Enzer, M.D., FAACAPVolunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical Center* *“There is no passion to be found playing small -- in settling for a life** that is less than the one you are capable of living.”* *Nelson Mandela* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 8

[NF] Windows 10 upgrade out to lunch
by Joe Yoder 23 Jul '16

23 Jul '16

I have a small laptop with Windows 7 that I would like to upgrade to Windows 10. The machine has the Get Windows 10 icon in the system tray. Every time I click the icon, a Get Windows 10 window opens and after a brief pause at "Please wait", the screen displays sections "About Windows 10" and "Get the upgrade." Then at the bottom of the window there is a large bold font message "All done for now" followed by "There's nothing else you need to do. You'll get a notification on your PC or tablet when Windows 10 is ready for you." This condition has persisted for weeks and I expect without intervention it will continue after the end of July. I have Googled everything I can think of but no one seems to have the same problem. There are numerous entries about problems but they are typically accompanied by error messages which I would welcome but don't get. Any experience or thoughts? Perhaps I should take this as a sign that I should keep this machine on Win 7? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 7

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox July 2016