Debug different thread

[Ming He]

Hi, I have a problem with debugging powerbuilder code. The code will pop up
a window and display the progress messages that come from another thread
that is running some embeded sql.

I just can't trace into where the embedded sql is run. I set a stop there in
the embeded code. However, the debugger won't stop there.

Another question that is related to the above is that under SQL server, the
message is showing all right in the window. However, under Oracle, even the
very first message from the embeded code that is run by another thread can't
be shown. Is there any thing that needs special attention when the database
is Oracle?

I appreciate your time very much.

Jack

[Maciej Sawicki]

The only way to debug PB threads is to use messageboxes. Debugger does
not work :-(

Maciek.

[Roy Kiesler [TeamSybase]]

You need to design the NVOs you're using in your threads very carefull --
not every NVO can automatically execute in a multithreaded environment. To
debug business logic, use CREATE instead of SharedObjectRegister/Get and
debug the NVO in the main thread. If you are trying to isolate threading
issues, like deadlocks, I suggest you do _not_ use MessageBoxes, as multiple
message boxes from multiple threads can make things even worse.

Rather, log to a file (each thread to a separate file!) with a timestamp for
each log entry.

--
<hopethishelps />
Roy Kiesler [TeamSybase]
mySybase -- http://my.sybase.com
http://www.exp.com/app/expertProfile?expertID=512231

"Maciej Sawicki" <Maciej....@mobileis.com.pl> wrote in message
news:3BD3F086...@mobileis.com.pl...