It's hokey and minited, but you can create something like:



If (InputParameter='ThisField') then

Select ThisField from.

Else If (InputParameter='ThatField')

Select ThatField from.



Depending on the number of options and combinations, this can be a
reasonable approach. You also need to realize that the structure of the
result set is fixed, so the output parameters must cover all possible result
set structures.



Louis Kleiman

SSTMS, Inc.



-----Original Message-----
From: Richard Pendered [mailto:rpendered@...]
Sent: Friday, February 14, 2003 8:40 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Generate a SELECT statement with variables in a
procedure



Hi,
We even tried it in MS SQL, but it never seemed to work. Thankfully we we
only researching this (messing about).....
Rich P...

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: 14 February 2003 12:30
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Generate a SELECT statement with variables in
a procedure


Hi Xavier,

> Hello listers,
>
> I would like to know if it is possible to generate a SELECT query in a

According to the documentation: no.

According to your tries?: no.

In general: no.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."


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 the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]