Clone records from a TMyStoredProc?

Illsley · Post by **Illsley** » 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

Antaeus · Post by **Antaeus** » 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.

Illsley · Post by **Illsley** » Wed 18 Oct 2006 12:54

Thanks! Will try that.