Config CRSQLConnection1

[gilson.ti]

Hello,

I use Delphi 7 and would like to set some parameters of a CRSQLConnection1, could present an example of the correct way to do this?

In the file readme.html says:

If you compile the application for CLR, you should use
ISQLConnection_SetOption (SqlConnection1, ...)

But I could not implement it that way.

Sincerely,

Gilson

[AndreyZ]

Hello,

You cannot compile your application for CLR using Delphi 7, it is possible only in Delphi 2005, 2006, and 2007. In Delphi 7, you should use the following code:

Code: Select all

procedure TForm1.SQLQuery1BeforeOpen(DataSet: TDataSet);
begin
  SQLConnection1.SQLConnection.SetOption(coFetchAll, Integer(True));
end;