Re: SV: [development-axapta] findrecord performance

2006-01-04 Thread Stefan Osterburg
Hi Sonny, thank your for your comprehensive answer. In the meantime I had figured out the solution of using lookup field and executequery(). This really does solve my specific problem, however there is one problem with this: executequery() does not consider any user defined searches or filters

Re: SV: [development-axapta] findrecord performance

2006-01-04 Thread Sonny Wibawa Adi
  Hi, Stefan,      There is another solution that can work fast like in Go to the Main Table. When doing Go to the Main Table task, Axapta will run the form at ClassFactory static class, formRunClass function. Thus, I have observed the argument values there. After several trials and errors, th

SV: [development-axapta] findrecord performance

2006-01-02 Thread Erik Hansen
Hi, FindRecord has, as you have experienced huge performance problems. The way findRecord works is, that it loops the FormDataSource (xx_ds.next()) to find the actual record. The only other way is to use a range, but that has the disadvantage that you loose the complete overview over a