Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    8

    Unanswered: Need total for Each Dealer

    What I need now is a way to add to my Fox Pro 2.5 Program a way to enter a Dealers name and it will go into the database and count how many times it is in the database.

    Example:

    Enter Dealers Name : Westway Ford

    Westway Ford has 25 Warranty Claim Forms


    I am also looking to change out from Fox Pro 2.5 to the newest Visual Fox Pro so if anyone knows the easiest way to do this also please let me know...


    David

  2. #2
    Join Date
    Dec 2003
    Posts
    104
    You can use an @...GET command to enter the name, then use the COUNT command or a query to count them. Assuming the name of the table is 'dealers' and the field name is 'dealer':

    SET TALK OFF
    STORE SPACE(25) TO m.dealer
    @ 1, 1 SAY 'Enter dealer:' GET m.somename
    READ

    COUNT FOR dealers.dealer = m.somename
    @ 3, 1 SAY 'There are ' + ALLTRIM(STR(_TALLY)) + ;
    ' warranties for ' + m.somename


    For the conversion part of the question, the stuff you've done here doesn't really need much modification to run directly from VFP. But for a bunch of good advice on converting from 2.x to VFP, go to:
    www.tek-tips.com
    and go to the "Foxpro 2.x" and "Visual Foxpro 3.0 or higher" forums and do a keyword search on convert, conversion, etc. That issue has been discussed many times and you'll get some good ideas.
    (Look for me there too as DSummZZZ!)
    DSummZZZ

    Even more Fox stuff at
    www.davesummers.net/foxprolinks.htm

Posting Permissions

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