🚀 go-pugleaf

Some operations does require Open()/Close(), other - no. It is easy to test.
If you will call Open()/Close() - you may have less problems while debugging
of searching bugs.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"steve" <sportock@hotmail.com> �������/�������� � �������� ���������:
news:40f640b5$1@newsgroups.borland.com...
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote:
> >As usual:
> >
> >TADODataSet *rs = new TADODataSet(NULL);
> >try
> >{
> >  rs->Connection = frmFrame->adoConnection;
> >  //This may be set in designer or on connection-related code.
> >  rs->Connection->LoginPrompt = false;
> >  rs->CommandText = sql;
> >  rs->Open();
> >  try
> >  {
> >    ..
> >  }
> >  __finally
> >  {
> >    rs->Close();
> >  }
> >}
> >__finally
> >{
> >  delete rs;
> >}
> >
> >"Steve" <sportock@hotmail.com> �������/�������� � �������� ���������:
> >news:40f4119e$1@newsgroups.borland.com...
> >>
> >> I am instantiating tadodatasets dynamically, not using the vcl stuff to
> >drop on my form. What is the proper way to create the object and handle
> >errors and releasing memory for it? I am doing them like this.
> >>
> >> TADODataSet *rs = new TADODataSet(NULL);
> >> rs->Connection = frmFrame->adoConnection;
> >> rs->Connection->LoginPrompt = false;
> >> rs->CommandText = sql;
> >> rs->Open();
> >> rs->Close();
> >> delete rs;
> >>
> >> I just can't seem to find any example code. Thanks in advance.
> >>
> >
> >
> Thanks, when ever using these types, do the connections have to be opened
and closed explicitly? I know on recordsets, but how about adoquerys, or
adocommands when just executing a simple sql statement?