Devart Forum

Код: Выделить всё

SELECT
     field_1, ... field_n
FROM
     table_x
WHERE 
     field_1 % 'текст'

Код: Выделить всё

13.2.2. Repeatable Read Isolation Level

The Repeatable Read isolation level only sees data committed before the transaction began; it never sees either uncommitted data or changes committed during transaction execution by concurrent transactions.

Код: Выделить всё

procedure TfMain.btnFilterClick(Sender: TObject);
var
  filterfield: string;
begin
  // --------------------------------------------------------
  //Поле поиска
  // --------------------------------------------------------
  case cbbSearch.ItemIndex of
    0: filterfield := 'EMPLOYEE_NAME';
    1: filterfield := 'EMPLOYEE_TABNUM';
    2: filterfield := 'EMPLOYEE_ADDRESS';
    3: filterfield := 'EMPLOYEE_BIRTHDAY';
    4: filterfield := 'EMPLOYEE_PHONE';
  end;
  // --------------------------------------------------------
  //Пробуем фильтровать
  // --------------------------------------------------------
  fDM.QEmployee.LocateEx(filterfield, edtFilter.Text,
    [lxPartialKey, lxCaseInsensitive]);
end;

Код: Выделить всё

UniConnection.SpecificOptions.Values['Direct'] := 'True';