Select a register in LookUp Trigger

hunter · 2007-01-08

Hi, i have a little problem, i'm using the next code into the trigger section

CLEAR(recDimValue);
   recDimValue.SETCURRENTKEY(Code);
   recDimValue.SETFILTER(recDimValue."Dimension Code",'OBJGASTO');
   recDimValue.SETFILTER(recDimValue.Code,'3000..3997|2000..2997');

   IF FORM.RUNMODAL(0,recDimValue,recDimValue.Code)=ACTION::LookupOK THEN BEGIN
      "Objeto del gasto":=recDimValue.Code;
   END;

but, always open the top of the records... i would like move the position to a determinate record...

for example:
Code = 3111

always open the top (Code 2000)

i'ts posible move the record to 3111 and preserve, the filter???:
recDimValue.SETFILTER(recDimValue."Dimension Code",'OBJGASTO');
recDimValue.SETFILTER(recDimValue.Code,'3000..3997|2000..2997');

kine · 2007-01-09

You mean something like:

  recDimValue.GET('OBJGASTO','3111'); //get this record

or

  recDimValue."Dimension Code" := 'OBJGASTO';
  recDimValue.Code := '3111';
  recDimValue.FIND('=<>'); //find same record or some nearest it

kriki · 2007-01-09

kine wrote:

recDimValue.FIND('=<>'); //find same record or some nearest it

But try to avoid '=<>'. They are performance killers if they are triggered a lot.

hunter · 2007-01-09

:shock: :shock: amazing!!!
very simple and very functional, that solve the problem, many thanks for your help

Select a register in LookUp Trigger

Comments

Categories