Testing query used in procedure in ABL

You may use , ABL log ex : –clientlog ‘’c:\log.txt ‘’ –numlogfiles 5 –logthreshold 2000000 –logentrytypes DB.Connects :4

   Or when you compiling make xref file detecting index use or whole-index

Hi Adrien,

Can you please elaborate it where could I use ABL ex: statement?

Is it possible to test queries only for the certain part of application (like for some process only)?

Thanks,

Dinesh

Yes , for log , but you need opend edge 10. In open edge 11 more utilities is enbable.

  ->you may use LOG-MANAGER handle ans SESSION handle (for stacktrace)

You might want to check out http://cintegrity.com/content/Analysis-Existing-ABL-Code

Some other things that may be useful:

0) The 4GL profiler.

1) measuring times by inserting mtime() calls at appropriate points in the application

2) Tom Bascom's protop database activity monitoring program, available at http://www.greenfieldtech.com/articles/protop.shtml

Hi All,

Thank you all for your suggestion.

Is there is any tool or application which could suggest me about why don't to use such block of code or such query in my ABL code or any query?

Thanks in advance,

Dinesh

maybe Prolint can I have'nt used it for a while or XREF option on the COMPILE stmt...

Hi Rohit,

Can you please provide code or syntax about how to use xref?

Thanks,

Dinesh

In the 4GL Reference manual, the section about the COMPILE statement has a

subsection that explains the XREF option.

This program pulls xref's apart and provides all kinds of information on them in TT form:

http://communities.progress.com/pcom/docs/DOC-16588;jsessionid=F70F2BCB3C6A01D582556B5A09BA863C

Thanks Tim.