Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Which would be better for me, VFP, Access or Filemaker?

Status
Not open for further replies.

RandyFocht

Programmer
Sep 1, 2005
2
US
I was a professional foxpro programmer 9 years ago, and haven't used it since. I have written some fairly large programs, including my first, which was the tax collection system for Samoa.

My last version was the first windows version. Unfortunately, that version, will no longer run on the current XP operating system.

I now own a wedding photography business, and need to track leads, and send emails, write invoices, and keep track of services and products for the client.

Which software would be better for my needs? Foxpro, or Access, or Filemaker?

I need a relational system, and if I could program some of it myself, I would prefer hands on approach, although I wouldn't mind paying someone to help me out as needed.

I would need 6 or more related databases, input screen with an indexed search on 5 fields (brides first name, brides last name, wedding date, grooms first name, last name) which would bring up a browse type table to select from, Hit <enter> and it would bring up all the personal info.
Half screen down would be tabs from left to right, each tab to a related database and it's info.

I need to keep track of all the emails/calls I make to each lead. I need to send an automated "how things going" type email every week to each potential customer over a long period of time, until their wedding date passes.

I also need to track new sales per week, how much I sold, with cost, and profit.

I need to keep track of vendors assignments . ie. photographers, videographers, musicians, flowers, cakes, etc., how much I owe them, and paid them.

Once this program is complete, I will be able to run my business much better.

If the latest Visual foxpro will still read the old commands from the command window, I could write most of the program myself.

QUESTION? Does the command window still work? Does browse still work? Do the old commands still work? Or is it now easier to create relationships using only the mouse. etc. as Object Oriented in place of programming commands?

Is Access easier to use than Foxpro? Is it now fully relational? Can I select certain records based on a "next email date" and do batch emails? If so, does it send them through Outlook?

I got the trial version of Filemaker, and was able to create a few databases, and create the relationship, and the input screen/form. But, I have no idea how to control anything.

I can't seem to find anyway to talk to Microsoft sales people as to what the latest program can and can't do programming wise.

Essentially, once Microsoft took over the program, and started charging the enormous fees for support, MS essentially put me out of business. (along with thousands of other fox programmers I hear).

It's hard to see how Microsoft can continue its total monopoly taking over and dominating one software area and another, one by one. Obviously, MS has more power than the courts now.

So, which software do I choose? Any suggestions would really be appreciated

Thanks,
Randy Focht
ILoveSax@hawaii.rr.com
 

In posting this in a Foxpro forum you may not get an objective answer. Being a FoxPro, I would not hesitate to take on a project like that one. Yes the old syntax still works, yes the command window is still there and browse. The language has improved (added features), so you find that you will be able to do more with it.
I cannot speak for Access nor FileMaker as I never used them to develop applications.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)
 
As Mike said don't expect objective answer from here. We all love VFP. All things you want is easy to do with VFP, i can say easier then in any other language. And I mean ALL, sending eMail, do initial screens, search, reports etc.
All OLD syntax worked in newer version of VFP, but you will found that if you change a little your thinking you can build that application no more than a month.

Borislav Borissov
 

Randy,

I'm sure you'll get some good answers to your questions, although you need to keep in mind that most of us earn our living through Foxpro, and are generally biased in favour of it.

There's no question that it will handle your requirements with ease, but you've also got to take account of your existing knowledge, and generally how comfortable you feel with each of the products. The fact that you have a background in Foxpro should be a good point in its favour. Personally, I don't like Access as a development tool (as opposed to interactive data management), but that's partly because I don't know it so well.

To answer your specific questions:

Does the command window still work?

- Yes. Just as before.

Does browse still work?

- Yes.

Do the old commands still work? Or is it now easier to create relationships using only the mouse. etc. as Object Oriented in place of programming commands?

- In general, all the old commands still work, but many have been replaced by newer, more object-oriented ways of doing things. The OOP methods have lots of advantages but require an effort to learn. One problem with many of the old commands is that they are not documented in the Help.


Is Access easier to use than Foxpro?

- Probably easier for end users, but not necessarily for developers.

Is it now fully relational? Can I select certain records based on a "next email date" and do batch emails? If so, does it send them through Outlook?

- Pass.

I got the trial version of Filemaker, and was able to create a few databases, and create the relationship, and the input screen/form. But, I have no idea how to control anything.

- Nor do I.

I can't seem to find anyway to talk to Microsoft sales people as to what the latest program can and can't do programming wise.

- There's quite a lot of information available on line, including the entire Help file. I doubt you'll find anyone in Microsoft sales who can tell you what Foxpro can and can't do. Ask here instead.

Essentially, once Microsoft took over the program, and started charging the enormous fees for support, MS essentially put me out of business. (along with thousands of other fox programmers I hear).

- Not true. Many Fox programmers have moved on to other platforms, but the "enormous fees for support" has never been an issue. There is a huge amount of free support available from all kinds of places, including this forum, not to mention many books, web sites and magazines devoted to Foxpro.

Let us know what you decide.

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)
 
Unlike Mike I split my time between Access and Fox so just to fill in the gaps in his knowledge...

Is Access easier to use than Foxpro?
Access is easier for users. And easier for users to break. On the other hand, Access does have better security built into it. You can prevent users making any changes to the design of tables or application. This protection can be set to different levels for different components of the database.

Fox is good because it's self-contained. In Access you are reliant on components from the rest of Office and it's not unusual for an Access system to break when another application (such as Visio) is installed or upgraded.

Is it now fully relational?
Neither Access nor FoxPro are fully relational, both allow you to break the rules set down by Codd & Date. I would say that Access is less relational because you can't get as close to the raw data. A Fox browse will always show you what's on disk. The Access equivalent doesn't always do this.

Can I select certain records based on a "next email date" ...
Both support SQL to select records. Fox also supports the xBase commands like LOCATE, SEEK, and the FOR clause in a BROWSE.

... and do batch emails? If so, does it send them through Outlook?
It's trivial to send an email from Access but it does use Outlook and you'll trip over the Access anti-spam protection. Both languages can bypass Outlook and it's about the same amount of work in both.

I have no expereince of FileMaker. It's only advantage seems to be its ability to run on Mac and Linux systems.

When I have to chose between developing a system in Access or Fox I work on the following basis:

Access is good if the users need to be able to take control of the system and make changes to it. They must expect problems every year or so when they upgrade Office.

Fox is good if the company depends on the database and if it needs to run reliably for many years regardless of other changes being made on the system.

Having said that I spend half my time in Access, it's not through choice. Fox is very much better as a developer's environment. And I'm as biased as the rest of them here<g>.

Geoff Franklin
 
I'm completely unbiased and you definitely want to go with Visual FoxPro! [wink]

boyd.gif

SweetPotato Software Website
My Blog
 
Sorry, I didn't mean to be rude or unappreciative, but I couldn't see how to reply to the post.

After looking again, I finally saw the message at the bottom saying that I could not reply without being a member. and obviously I was already a member, or I could not have posted the original message. Confusing.

Thanks to everyone's input and help, I have decided to go with the Foxpro and am having someone help me write the program.

I hope to talk to everyone after I get started.

Warmest regards,
Randy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top