Hello Roberto,

> It is a create stored procedure statement not a select statement. The
> code is as follows:

This:

> -----
> CREATE PROCEDURE TEST (
> FIELD1 INTEGER)
> RETURNS (
> FIELD2 INTEGER)
> AS
> Begin
> FOR SELECT FIELD2 FROM TABLE1
> WHERE FIELD1 = :FIELD1
> INTO "FIELD2"
> DO
> BEGIN
> SUSPEND;
> END
> End
> ------

Has nothing to do with:

> > > I tried using upscene latest dbexpress trial driver, I got the
> > > following changes:
> > >
> > > ------
> > >
> > > WHERE SERIES_NO = ? /* PRM_0 */ AND PARTY_NO_START = ? /* PRM_1 */
> > >
> > > ------
> > > Any clue to remove the '?' replacement?

Does it?

That's why I asked where you actually get the sample above.

Please, in your first post, you said that you had "ParamCheck" to "False"
of your TSQLQuery component.

I asked you to do the same with our driver. Next, you come up with some
parameter thing in "series_no" - which is no-where to be found in either
your first question, or your example you gave with this post.

So, WHAT are you trying to do? And HOW are you currently trying
to do it? And with what driver, of course.

With regards,

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