Article View: borland.public.vdbase.data.sql
Article #1297Set Key To - SQL
From: DSWilson
Date: Sat, 21 Feb 1998 00:00
Date: Sat, 21 Feb 1998 00:00
13 lines
1034 bytes
1034 bytes
I have a form with a grid and I want to have the user only see certain
records by making a choice (radio buttons). The database has a different
index for each choice, so if the user selected (example) "Answered" , the
code would change the order of the index to iif(answered,"Y","N") and issue
a Set Key To "Y". The grid would then only show the records where answered
was true ("Y"). Now with OODML I can't see how to do this. I see in an
earlier thread that A.A. Katz says that "there is no need for SET KEY" and
this can be done in an SQL statement. If I have 5 or 6 different choices
how is this as easily coded as SET ORDER TO and SET KEY TO?
Thanks
Dean
Technical Details
Message-ID:
<01bd3e80$ff483460$dfd0d1cc@deanwilson>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,935969730acf1bd5,start X-Google-Attributes: gidff5a1,public From: "DSWilson" <DeanWilson@pacificcoast.net> Subject: Set Key To - SQL Date: 1998/02/21 Message-ID: <01bd3e80$ff483460$dfd0d1cc@deanwilson> X-Deja-AN: 327164473 Organization: None Newsgroups: borland.public.vdbase.data.sql