[development-axapta] Re: Joining 3 tables with QueryBuildDataSource

2005-04-07 Thread ozzage
> hi >  > I have never tried the other way but may be because addlink criteria is fieldnum parent table - field num child table ? >  > regards >  > harry > Exactly.  In the addLink() method the parent field should be the first parameter, the child the second.  You have them the wrong way

[development-axapta] Batch

2005-04-07 Thread studlee15
I am developing a class that needs to be scheduled as a batch job.  I have made my class extend runbasebatch, but my problem is, that when I run it and schedule it, it only runs one time and then quits.  I don't know if my code is wrong, or I am not setting up the batch right. My code is b

[development-axapta] Best Practice for Replicating Data to Reporting Server?

2005-04-07 Thread kevjustice
What's your opinion on the best method for getting an axapta database over to another SQL server to off-load 3rd party reporting tools?  FYI, haven't had any luck with SQL replication due to the number of tables that don't have primary keys. Thanks! Yahoo! Groups Links To

Re: [development-axapta] Re: Joining 3 tables with QueryBuildDataSource

2005-04-07 Thread Harry (Harshawardhan Deshpande
hi I have never tried the other way but may be because addlink criteria is fieldnum parent table - field num child table ? regards harry Anton Tjiptadi <[EMAIL PROTECTED]> wrote: Hi andrew, thanks I tried your way, but first it 'cause error in the first QBDS in the QueryRange, i

[development-axapta] New language not in configuration utility

2005-04-07 Thread eya_parungao
Hi everyone.. I've created a new language using the label wizard. The problem is, when I check the list of languages available in the configuration utility, the newly-added language is not among the choices. Can anyone help me with this??? Thanks, Eya Yahoo! Groups Links

Re: [development-axapta] AOS network problems

2005-04-07 Thread Stefan Osterburg
Hi, That was actually my original configuration and doesn't help much, because during the day, there is always at least one user logged in so the AOS will hardly shut down, and even if it did - it would not shut down the service but only the instance. In the mean time i have found out that s

[development-axapta] Re: Joining 3 tables with QueryBuildDataSource

2005-04-07 Thread Anton Tjiptadi
Hi andrew, thanks I tried your way, but first it 'cause error in the first QBDS in the QueryRange, it says "Invalid Range", and then I switch the table order so it looks like this : qbds = q.addDataSource(tablenum(InventJournalTrans)); qbds1 = qbds.addDataSource(tablenum(InventTable))

[development-axapta] QueryBuildDataSource

2005-04-07 Thread Anton Tjiptadi
Hi all, I wrote a QueryBuildDataSource like this : qbds = q.addDataSource(tablenum(InventJournalTrans)); qbds1 = qbds.addDataSource(tablenum(InventTable)); qbds1.joinMode(joinmode::InnerJoin); qbds1.addLink(fieldnum(InventTable, ItemId), fieldnum (InventJournalTrans, ItemId)); . . strange t