Hello Roberto,

> I'm sorry, I was trying out a few procedures and I paste the wrong
> extract of a different procedure which is not related to the earlier post.
>
> So the correct modified part of the stored procedure related to the
> earlier post is as follows:
>
> -----
> CREATE PROCEDURE TEST (
> FIELD1 INTEGER)
> RETURNS (
> FIELD2 INTEGER)
> AS
> Begin
> FOR SELECT FIELD2 FROM TABLE1
> WHERE FIELD1 = ? /* PRM_0 */
> INTO "FIELD2"
> DO
> BEGIN
> SUSPEND;
> END
> End
> ------
>
> I tried using upscene latest dbexpress trial driver, I notise '? /*
> PRM_0 */' was inserted into the procedure. Any clue?

And this happens with "ParamCheck" = "False"?

Do you try "Execute" or any "ExecuteImmediate"? The components
(and/or driver) should not prepare the statement -> only execute
it.

You can send me a test-case if you like, I'll take a look at it.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com