Sunday, December 27, 2015

How to Define a Temporary table in Microsoft Dynamics Nav


Temporary Tables

Temporary Table : A temporary variable that’s carry a table is called temporary table. It is basically used as a buffer  in C/AL programs for table data. Temporary table can be used in a same way as a database table is used. Temporary table is only present in the memory till the table is open.

Advantage

All the exchange with a temporary table only occurs on client side. If you want to perform a large amount of calculations, a temporary table can used to load the data. This will increase processing speed because all the operations are processed on the client.

How to define a temporary table:

1). Click on Tools >> Object Designer>> create a new table.

2). Then go to View >> C/AL Globals or C/AL Locals. If you  have selected   C/AL Globals, the C/AL Globals window appears.



Definig a temporary table variable

3). Write a name for the temporary table variable, and select Record as the data type ,Select the desired table in Subtype field.


4). Select your variable line and click View>> Properties, It display the Properties window.

Changing property



5). Make the value of the Temporary property to Yes.


After you have successfully created a temporary table, you can use it in your C/AL code.

Enjoyed the topic, Please do subscribe to our newsletter to get updated with every post without a miss.

Thanks for reading

Shubin Dongre





2 comments:

  1. Thanks for sharing this quality information with us. I really enjoyed reading. Will surely going to share this URL with my friends. bank alfalah car financing - bank islami

    ReplyDelete
  2. If you are new user or exiting user of QuickBooks accounting software and looking for the QuickBooks technical support.If yes than you have come to right place as we provide efficient technical support service to customers who show complete faith in us. With our efficient and highly qualified team ,we never disappoint our customers.You can reach us at 1800-961-4623 at any hour of the day. You can also visit our website at https://www.quick.helplinenumber.support/ for the complete knowledge of the QuickBooks products and services.

    The Services we offered are following-

    QuickBooks Technical Support Phone Number
    QuickBooks Technical Support Number
    QuickBooks Tech Support Phone Number
    QuickBooks Tech Support Number
    QuickBooks Customer Support Phone Number
    QuickBooks Customer Support Number

    ReplyDelete