Service Class using NewDataSet /NewCommand/ TDALocalDataAdapter

Data Abstract
1

HI,
I want to confirm the usage on those command:

  1. IDADataset using
    as Below:
    dsM_Ins:IDADataset;
    dsM_Ins := AllTableDASchema.NewDataset(Connection,‘TEST_TBL’);
    dsM_Ins.open;
    After finish dsM_Ins , need free it?

  2. IDASQLCommand usage
    cmdMtr:IDASQLCommand;
    cmdMtr := AllTableDASchema.NewCommand(Connection,‘MAKE_IOP_SUSPEND_STATUS’);

cmdMtr after using, need free?

  1. I create a service function to update aaa_tbl many records.
    I using below way to do:
    lda := TDALocalDataAdapter.Create(Self.Name);
    adt := TDAMemDataTable.Create(nil);
    adt.LogicalName := ‘AAA_TBL’;
    adt.RemoteDataAdapter := lda;
    adt.RemoteFetchEnabled := True;
    adt.Open;
    Doing_My_Update Logic;
    adt.Applyupdate;

Is it correct to use TDALocalDataAdapter like that?

  1. As IDADataset not support Locate function as it unidirectional dataset.
    if I need use locate , is it need use TDALocalDataAdapter with TDadatatable?

Please advise.

2

Hi,

  1. you can just free it like
dsM_Ins := nil;
  1. the same:
cmdMtr := nil;
  1. yes, TDALocalDataAdapter is used in the same way as TDARemoteDataAdapter
  2. yes
3

As @EvgenyK say and as rule of dumb, for convention, “names” starting with I are interfaces and have reference counting support. Can be freed setting nil at convenience.

HTH