Hi Martijn,

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?

regards,

roberto


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

>
> > The environment D7, Embedded Firebird 1.5.1, UIB dbExpress driver.
> >
> > I tried to use a TSQLQuery component (ParamCheck = False) to run the
> > following code:
> >
> > -----
> > 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
> > I have tried modify the VCL source in SqlExpr.pas source by commenting
> > a line of function FixParams as follows:
> >
> > //++++ SQL := stringReplace(SQL, Param, ' ? ', []);
> >
> > Yet, the '?' replacement persists. If I use the IBExpert program to
> > create or modify the stored procedure, the ':' named parameter was
> > never replaced by the '?'. I use the same fbClient.dll and dbexpress
> > driver, so the replacement must be done by the delphi VCL codes, How
> > can I stop the Replacement of named parameter by '?' ?
>
> Or by the driver.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &

MS SQL

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