selas
asked on
Unable to select data from Oracle DB
I want to select wanted data from from Oracle Db
in table fcarte i have two columns: id_cli, id_clcrd
In labelededit i write: 000000000000047D
Press button and i get error:
SQL command not properly ended
procedure TForm1.Button1Click(Sender : TObject);
begin
AdoQuery1.SQL.Clear;
AdoQuery1.SQL.Add('Select id_clcrd, id_cli from fcarte where id_clcrd = '+LabeledEdit1.text+'');
AdoQuery1.Open;
end;
HOW TO FIX IT?
in table fcarte i have two columns: id_cli, id_clcrd
In labelededit i write: 000000000000047D
Press button and i get error:
SQL command not properly ended
procedure TForm1.Button1Click(Sender
begin
AdoQuery1.SQL.Clear;
AdoQuery1.SQL.Add('Select id_clcrd, id_cli from fcarte where id_clcrd = '+LabeledEdit1.text+'');
AdoQuery1.Open;
end;
HOW TO FIX IT?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER