RE: [Axapta-Knowledge-Village]

[Rocco Giumelli]

Hi Harry
 
yes I see,  The temp table will than be there so the 
List is free from the large Inventtable (Essentially lookup once than select 
from temp table)
 
I can create the Table with only the items that apply 
to one Employee's warehouse only (Blokes in Vans Each van is a Warehouse in 
our system), and then the lookup that up on a reduced table that i will 
than in turn use for the Inventid lookup, with itemid, description and Onhand 
Value. I Think I understand
 
 
 
Do you have an example of how we could do 
this
 
Thankyou harry
 
Rocco


From: Harry (Harshawardhan Deshpande 
[mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 April 2005 5:18 
AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
[Axapta-Knowledge-Village]

hi
 
time from brain storming.
 
How about create a tmpInventTable... Fill up this table when the form is 
loaded or first lookup is made ...use item id from this table for look 
up and then select the row from normal inventtable on the basis of item id from 
tmpInventTable
 
huh?
 
regards
 
harry
Rocco Giumelli <[EMAIL PROTECTED]> 
wrote:

  
  Hi Frank/Harry
   
  Yes, I have, it did help the speed a little.  I 
  guess I am Trying to say is that can a Lookup Method cache the details 
  (Itemtable) so it does not try to load the same lookup on every line of the 
  web form as they enter it.
   
  Rocco
   
   
   
   
   
   
   
   
  
  
  
  From: Frank Werner-Vohrer 
  [mailto:[EMAIL PROTECTED] Sent: Monday, 4 April 2005 1:47 
  PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: 
  Re: [Axapta-Knowledge-Village]
  
  Hi Rocco,
   
  have you looked whether it is a server based method or a client? A 
  serverbased should be quicker.
   
  FrankRocco Giumelli <[EMAIL PROTECTED]> 
  wrote:
  
    
    Hi 
    All
     
    I am in the 
    middle developing a Web portal PDA for our service personel on the road. 
    When I put in the Itemid on the Web Form, the default lookup for the item 
    table, is very slow on the PDA device, but on the internet browser (On the 
    PC) it seems much quicker. When I Remove the Itemid field from the web form 
    the PDA returns to an acceptable speed. 
     
    My guess is that 
    it is trying to load the whole item table on every line of the web form as 
    it refreshes or adds a new line
     
    Does anyone know 
    of a way so I can keep the lookup functionality, but maintain the speed on 
    the PDA Device
     
    Thanks in 
    Advance
     
    
    
      
      
         
        
          ____________________________________________Rocco Giumelli
          IT MANAGER       
          
          Metric Australia Pty 
          Ltd
          Assistance is only the Beginning 
          
          893745331
     Sharing the knowledge on Axapta. 
  
  
  
  Gesendet von Yahoo! Mail - 
  Jetzt mit 250MB kostenlosem Speicher 
  
  
  Gesendet von Yahoo! Mail - 
  Jetzt mit 250MB kostenlosem Speicher Sharing the knowledge on 
  Axapta. Sharing the knowledge on Axapta. 

__________________________________________________Do You Yahoo!?Tired 
of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com Sharing the knowledge on Axapta. 



Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.