OlegTimkiv Posted July 29, 2021 Share Posted July 29, 2021 Добрый день! Пытаюсь сделать такой фильтр. Так работает : 'CompanyName LIKE ''%Alfreds Futterkiste%'' and ContactName = ''Maria Anders'' or ContactName = ''Ana Trujillo''' Добавляя скобки или in ошибка "Аргументы имеют неверный тип, выходят за пределы допустимого диапазона или вступают в конфликт друг с другом" . 'CompanyName LIKE ''%Alfreds Futterkiste%'' and (ContactName = ''Maria Anders'' or ContactName = ''Ana Trujillo'')' 'CompanyName LIKE ''%Alfreds Futterkiste%'' and ContactName in (''Maria Anders'', ''Ana Trujillo'')' Хотя в документации есть такой пример Country IN (SELECT Country from Country where Currency = '_Franc') Quote Link to comment Share on other sites More sharing options...
Sherzod Posted July 29, 2021 Share Posted July 29, 2021 Добрый день, Есть тестовый случай для воспроизведения? Quote Link to comment Share on other sites More sharing options...
OlegTimkiv Posted July 29, 2021 Author Share Posted July 29, 2021 5 minutes ago, Sherzod said: Добрый день, Есть тестовый случай для воспроизведения? procedure TMainForm.UniDBGrid1ColumnFilter(Sender: TUniDBGrid; const Column: TUniDBGridColumn; const Value: Variant); begin if UniMainModule.ADOQuery1.Active then begin UniMainModule.ADOQuery1.Filter := 'CompanyName LIKE ''%Alfreds Futterkiste%'' and (ContactName = ''Maria Anders'' or ContactName = ''Ana Trujillo'')' ; //'CompanyName LIKE ''%Alfreds Futterkiste%'' and ContactName in (''Maria Anders'', ''Ana Trujillo'')' ; //'CompanyName LIKE ''%Alfreds Futterkiste%'' and ContactName = ''Maria Anders'' or ContactName = ''Ana Trujillo'''; UniMainModule.ADOQuery1.Filtered := true; end; end; Для теста думаю достаточно, могу сделать с формированием строки фильтра. GridFiltering.7z Quote Link to comment Share on other sites More sharing options...
OlegTimkiv Posted July 29, 2021 Author Share Posted July 29, 2021 49 minutes ago, Sherzod said: Добрый день, Есть тестовый случай для воспроизведения? Полноценный тестовый пример сделал. GridFiltering.7z Quote Link to comment Share on other sites More sharing options...
Sherzod Posted July 29, 2021 Share Posted July 29, 2021 8 hours ago, OlegTimkiv said: GridFiltering.7z 7.29 kB · 1 download Я попробую проанализировать. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted July 29, 2021 Share Posted July 29, 2021 8 hours ago, OlegTimkiv said: GridFiltering.7z 7.29 kB · 1 download https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/filter-property?view=sql-server-ver15 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.