🚀 go-pugleaf

"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?