Open a Table without a var record....

philippegirod

I want to be able to open a tabledata in a codeunit for instance, sending the ID of the table in the parameters....

I've no idea of any solution...

- I tried to create as many variables as I have tables in Navision but it's impossible, I've a system error, navision is not able to compile such an object....
My file text was similar to that

  CODE
  {

    PROCEDURE AllTables@1000000000();
    VAR
      RecPaymentTerms@10003 : Record 3;
      RecCurrency@10004 : Record 4;
      RecFinanceChargeTerms@10005 : Record 5;
      RecCustomerPriceGroup@10006 : Record 6;
      RecStandardText@10007 : Record 7;
      RecLanguage@10008 : Record 8;
      RecCountry@10009 : Record 9;
      RecShipmentMethod@100010 : Record 10;
      RecSalespersonPurchaser@100013 : Record 13;

etc....

:?: Is there a function wich allows to open directly a table without having a variable for this record.... and launch a processing in this table ?

(I'm not really a developper, just a consultant who need to do some code, but i'm able to understand.... a few words in programming)

Luc_VanDyck

Starting from Navision 3.60, some new datatypes are introduces for working with variable tables at run-time:
recordref, fieldref, keyref.

You can open eg. the customer table - Table 18 - using following code:

myrecrefvar.OPEN(18);

philippegirod

THANKS !!!!

philippegirod

Do you have any code samples for this function RecordRef ?
How apply a filter ?
How choose a field in the table and copy the value of this field ?
How can I use A FieldRef instance ?......

RobertMo

Check "Export Navision Table Data PRO" that utilizes these functions.
You will have a good example tor start.
http://www.mibuso.com/dlinfo.asp?FileID=350

And tell me how did it worked for you...

Luc_VanDyck

philippegirod wrote:

Do you have any code samples for this function RecordRef ?

Search and you shall find: RecordRef Sample