possible bug in 5.2.5

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ketas
Posts: 28
Joined: Thu 02 Sep 2010 12:08

possible bug in 5.2.5

Post by ketas » Fri 10 Jan 2014 11:20

Hi,

i have win7 prof sp1, xe4, unidac 5.2.5, i use tuniconnection, torauniprovider and tuniquery. Oraclient is instantclient 11.2

example:

Code: Select all

procedure TForm1.FormCreate( Sender : TObject );
  var
    lParam : TDAParam;
  begin
   // useunicode true
  // oracle table branschen
  // spezifikation varchar2(30)
  // br_id# number
  // spezifikation = 'Banken/Sparkassen'
  // br_id# = 1

    with unqry1 do begin
      sql.text := 'select spezifikation,br_id# from branschen';
      lParam := Params.CreateParam( ftWideString, 'SPEZIFIKATION', ptInput );
      filterSql := 'Lower(spezifikation) like lower(:spezifikation)';
      lParam.Value := 'banken/sparkassen%';
      prepare;
      open;
      showmessage( intToStr( recordcount ) ); // 0 record - ERROR
      close;
      lParam.Value := 'bank%';
      prepare;
      open;
      showmessage( intToStr( recordcount ) );
      lParam.Value := 'banken/sparkassen%';
//      prepare;
      open;
      showmessage( intToStr( recordcount ) );
      close;
      lParam.Value := 'bank%';
//      prepare;
      open;
      showmessage( intToStr( recordcount ) );


    end;
  end;

Parameter value longer as 4 char causes that 0 record is returned,
in unidac 5.0.2 it was O.K.

Can you see it please?
Thanks Vojslav

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: possible bug in 5.2.5

Post by AlexP » Fri 10 Jan 2014 14:35

Hello,

Thank you for the information. We know about the problem and work on its solution. As soon as we fix the behavior, we will inform you.

Post Reply