At 08:56 PM 01-08-01 +0800, you wrote:

>Hi Svein,
>
>How about stored procedure? Will it be possible?

You cannot pass metadata objects as parameters, either to DSQL or to stored procedures, i.e. you could not pass a column name to a SP as an input argument.

regards,
Helen

>Best wishes,
>jr
>
>----- Original Message -----
>From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
>To: <ib-support@yahoogroups.com>
>Sent: Wednesday, August 01, 2001 8:53 PM
>Subject: Re: [ib-support] Parameter in the Where clause
>
>
> > >select * from TABLE1 :WHEREPARAM
> >
> > I think you'll have to create your SQL dynamically at run time. Interbase
> > cannot prepare a statement like the one you describe.
> >
> > Set
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________