Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL from Filtered table?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00209378
Message ID:
00209380
Views:
21
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform