Razzak has a app example that is ON KEY PRESS that would work. The only other part is running spell check and then you save the var captured and insert that into a table to reference for the next person. Later you could reference this table as they type. If no close matches it gets spell checked and inserted.
I know in the steps one can later include fuzzy logic by capturing miss spelling of words and loading/inserting into yet a separate table and reference. Great if certain people tend to miss spell the same words. I hope this helps. Paul Sent from my Verizon Wireless BlackBerry -----Original Message----- From: "Masahiro Kawata" <[email protected]> Date: Thu, 24 Sep 2009 13:36:06 To: RBASE-L Mailing List<[email protected]> Subject: [RBASE-L] - Google-like search field Hello everyone, I started learning about RDBMS last year and am now a beginner R:BASE administrator. There is a form I created for users to search for records they are interested in. What I want to do is to have a Google-like search field so that some suggested words show up below the field when a user types in texts. Currently, this is how it works. There are Variable Edit(for entering keyword) and Enhanced Speed Button(to execute "Search") on the form: 1. A User enters text and it is updated into a variable "vSearchValue" by GETPROPERTY syntax in On Key Press EEP. 2. When the user clicks the "Search" button, the program gets a list of IDs(primary key) into a variable "vSearchList" with these syntax below: SET V vSearchValue TEXT = ('' + .vSearchValue + '') SELECT (LISTOF(IDColumnName)) INTO vSearchList ... WHERE NoteColumnName CONTAINS .vSearchValue As I mentioned above, is there a way to automatically display suggested keywords(or words users have entered before) below the field while the user types in some texts? I would be happy if I could get any suggestion/advice, please. Thank you very much, Masahiro Kawata PINCHEVSKY Services de management en RS&DE Masahiro Kawata Technical Specialist 4141 rue Sherbrooke Ouest Bureau 410 Montréal (Québec) H3Z 1B8 T: (514) 931-0166 x 105 [email protected] www.pinchevsky.com ------------------- AVIS: Ce courriel privilégié et confidentiel est destiné à la seule personne ou entité à laquelle il est adressé. Pour toute autre personne, toute action prise en rapport à ce courriel ainsi que toute lecture, reproduction, transmission et/ou divulgation d'une partie ou de l'ensemble de celui-ci est interdite. Si vous n'êtes pas la personne autorisée à recevoir ce courriel, S.V.P. le retourner à l'expéditeur et le détruire. Bien que ce courriel ait été traité contre les virus, il est de la responsabilité du destinataire de s'assurer que l'envoi en est exempt. Nos communications avec vous peuvent contenir des renseignements confidentiels ou protégés par le secret professionnel. Si vous désirez que nous communiquions avec vous par un autre moyen de transmission que le courrier électronique ordinaire non sécurisé, veuillez nous en aviser. NOTICE: This privileged and confidential email is intended only for the individual or entity to whom it is addressed. With regard to all others, any action related with this email as well as any reading, reproduction, transmission and/or dissemination in whole or in part of the information included in this email is prohibited. If you are not the addressee, immediately return the email to sender prior to destroying all copies. Even if this email is believed to be free from any virus, it is the responsibility of the recipient to make sure that it is virus exempt. Our communications to you may contain confidential information or information protected under solicitor-client privilege. Please advise if you wish us to use a mode of communication other than regular, unsecured e-mail in our communications with you.
