Hi Martijn,

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

-----
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
------

regards,
roberto




--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hello Robert,
>
> > 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?
>
> Is this in a CREATE PROCEDURE statement, or a normal SELECT
> with parameters?
>
> In a normal select, you can't get rid of those replacements -> Firebird
> doesn't support named parameters.
>
> However, when executing DDL, it should simply pass the command to
> Firebird.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &

MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com