Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Jim,
I agree that this feature is giving a whole lot of trouble. Though some will say it can be used to optimize your application, you can always set a filter: like:
USE TABLE
SET FILTER TO expr
This filtered tables feature is absolutely of no added value and is the cause of a whole lot of trouble. I would recommend the fox team to switch the default behaviour from filtered to non-filtered resultsets.
Note that the most of use use the SET DELETE ON settings in his/her applications. Since i'm against the use of a DELETED() tag I normally don't experience these resultsets (because fox can't fully optimize the query), but if it can I'll be banging my head against the wall why the program does not work as espected.
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only