System Table as a Temp Table

How to use a system table as a Temporary Table 

We can use a system table as a temp table in our coding just try the following code....

static void CopyPersistedTableToTemp(Args _args)

{

    CustTable custTable;

    CustTable custTmpLedger;

    ;

    custTmpLedger.setTmp();

    custTable.recordLevelSecurity(true);

    while select custTable where custTable.City == 'Toronto'

    {

        custTmpLedger.data(custTable.data());

        custTmpLedger.doInsert();

     }

}

By using this code you can use a system table as a temp table and the good thing in this , this didnt disturb your main table configuration and data in that table. it just create a object of a table and use this object as a temporary.

SSRS Tutorial Video

Hi Friends,

Today I am sharing a Video for SSRS reporting Services, to batter understanding just try to do at your end also you have following s/w for this,

1. Visual Studio with reporting extensions

2. SQL server 2008/2005

3. Dynamics AX

LookUp On forms

Hi Folks,

Here I am sharing a method to how to write x++ code for a custom lookup control on a form. Try the following method in your code.

-Harry

RunBase frameWork In X++

RunBase framework

Whenever you write a class that typically asks a user for input and then starts a process based on that input you use the RunBase framework as most of the typical methods needed for such a Job is already implemented in the RunBase class. This means that using the RunBase framework is done by extending RunBase either by directly extending RunBase or by extending a class that extends RunBase.

Some of the features implemented in the RunBase framework are the following:

• Run: The main flow of the operation

• Dialog: Prompting the user for input and storing that input

• Batch execution: Schedule the Job for later execution

• Query: Used to select data

• Progress bar: Shows the progress of a task

• Pack/unpack with versioning: Remember variable values until the next time

the task is executed

-Harry