Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL from Filtered table?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00209378
Message ID:
00209380
Vues:
20
>Hello,
>I have a Filter on a table, from which I want to make a query:
>SELECT * FROM MyTable INTO CURSOR MyCursor
>However, the Cursor contains ALL data from the table. I want to get only the filtered result from the table.

The filter is ignored by SQL. You need to do something different, the easiest just being to use the filter condition in the WHERE clause of the SQL...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform