Foxhound is the better* Database Monitor for SQL Anywhere. *better: More thorough, more relevant, more effective. ...more Alerts, more All Clears, more details, more control in your hands.

PBDebug and DebugOutFile

How can I get a trace of program execution when I run my application in the development environment?

You don't have to create an EXE to turn on the "PBDebug" trace with PowerBuilder 5. Just add these two lines to the [PB] section of the \pwrs\pb5\pb.ini file:

   [PB]
   DebugOutFile=c:\temp\pbdebug.dbg
   PBDebug=on

The DebugOutFile parameter specifies where to put the output. Here's what that text file looks like after you run your program:

Executing event +CLICKED for class CB_RETRIEVE, lib entry W_AUTO
  Executing instruction at line 1
  Executing object function SETTRANSOBJECT for class DATAWINDOW, lib entry _TYPEDEF
  End object function SETTRANSOBJECT for class DATAWINDOW, lib entry _TYPEDEF
  Executing instruction at line 2
  Executing object function RETRIEVE for class DATAWINDOW, lib entry _TYPEDEF
  End object function RETRIEVE for class DATAWINDOW, lib entry _TYPEDEF
  Executing instruction at line 3
End event +CLICKED for class CB_RETRIEVE, lib entry W_AUTO
Executing event +CLICKED for class CB_INSERT, lib entry W_AUTO

For information about other kinds of debugging output, have a look at QuickTips.