Devart Forums

Posted: **Wed 04 Oct 2006 07:55**

Hey all,

Im using MYDAC (MySQL) and I am wondering how I can open a TMyStoredProc, take the result records and store them somewhere else, close the proc and still use the records that I stored?

Cheers
Illsley

Posted: **Wed 04 Oct 2006 09:41**

Try to move records from MyStoredProc into VirtualTable. This looks like following:

Code: Select all

  MyStoredProc.Execute;
  VirtualTable.Assign(MyStoredProc);
  VirtualTable.Open;

TVirtualTable component is included into MyDAC installation package. You can find this component on DataAccess tab of Component Palette.

Posted: **Wed 18 Oct 2006 12:54**

Thanks! Will try that.

Devart Forums

Clone records from a TMyStoredProc?

Clone records from a TMyStoredProc?