Dynamically access the table objects in a particular range via c/al code

zohaibu95@hotmail.com

Hi,
I want to know is there any way to dynamically access (iterate) over the range of the tables and delete all the data in it via code ??

Help will be appreciated.

vaprog

Hi,

you can use

VAR
      RecRef : RecordRef;

FOR ID := FirstID TO LastID DO BEGIN
  RecRef.OPEN(ID);
  RecRef.DELETEALL(TRUE);
  RecRef.CLOSE;
END;

You may even use the Company parameter in the OPEN call, but then beware of using the DELETE trigger.

vaprog

Hi,

you can use

VAR
      RecRef : RecordRef;

FOR ID := FirstID TO LastID DO BEGIN
  RecRef.OPEN(ID);
  RecRef.DELETEALL(TRUE);
  RecRef.CLOSE;
END;

You may even use the Company parameter in the OPEN call, but then beware of using the DELETE trigger.