Driver can not set up the TDBXCommon.Parameters

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
Eden0928
Posts: 48
Joined: Sun 22 Apr 2012 14:08

Driver can not set up the TDBXCommon.Parameters

Post by Eden0928 » Mon 23 Sep 2019 01:58

DBXCommon.TDBXCommand.Prepare

Prepare the command for execution

This method prepares the command for execution.

If no parameters have been set up, the driver supports parameter metadata and the dynamic SQL statement contains parameters, Prepare sets up the command's parameters.
My test code:

Code: Select all

procedure TForm2.Button1Click(Sender: TObject);
var
  LCommand: TDBXCommand;
begin
  LCommand := SQLConnection1.DBXConnection.CreateCommand;
  LCommand.Text := 'SELECT * FROM employee WHERE empno = ?';
  LCommand.Prepare;
  Memo1.Lines.Add(IntToStr(LCommand.Parameters.Count));
end;
The result always to get 0.

How to set the sqlcoonection.param what support auto create TDBXCommand.Parameters?

Stellar
Devart Team
Posts: 319
Joined: Tue 03 Oct 2017 11:00

Re: Driver can not set up the TDBXCommon.Parameters

Post by Stellar » Wed 25 Sep 2019 14:50

Thank you for providing the information. We've reproduced the issue and started to investigate possible causes of the described behavior. We will let you know the results as soon as we get them.

Post Reply