Hi Martijn,

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?


regards,

roberto


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

> 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