How do I work with Recordset in ExecuteComplete event?

Hi,

I want to use Recordset external to the ExecuteComplete event.

I created my own recordset and assigned in the event as MyRecortdset := Recordset.

It seems to be OK, but it could just be luck. However, it does not have methods like FieldByName, and I can't seem to determine field types etc. It just seems to limited.

So I thought that I would use a table and clone the recordset, but i can't do that either.

Probably my limitations are getting in the way here, so if anyone knows of some good reference material on this subject, please let me know.

Regards,

Andy
.

Relevant Pages

  • Re: How do I work with Recordset in ExecuteComplete event?
    ... I want to use Recordset external to the ExecuteComplete event. ... I created my own recordset and assigned in the event as MyRecortdset:= ... TADODataSet assign its recordset and use TDataSet methods. ...
    (borland.public.delphi.database.ado)
  • Re: How do I work with Recordset in ExecuteComplete event?
    ... I want to use Recordset external to the ExecuteComplete event. ... TADODataSet has read/write property RecordSet, so you can create TADODataSet assign its recordset and use TDataSet methods. ...
    (borland.public.delphi.database.ado)
  • Re: RecordsetPtr & Commands Execute() method
    ... I am not a C++ guy, but I will try to describe some limitations ... First if all, when you open read-only, forward-only recordset, you need to ... provider just scrolls recordset to the next or to the last record. ... "Chris Martin" wrote in message ...
    (microsoft.public.data.ado)