Thank you. Now I see it, I also remember using it several other places. /jan
________________________________ Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af Carsten F. Frandsen Sendt: 11. februar 2008 09:17 Til: development-axapta@yahoogroups.com Emne: RE: [development-axapta] Query on temporary table Hi, Use the method setRecord on the QueryRun to pass the temporary table to the Query. Br. Carsten F. Frandsen a-solutions ________________________________ From: development-axapta@yahoogroups.com <mailto:development-axapta%40yahoogroups.com> on behalf of Dahlsgaard Jan Sent: Fri 2/8/2008 2:53 PM To: development-axapta@yahoogroups.com <mailto:development-axapta%40yahoogroups.com> Subject: [development-axapta] Query on temporary table 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] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
