Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!cbmvax!cbmehq!cbmita!digitm!steed From: steed@digitm.UUCP (Steed Kulka) Newsgroups: comp.sys.amiga.multimedia Subject: Record selection in AVision Keywords: Vision, database, record, selection, db Message-ID: <00309.AA00309@digitm.UUCP> Date: 6 Feb 91 14:10:01 GMT Followup-To: comp.sys.amiga.multimedia Lines: 44 We have found AVision not coherent on selecting db records depending whether a key field is numeric or string. It may be a bug, a "feature", or we are just missing some important point. When you select a database record using a string variable whose actual value may reference several records, AV selects the first record in list, and this is fine; but when the key field is numeric, AV selects the last record in list. Consider a record whose fields are: >CODE I NAME S >ORD# I Records in database are: 1 1 1 2 3 HUEY DEWEY LOUIE DONALD DAISY 1 2 3 4 5 Now assign variable and select record: >CODE : searchnum then read record: >CODE NAME resultname >ORD# resultord is now "LOUIE" and is 3. If field NAME was a key field and you searched the letter "D", AV would have selected record #2, the first whose NAME field starts with that letter. Any comment/hint/trick/suggestion on how to have record selection behaving the same way in both cases? Thank you in advance. -- _ _ _ ___ __ (_) | \|/ _| | |_ /\ |\/| Steed Kulka ----- |_/|\_/| | |__/--\| | BIX: digiteam UUCP: {uunet|pyramid|rutgers}!cbmvax!cbmehq!cbmita!digitm!steed