General information
Category:
Coding, syntax & commands
I have a table with a Name c(9) field and a Code c(10) field. I created an index on ALLTRIM(Name)+Code. When I SEEK using this index with ALLTRIM(Name) plus the first 2 characters of the Code field, the record is found correctly. However, when I SEEK with ALLTRIM(Name) plus the entire Code field (or anything more than 3 characters), no match is found. I have tried reindexing and have verified the index expression. I have also tried SET EXACT both ON & OFF. Surely I am overlooking something simple here. Can someone please help?
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