Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filtered the 2nd table based on the result of 1st table
Message
De
08/08/2003 09:08:25
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00818131
Message ID:
00818165
Vues:
23
>Ok,
>
>I'm developing a searching process using 'metaphone algorithm' in my library program.
>
>I have 2 table: Tcode and TBooks. Tcode is a table to store words and its transformation code, so it has 2 fields, cword and ccode. Tbook is a table to store information about a book. It has some fields including cBookID, cTitle, cAuthorId.
>
>Here is the search process and the problem is on the 2nd step:
>
>1.I filter Tcode table using SET FILTER, based on the keyword, and display
> it in a grid (GrdCode); it works nicely.
>
>2.I need to filter Tbooks based on the result of 1st step (word(s) that is
> displayed on GridCode), then display it on a grid (GrdBook) as the final
> result. This step runs automatically after the 1st step.
>
>What should I do?

Gloria,
So far so good but I can't see a relation between Tcode and Tbook fields. For example what might return in Tcode (values) and what is serached in Tbook based on those values?
If you can do a SQL for that simply make that SQL recrdsource for your grdBook grid.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform