[Axapta-Knowledge-Village] Axapta and indexes

2005-07-29 Thread James Flavell
Title: Message Hi Malcom, Andrea, David and everyone else in the group   This question is a mix of std Axapta understanding and help for a Ax 2.1 SQl7 to SQL2000 upgrade   I have finally managed to do an upgrade of my customers SQL7 AX DB to SQL2000 using DTS.  Everything looks okay

RE: [Axapta-Knowledge-Village] Question about two datasource query

2005-07-29 Thread Dyachenko, Dmitry
You're welcome, Roberto. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Roberto Pineda Sent: Friday, July 29, 2005 2:37 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Question about two data

RE: RE : [Axapta-Knowledge-Village] report format to excel format

2005-07-29 Thread Dyachenko, Dmitry
It happens because excel can recognize and convert html in its spreadsheet format. You can also use text format to export axapta reports, it will work either. Anyway, in case of multipage report, you'll see all page headers and footers which is probably not ok for users. If you need a real Exce

RE: [Axapta-Knowledge-Village] Question about two datasource query

2005-07-29 Thread Roberto Pineda
you're right, thanks for your help. --- "Dyachenko, Dmitry" <[EMAIL PROTECTED]> escribió: > Use this > if (!qr.changed(tablenum(LedgerTable)) > > Frankly speaking I haven't seen a way how to run an > inner loop for a query. You can do it in a little > bit another way, > > While select legder

RE : [Axapta-Knowledge-Village] report format to excel format

2005-07-29 Thread Steeve Gilbert
Hi Richard, Many people say that you can save the Axapta report to HTML format and name the file Something.XLS so that it opens in Excel. This should do the trick with relatively simple report design. Give it a try. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-V

RE: [Axapta-Knowledge-Village] Question about two datasource query

2005-07-29 Thread Dyachenko, Dmitry
Use this if (!qr.changed(tablenum(LedgerTable)) Frankly speaking I haven't seen a way how to run an inner loop for a query. You can do it in a little bit another way, While select legdertable While select ledgertrans where ... But it will issue a bunch of select statements, which is not ok f

[Axapta-Knowledge-Village] Project Module

2005-07-29 Thread lukas nugroho
Dear All,   Can you all show me the way what should i do to setting the project. and can u give me a clue the process of the project   thank you   Lukas__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.y

RE: [Axapta-Knowledge-Village] Question about two datasource query

2005-07-29 Thread Roberto Pineda
Thanks Dmitry... It works nice, but i think or thoght that it could be another way without checking if AccountNum has changed. I haven't found. Anyway thanks again. Roberto --- "Dyachenko, Dmitry" <[EMAIL PROTECTED]> escribió: > Hi Roberto, > > I've commented out the piece of code, which you >

[Axapta-Knowledge-Village] Team In Charge

2005-07-29 Thread Danny Gaethofs
Dear all, On the project filter you can find a radio button team in charge. Where are the teams created? How does Axapta keeps track of the modifications made by each team to object in the AOT? regards, Danny Yahoo! Groups Sponsor ~--> http://us.

RE: [Axapta-Knowledge-Village] Re: Posting Memory Leak

2005-07-29 Thread Hennie Potgieter
Hi Vaibhav, The leak only becomes problematic after posting around 3500 sales orders. Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of vaibhav pednekar Sent: Thursday, 28 July 2005 17:10 PM To: Axapta-Knowledge-Village@yahoogro

[Axapta-Knowledge-Village] Re: Somthing cool - IO

2005-07-29 Thread victor_zuev
Thanks very much for an interesting example. The example was quite difficult for me to execute because this line: > sql = strFmt('void executesql()\n{\nTable1 table1;\nTable2 I think, it would be more comprehensive if the line was written as : > sql = strFmt('void executesql(ProjTable pr