Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2007
    Posts
    4

    What to use? Have used Clipper...

    I know I'm dating myself, but I used Clipper quite extensively about 12-14 years ago. After a long stretch as a SAHM I'm back working & would like to write a program to perform a specific job.

    I've looked at Access, but I'm not sure it's exactly what I need. I would have been able to create this program in one day with dBase & Clipper, but now I'm just frustrated. The data I'm working with is pretty basic, but there's a large volume of it.

    Thanks for any suggestions. I love writing code, but I'm a little overwhelmed at the choices out there now compared to when I started on a PET!! (Please tell me there's someone here that remembers that?)

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Welcome to the forums Cindy!

    Can you provide some more information about what you want the application to do, volume of data (Mb/Gb/Tb?) etc?

    The more information provided, the more informed an answer can be
    George
    Home | Blog

  3. #3
    Join Date
    Sep 2007
    Posts
    4
    Okay, trying to keep it simple, here's what I have to work with:

    I have receipts (numbered) that are sent out to different cities. When they are used, a copy is sent back to us with the amount on it. Here's what I need to track:
    -What city each receipt # is sent to
    -What date it was sent out, what month it was used & the date rec'd back
    -Amount
    -Total for the reporting month as calculated by the city
    -Which of 3 codes that the amount is assigned to

    Here's what I need to report:
    -Which receipt #'s & a total for each city for each month reporting, and any discrepancy to city's total
    -Which cities have not reported for which months
    -Totals for each of 3 codes for each city for the fiscal year

    I think that's all. The data is currently being kept in 3 different Excel spreadsheets, plus tapes are being run on an adding machine. So, I can only guess as to the number of records. I'd say: 60 cities x an avg of 50 receipts a month = 36,000 active records a year. I'll probably need about 2 years in the database ongoing.

    If you suggest Access, I'll give it a shot. I'm just concerned about wasting alot of time learning Access & then finding out it won't do what I want.

    Thanks for any direction you can give me!!

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Access should be fine for that amount of data.
    36K records * 2years = 72K records.

    If each record was 1K big that's 72Mb of data - which access will handle with no troubles.
    Access data cap is just shy of 2Gb - so no worries on that front!

    The Access topic on this forum is a very popular section - with many able contributers who will help you when they can - so even if you get stuck you'll be able to ask for help here

    I suggest you get your table/relationship designs sorted out first and there's a lovely topic here that you can ask questions in if you get stuck!
    Last edited by Pat Phelan; 09-12-07 at 16:08.
    George
    Home | Blog

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Simply to throw a bit of fuel on the fire, FoxPro has a great deal of the look, feel, and syntax of Clipper, but with a full-blown Windows GUI. Access will eat the problem you've described like candy, but your Clipper experience will be a lot more directly applicable with FoxPro.

    Just to pitch in one more wrinkle to advocate for MS-Access, it is used by far more users and will be much better supportable than FoxPro because of that... This means that FoxPro will be easier for you to get started, but Access will be easier for you to pass on to someone else.

    If I had to make the call, I'd use MS-Access. I'd also probably cheat and put SQL Server behind it because I hate fighting corrupt files because some bone head turned off their PC before the application closed properly.

    -PatP

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    FoxPro is the devil

    Nah I'm just joshing - I only say that because I have to care for a beast of a legacy system programmed in the aforementioned language. And most of my complaints are with poor backend design (MS SQL 6.5 ) and not so much the front end.

    I actually found FoxPro very easy to jump* into; but Pat raises all the right points for and against the use of this badger.

    *get thrown

    I (and I'm sure Pat too) would love to know what route you decide to take!
    And if you need help - stick around
    George
    Home | Blog

  7. #7
    Join Date
    Sep 2007
    Posts
    4
    Thanks for all the info!! At this point, I guess I'm going to suffer through trying to learn Access. I tried it for fun about 6 months ago, and was pretty frustrated. But, I hadn't found this forum!

    I'll head over to the Access forum: I'm sure as I get going I'll have questions for over there. I'll come back here & let you know how it goes once I have something to report.

    Now I just have to figure out what you meant by putting SQL Server behind it (I used to know all there was to know about the latest programming stuff...now I'm so out of touch!!).

    Thanks for all the input. I can't wait to get this project going!!

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    There are lots of folks around here that are willing to help, and the regulars all seem to subscribe to the notion that the only stupid question is the one that isn't asked... If you ask any question (politely), you'll probably get more help than you can use.

    Just an observation to follow that up, but there are a few folks who demand help, and there are also some folks (students) that try to trick/goad/coax someone into doing their assignments for them... These folks tend to get a somewhat different response, depending on which of us loses our temper first and responds to them. I've been known to conjour up a few doozies for the students, and a couple of blistering responses to the nasty/demanding crew in my day.

    -PatP

  9. #9
    Join Date
    Sep 2007
    Posts
    4
    Thanks for the tips. No student here (did this sound like a textbook problem?)...really, I'm old enough that the first computer in my house was a Commodore 64 (and Shaun Cassidy was my idol...but that's probably too much info!).

    I was just reading the Access forum & was thinking that in a couple of years my kids will be understanding this stuff better than me!

    I'm still surprised at the NON-efficient way this data is currently being stored. This task shouldn't take more than 15 minutes a day to keep up to date, but it's always way far behind because it's so difficult to get the data into the spreadsheets.

    Don't worry....I'm Canadian. I can't be anything BUT polite!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •