ProFox

profox@leafe.com

2704 discussions

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

ProFox Support Request #987654321
by Ted Roche 22 Jul '16

22 Jul '16

Thank you for contacting ProFox Support Request. Your delight with FoxPro is important to us. 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. 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. 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. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

1 0

XMLToCursor converting numeric values to logical fields
by Paul Newton 21 Jul '16

21 Jul '16

Hi all I came across some unusual behaviour with XMLToCursor which the following code clearly demonstrates: Local lcXML Create Cursor curSource (A N(1), B N(1), C N(1)) Insert Into curSource Values(0,1,2) CursorToXML("curSource","lcXML") Browse Nowait XMLToCursor(lcXML,"curTarget") Browse Nowait lcXML looks like this: <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?> <VFPData> <cursource> <a>0</a> <b>1</b> <c>2</c> </cursource> </VFPData> In curTarget fields A and B are logical. Can anybody throw any light on this, particularly how the XML should be constructed so as to ensure that fields A and B are created as type numeric? Many thanks Paul Newton

2 4

GETFILE and SET DEFAULT
by Joe Yoder 21 Jul '16

21 Jul '16

I need to have a user choose a file with a specific extension from a specific folder. I assumed I could simply pass a file skeleton to GETFILE like one does to ADIR. When I try that FoxPro seems to navigate to the proper folder but does not show any contents in the folder. I looked up the docs on GETFILE and it appears that specifying the path to a specific folder is not a valid use. One needs to "SET DEFAULT TO" the desired path in a separate operation and then call GETFILE with the desired extension. This appears to work but when I tried to save and restore the setting of DEFAULT before and after this use I discovered that no matter what I do, ?SET('DEFAULT') always returns 'C:'. Since "SET DEFAULT TO" (invalid path) gives an error and GETFILE respects the setting - apparently the default value is being set but just not reported. My conclusion is that the recommended "m.SaveDef = SET('DEFAULT')" before and "SET DEFAULT TO m.SaveDef) after really do nothing. Am I missing something? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 13

Generate a report in local language (India)
by Ajoy Khaund 20 Jul '16

20 Jul '16

Dear All, I need to know if I can generate the payslip of a worker in my payroll module in Assamese (Local language of Assam in India). We are using English(UnitedStates) languge windows OS. Fonts for this local language are available. Is it possible to change say the Gross Salary from English to another language while printing. Kindly point me in the right direction. Thanks all. -- Regards, Ajoy Khaund Neamati Road Bhogdoi Mukh Jorhat 785001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: akhaund(a)hotmail.com Mail: akhaund(a)gmail.com http://teaanalyst.blogspot.com/ "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 16

Re: Checking for All-Different Characters
by Gene Wirchenko 18 Jul '16

18 Jul '16

At 08:49 2016-07-18, Ted Roche <tedroche(a)gmail.com> wrote: >Hey, spoiler alert! > >Guess you'll need to subscribe to Gene's newspapers to find the solution. Or run my program. >By inspection, I can come up with at least one date closer than that. Go ahead. >So, let's think about the *algorithm* to solve the problem in minimal >time, rather than the answer. What I asked about. It appears that my code, though it seems somewhat ugly, is a pretty good solution, at least by LOC. [snip] Sincerely, Gene Wirchenko

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox