Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Tuesday, May 13, 2014

Parent shold not be closed unless child form is closed in Dynamic AX

Hi,

// you are writting on formA parent form
Args args;
FormRun formRun;
;
super();
args = new Args(formstr(FormB)); // FormB is child form
args.caller(element);

formRun = classFactory.formRunClass(args);
formRun.init();
formRun.run();
formRun.wait(); // this waits till child closes, unless child closes u cant close parent/ current form
formRun.detach(); // this will not wait for child form to close..

Regards,

Wednesday, May 7, 2014

Delete actions are used in Dynamic AX

Hi,

Meaning: If you are deleting a record in the master table , how should it react if it has got transaction records

4 type of delete actions

None - IT WILL DELETE MASTER RECORDS AND WILL NOT DELETE CHILD RECORDS

Cascade - IT WILL FIRST DELETE THE CHILD RECORDS AND COME BACK AND DELETES THE MASTER RECORD

Restricted- IT WILL NOT DELETE ANY OF THE RECORDS [MASTER AND CHILD] - IT WILL THROW A WARNING MESSAGE - TRANSACTIONS EXISTS IN XYZ TABLE.CANNOT DELETE THE RECORD.

C + R [Cascade + restricted] - OPTION IS LEFT TO THE USER TO DELETE OR NOT

Note: Delete actions should be always be set on Master table

Regards,

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...