At 08:34 AM 4/06/2009, Alan McDonald wrote:

>Helen's claim was that the statements are not executed at the server.

No such "claim". I said the *procedure* was not executed at the server -- which it is not.

>They are indeed. The engine to which you refer, breaks open the SP block and
>fires them at the server one by one. The engine maintains the input
>variables and return variables of each statement.

Executing individual statements in DSQL is not equivalent to executing a compiled PSQL module.

>It's as good as it gets with no debugging API.

Nevertheless, it serves to test program *logic* statement by statement. It does not (because it cannot) execute compiled code.

That's not to say it's not a handy tool; but if you care to refer to the OP, his problem was to understand why the server continued to execute the "old" version of his procedure, when IBExpert was appearing to execute the "new" version.

./heLen