Devart Forums

Posted: **Mon 30 Jan 2012 01:53**

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

Posted: **Mon 30 Jan 2012 12:32**

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;

Devart Forums

Config CRSQLConnection1

Config CRSQLConnection1