I can't filter the data I want

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
alisahin
Posts: 1
Joined: Thu 23 May 2019 13:41

I can't filter the data I want

Post by alisahin » Thu 23 May 2019 14:00

Code: Select all

procedure TForm1.Button2Click(Sender: TObject);
var
yazi : string;
begin
yazi:=Edit1.Text;
dmcd.OraQuery1.Close;
dmcd.OraQuery1.SQL.Clear;
//dmcd.OraQuery1.SQL.Add('SELECT * FROM KIMLIK WHERE dosya_no= '+Edit1.Text ) ;
//dmcd.OraQuery1.SQL.add('SELECT * FROM KIMLIK WHERE ADI Like "'+Edit1.Text+'%"');

//dmcd.Oraquery1.SQL.Text:='SELECT * FROM KIMLIK WHERE lower(adi)='+ yazi;
//dmcd.Oraquery1.SQL.Text:='SELECT * FROM KIMLIK WHERE dosya_no='+ yazi; this is work

dmcd.Oraquery1.SQL.Text:='select * from KIMLIK where (name)=' +yazi;//this is not work
dmcd.OraQuery1.Open;
dmcd.OraQuery1.Active;
end;

MaximG
Devart Team
Posts: 1375
Joined: Mon 06 Jul 2015 11:34

Re: I can't filter the data I want

Post by MaximG » Fri 24 May 2019 17:37

We tested the work of ODAC 10.3.9 according to your description and found no problems. For further investigation, please send us a full project, execution of which causes the issue. In addition, we will need DDL script to create KIMLIK table.
For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

Post Reply