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.
