TMSStoredProc.Disconnected

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
markdelphi
Posts: 16
Joined: Sat 08 Sep 2012 19:43

TMSStoredProc.Disconnected

Post by markdelphi » Fri 16 Nov 2012 18:51

Hello:

The property helps Disconnected says:

"Set the Disconnected property to True to keep dataset opened after connection is closed. "

But I can not stay the Open DataSet when connection is closed.

procedure TfrmCampos_Descripcion.LlenaDatosForma;
var
Conexion : TConexion; <- Class to handle the connection
begin
StProc.Close;
Conexion := TConexion.Create;
Conexion.Abrir; <- Open Connection
try
with Conexion do
begin
StProc.Close; <- StProc is TMSStoredProc
StProc.Connection := Conexion;
StProc.Disconnected := True; <- Dataset indicated that stays open
StProc.StoredProcName := 'PA_CONSULTAS_CAMPOS_DESCRIPCION';
StProc.Params.ParamByName('PMENU').Value := 'FILL_CAMPOS_DESC_GRD';
StProc.Params.ParamByName('ID_CAMPO_DESC').Value := -1;
StProc.Params.ParamByName('GIRO').Value := -1;
StProc.Open;
end;
finally
Conexion.Cerrar; <- Close Conection
Conexion.Free;
end;
end;

AndreyZ

Re: TMSStoredProc.Disconnected

Post by AndreyZ » Mon 19 Nov 2012 12:54

Hello,

Thank you for the information. We reproduced the problem and the investigation is in progress. We will notify you when we have any results.

AndreyZ

Re: TMSStoredProc.Disconnected

Post by AndreyZ » Fri 30 Nov 2012 10:59

We have fixed this problem. This fix will be included in the next SDAC build.

Post Reply