Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL weird behavior
Message
From
02/09/1999 11:02:19
 
 
To
02/09/1999 10:39:06
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00260614
Message ID:
00260625
Views:
17
Just to elaborate more, I have deleted the 4 tags I am using in the SQL. I have indexed them again. I still have the same behavior. If I put the NOFILTER clause it's ok. If I don't, I have too many records in my SQL.

With the NOFILTER, I have 281 records. Without, I have 778 records.

So, as for a SQL, it's ok as I can force a NOFILTER and this solves the problem. However, for a COUNT I can't so I have the same behavior.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform