[development-axapta] Query on temporary table

[Dahlsgaard Jan]

Hi
 
For some time I have used TmpLedgerTable to hold some records, and
scrolled thru these using a simple while-select:
 
    tmpLedgerTable.setTmpData(this.tmpdata());
    while select tmpLedgerTable
    {
        do something
    }
 
Now, for different reasons, I have to change this to a query like this:
 
    tmpLedgerTable.setTmpData(this.tmpdata());
    q = new Query();
    qbdsTLT = q.addDataSource(TableNum(TmpLedgerTable));
    qr = new QueryRun(q);
    while(qr.next())
    {
        do something
    }

But this doesn't work. Am I doing something wrong, or can a temprorary
table not be used in a query ?
 

Kind regards

 

Jan Stelsig Dahlsgaard
Axapta Developer

FUJITSU


 



[Non-text portions of this message have been removed]