Subject Re: [IBO] [IB_SQL] How to use IB_SQL like SqlMonitor
Author Stefano Campri
----- Original Message -----
From: "Paul Vinkenoog" <paul@...>
Newsgroups: egroups.ibobjects
To: <>
Sent: Thursday, June 12, 2003 10:01 AM
Subject: Re: [IBO] [IB_SQL] How to use IB_SQL like SqlMonitor

> Hello Stefano,
> > Is it possible to use IB_SQL like SqlMonitor ??? How ?
> I don't think so.
> > i would like to see what's DML is executed when at run-time
> > the insert button of a TIB_UpdateBar is clickked
> Probably nothing; this just puts the dataset (in the app) in dssInsert
> state, it doesn't post anything. It might do a Prepare under some
> circumstances.

You are right : no DML is executed

Could you comment this ?
(extrated from :
Mix in a little conflict...

Free up some more invoice numbers by deleting some more headers.

Now, open another instance of the application by running the EXE from the
project folder.
Line up the two instances so that you can observe both the header and log
grids of both.

In one instance, start to enter a new header, but don't post it.

Do the same in the second instance but, this time, try to post it.
Observe that you get a Deadlock message.
This is not a problem - it shows that the lock applied in the Before Insert
trigger by the first instance is working.

how can a trigger be invoked if cliccking insert row on the TIB_UpdateBar
does not effect on the database ???

what's the solution to make the example working ???

Any help would be appreciate,
Stefano Campri