RE: [Axapta-Knowledge-Village] Why so slow???

2005-08-15 Thread Søren Ager
Den 15. august 2005 19:06 skrev Brandon George: > public boolean confirmSalesOrder(SalesId _salesId) { Make sure this runs on the server. If this method is part of the class that reads the file you might want to make it static to get it to run on the server: server static boolean... >

Re: [Axapta-Knowledge-Village] reading table outside axapta database

2005-08-15 Thread kbi kbi
try to use the ODBCConnection class. You can connect to other database. Andres Janno <[EMAIL PROTECTED]> wrote: Hello!Is it possible to get value to form field outside axapta database?For example completly different table from other mssql database?Regards,Andres Yahoo! Gr

[Axapta-Knowledge-Village] Display Method

2005-08-15 Thread drescher_r
Hi you guys! I'm quite new to Axapta and trying to get through some tasks, hope someone can help me... I created a report on InventTable which shows ItemId and ItemName from InventTable, Name from InventItemGroup and InventLocationId from InventTableModule. Since there are three recordsets fo

RE: [Axapta-Knowledge-Village] Why so slow???

2005-08-15 Thread Subrahmanyam, Mamidi
Hi Brandon, I am also running in the 3 tier. Basically you are reading the ascii file record fields to fetch the SalesId for that customer. Since you are using SalesTable , since SalesId is the unique index, you can include firstonly the statement to:    Select firstonly SalesTable  

RE: [Axapta-Knowledge-Village] Why so slow???

2005-08-15 Thread Brandon George
Ok,    Thanks for the reply... btw, this is running in a 3-tier environment - Client -> AOS -> Database. You said you could make use of the SalesIdx, what do you mean by that? How in code can you make use of the SalesIdx? Can you give me an example of explain?   To give you a better underst

RE: [Axapta-Knowledge-Village] Why so slow???

2005-08-15 Thread Subrahmanyam, Mamidi
or may be use firstonly. But I am not sure why this is executed slowly on your environment. will see if anyone has other thoughts like, run on clinet/server etc etc... "Subrahmanyam, Mamidi" <[EMAIL PROTECTED]> wrote: Hi Brandon,   I created a sales order with quatation and tried to confirm you

RE: [Axapta-Knowledge-Village] Why so slow???

2005-08-15 Thread Subrahmanyam, Mamidi
Hi Brandon,   I created a sales order with quatation and tried to confirm your code. Its confirming to salesorder and its pretty fast . However i am doing in a job.   But if I use SalesIdx on the select SalesTable statement, i could save 1/4 of the execution time ( just by using WinAPI:;GetTick

RE: [Axapta-Knowledge-Village] Why so slow???

2005-08-15 Thread Brandon George
Sure thing,       We are running Axapta 3.0 with SP3. Below is the code used to Confirm the Orders:   public boolean confirmSalesOrder(SalesId  _salesId){    SalesFormletter SalesFormletter;    SalesTable  SalesTable;    boolean b = false;    ;       try    {    SalesFor

RE: [Axapta-Knowledge-Village] Why so slow???

2005-08-15 Thread Subrahmanyam, Mamidi
Hi Brandon,   Can you please post your code here to see if I can run it in my development server?. We also do the similar kind of stuff using connectivitty studio. Anyway, Can you please share the code what exactly you are doing?. which version of axapta and which version of SP?.   Thanks, subbu

[Axapta-Knowledge-Village] Create Quarantine Order

2005-08-15 Thread jens
Hello there, Ax3.0 SP3 I need to create a quarantine order when receiving material from certain suppliers. I would like it to be quite similar to the "normal" Axapta approach when handling items to quarantine locations. Therefore, would you know where to "steal" this piece of code - or where to

RE: [Axapta-Knowledge-Village] Why so slow???

2005-08-15 Thread Brandon George
I am cursed or something? :-) Just joking everyone... but really - no response to this question? No one here has ever ran into Committing an Order through code and it being slow? Like Slower than when you do it through the Sales Form?   thanks, Brandon From: Axapta-Knowledge-Village@yahoo

Re: [Axapta-Knowledge-Village] reading table outside axapta database

2005-08-15 Thread Girish Bhatkal
Hi Andres, i think there was a few postings earlier too on this did you check the earlier postings on this group ? anyway one of the job is as below static void Update(Args _args) { // connection ODBCConnection oDBCConnection; gTest gTest; // new table in axapta

[Axapta-Knowledge-Village] Re occurring batch jobs

2005-08-15 Thread James Flavell
Hi can someone help intorduce me to making sure my reports or extraction scripts can run in batch mode. If say I have a sales report that the user can print anytime and they are prompted for a date range (or can enter via filter criteria) but I also want to use this report at the end of every mont

[Axapta-Knowledge-Village] BOM material

2005-08-15 Thread JasonDykeson
Dear All,   Can anyone provide me with documentation for Bill Of Materials? A link to a site or mail me documentation to [EMAIL PROTECTED]   Thnx   JasonD Sharing the knowledge on Axapta. SPONSORED LINKS