Alpha Video Training
Results 1 to 3 of 3

Thread: Search on Key gives wrong results

  1. #1
    Jim Gatton
    Guest

    Default Search on Key gives wrong results

    Trying to update my A5 v.1.0.2 app with the new Home Version.
    Changing the buttons to print most reports/letters was a breeze.
    I have four buttons for searching the database. Oh. Table. Click button, fill in what I'm searching for in the particular field and I wind up right at the record searched for. Two of the four worked immediately.
    The other two I played with a little bit then decided to just take the obvious route and set up a new button to search for a specific key value. Don't even come close to the record searched for. So, taking my cue from v.1.0.2 I thought the most logical next problem was to rebuild my index. Ummm. What index? Rebuild the key value? How? I've searched through the instructions and come up blank.
    I'm sure if I printed out all of the instructions and searched diligently the answer is there but I didn't find it. I'm hoping someone can tell me either the answer to my problem (why searching on a key value doesn't work) or exactly where to find the answer that I may save some time.
    Thanks.
    P.S. I had to change my email address of record from dental01@earthlink.net to jim@1800sendmail.com and don't know what time today or this week that change will go into effect so be advised I probably won't receive any emailed answers unless you type in my address manually.

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Search on Key gives wrong results

    You don't build an index on a key value, you build an index on a field in which the key value will occur. Then you set the "current index in effect" to be that index, then you search.

  3. #3
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,563

    Default RE: Search on Key gives wrong results

    Jim

    Have your tried a default form with the control - K, find by key? You can change the index and perform lookups from that dialog form. It's very handy.

    To look at indexes and how they are defined, right click on the table and choose define indexes. There is also a rebuild indexes.

    When you search for a specific key value, how did you set that up?

    Another option is to post the database so we can look at what you've done.

Similar Threads

  1. Printing just the results of a search
    By Andy Gill in forum Web Application Server v6
    Replies: 11
    Last Post: 12-21-2006, 09:18 AM
  2. Posting Search results to HTML Title?
    By seidel1 in forum Web Application Server v6
    Replies: 4
    Last Post: 08-07-2004, 06:28 AM
  3. search returning incorrect results
    By Cheryl Lemire in forum Alpha Five Version 5
    Replies: 5
    Last Post: 08-04-2004, 07:34 AM
  4. Browse Results
    By David Montalbano in forum Alpha Five Version 5
    Replies: 1
    Last Post: 06-22-2004, 11:54 AM
  5. Search on Index - Search Key PopUp Dialog Bog
    By Jeff Wells in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-06-2003, 10:18 AM

Bookmarks

Posting Permissions

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