![]() |
#17 |
Участник
|
Нет, точно FIND('-')
![]() Сейчас проверил, получилось: Source Text = IF GLEntry.FIND('-') THEN; SQL Statement = SELECT * FROM "Test$G_L Entry" WITH (READUNCOMMITTED) WHERE (("G_L Account No_"=?)) ORDER BY "Entry No_" OPTION (FAST 5) SQL Plan = Sort[3,1];Bookmark Lookup[4,3];Index Seek($1)[5,4] Ничего не понимаю, через 5 мин. запустил: Source Text = IF GLEntry.FIND('-') THEN; SQL Statement = SELECT * FROM "Test$G_L Entry" WITH (READUNCOMMITTED) WHERE (("G_L Account No_"=?)) ORDER BY "Entry No_" OPTION (FAST 5) SQL Plan = Clustered Index Scan(Test$G_L Entry$0)[3,1] |
|