RE: [Axapta-Knowledge-Village] SQL Trace - II

Sat, 27 Aug 2005 01:41:32 -0700

hi Subbu
 
No you will not get a warning for ledger settlements since warnings in sql trace are solely for failed sql statements and instances where axapta could not find an appropriate index.
 
however, it may be worthwhile checking it out, overriding post load method is going to delay the execution time of a query, may be sql trace will throw some warning,
 
regards
 
harry

"Subrahmanyam, Mamidi" <[EMAIL PROTECTED]> wrote:
Hi Harry,
 
Thank You for the suggestion. None of us here ( some people more than 6 years of DEV exp ) are using SQL trace tool.
 
So underwarning column, If I give the info log path, and do ledgersettlement with my yestersdays  postLoad code ( I am getting worried ), will I get all the SQL warning ect ect if any?.
 
I am trying it now.
 
Thank you for the tip.
Regards,
subbu
 
 


"Harry (Harshawardhan Deshpande" <[EMAIL PROTECTED]> wrote:
hi James
 
hi SQL tool is very important. After a modification is complete, a programmer/tester should enable this tool and run through the modification to see if any warning messages are displyed like missing indexes etc. I would say most of the time, it will catch problems.
 
regards
 
harry

James Flavell <[EMAIL PROTECTED]> wrote:
thansk harry
 
its not so urgent, more a nice to know.
 
never used the sql trace tool yet and my customer going live 1st SEpt so I think it will be awhile before I attempt anything on this also
Thanks
James
 
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande
Sent: 26 August 2005 15:34
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] caching of tables in Axapta

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

Start your day with Yahoo! - make it your home page

Start your day with Yahoo! - make it your home page

Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.

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



Reply via email to