DrillDown with RecordRef

Comments

• Options

  eromein Member Posts: 589

  2003-11-20

  nope!
  
  Well not yet that is, how knows what the future will bring.
  
  I made a sample one time. Maybe it's off any help.
  
  downloadable here: http://www.mibuso.com/dlinfo.asp?FileID=276

  "Real programmers don't comment their code.
  If it was hard to write, it should be hard to understand."

  0
• Options

  efv@inecta.com Member Posts: 3

  2003-11-20

  Thank you for your quick response.
  
  The only thing that is really missing is the ability to do something like FORM.RUNMODAL(0,Customer); Just instead of having it the table CUSTOMER, I need to have it a RecordRef to that Table, without creating a variable. Maby FORM.RUNMODAL(0,RecordRef.NAME); I tried this along with many variations, and nothing seems to work. Any ideas of how to acomplish this?

  Elmar Freyr Vidisson
  Navision Attain Certified Programmer

  0
• Options

  eromein Member Posts: 589

  2003-11-21

  Nope!
  
  Well not yet that is, how knows what the future will bring
  
  Really, this is a big problem. I made lot of really nice applications based on recordrefs. But I always have to make a codeunit or a function to show a form per record....
  
  You have to do something like this:
  

  CASE RecordRef.NUMBER OF
    DATABASE::Customer :
      BEGIN
        Cust.SETTABLE(RecordRef);
        FORM.RUNMODAL(0,Cust);
      END;
    ESLE
      ERROR('No form defined'); // Should be a text constant
  END;
  

  
  * Code have'nt been tested!

  "Real programmers don't comment their code.
  If it was hard to write, it should be hard to understand."

  0
• Options

  Matjaz_Sega Member Posts: 3

  2011-12-17

  Not sure about the older versions, but in NAV 2009 R2 this can be done with the use of Variant datatype:
  

  rRef: RecordRef;
  var: Variant;
  
  rRef.OPEN(18); //Customer
  var := rRef;
  FORM.RUNMODAL(0,var);
  

  
  
  The only problem is that you can not apply filters to the record, because they get lost when you assign RecRef to the Variant variable. First record in the filter DOES get selected though. Example below:
  

  rRef.OPEN(18); //Customer
  rRef.FILTERGROUP(5);
  fRef := rRef.FIELD(2); //Customer.Name
  fRef.SETFILTER('T*');
  rRef.FILTERGROUP(0);
  rRef.FINDSET;
  var := rRef;
  FORM.RUNMODAL(0,var); //Form shows all records but is focused on the first that fits in the filter 'T*'.
  

  
  
  I hope that helps someone else too.

  0
• Options

  mdPartnerNL Member Posts: 802

  2011-12-17

  Matjaz Sega wrote:

  Not sure about the older versions, but in NAV 2009 R2 this can be done with the use of Variant datatype:
  

  rRef: RecordRef;
  var: Variant;
  
  rRef.OPEN(18); //Customer
  var := rRef;
  FORM.RUNMODAL(0,var);
  

  
  
  The only problem is that you can not apply filters to the record, because they get lost when you assign RecRef to the Variant variable. First record in the filter DOES get selected though. Example below:
  

  rRef.OPEN(18); //Customer
  rRef.FILTERGROUP(5);
  fRef := rRef.FIELD(2); //Customer.Name
  fRef.SETFILTER('T*');
  rRef.FILTERGROUP(0);
  rRef.FINDSET;
  var := rRef;
  FORM.RUNMODAL(0,var); //Form shows all records but is focused on the first that fits in the filter 'T*'.
  

  
  
  I hope that helps someone else too.

  
  
  Nice trick,
  But how to get the selected value back?

  0
• Options

  Matjaz_Sega Member Posts: 3

  2011-12-17

  Hm, yes, I'm sorry, the original problem here is different than the one I had - I only needed to open the form, not to actually make lookup.
  
  I have researched a bit further but haven't been able to retrieve the selected value back. I guess that you still need the record variable to make a lookup...

  0