General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using Select-SQL with tags that have .not.deleted() filter
I have a table with 500,000 records. I have a candidate index on tic_ticket with a filter of .not.deleted(). If I use a seek statement: =seek("901500","scticket","tic_ticket"), The record is selected immediately. If I issue a select statement: select * from scticket where tic_ticket = "901500", it takes a long time.
I understand that VFP is trying to optimize the expression and it cannot optimize with the filter. Isn't there a way to tell VFP to use my tic_ticket index and not try to optimize?
I am really struggling with this issue. I am beginning to come to the conclusion that I can't use select statements. But that seems crazy.
Any guidance?
paul
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