Re: [Axapta-Knowledge-Village] caching of tables in Axapta

[Harry \(Harshawardhan Deshpande]

hi James,

 

wanted to try this myself but looks like it will take me a week to get around this.

 

if it is urgent what you can do is take advantage of the fact that....

 

if a table as cachelookup property to 'entire table' then even if you enable sql trace, you cannot see any sql statement (in sql statement trace log) selecting records from the particular table.

 

what you could do is enable sql trace, change company, select records from this table just to be sure and check sql statement trace log. This will answer your question.

 

regards

 

harry

James Flavell <[EMAIL PROTECTED]> wrote:

Hi

Can anyone tell me the table protperty for 'CacheLookup' if set to EntireTable will this load all Axapta companies records or only the company I am in when I access that table?

 

Also if I set it up in user options the 'PreLoad' for a table deos it also load all Axapta companies or just the one I am in?

 

Thanks

James

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Sharing the knowledge on Axapta.

SPONSORED LINKS

Business finance course	Business to business finance	Small business finance
Business finance consultant	Business finance magazine	Business finance schools

---

YAHOO! GROUPS LINKS

•  Visit your group "Axapta-Knowledge-Village" on the web.
   
•  To unsubscribe from this group, send an email to:
   [EMAIL PROTECTED]
   
•  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---