Re[2]: [Firebird-devel] Incorrect mapping of SQLDA parameters

[Nickolay S. <sk...@bs...>]

Hello, Jason !

Monday, November 25, 2002, 10:10:33 PM, you wrote:

> What I would really appreciate is at the same time if you made it so that
> input parameters could pass in a name and that this name would appear in the
> SQLVAR record when doing the prepare/describe. It would also be great if you
> could define a SQLType for a parameter in the statement and have this be
> taken into consideration rather than an exception raised.

> While you are in the parameters thing, just as well tidy up all the issues
> so that there is a simple check in code for all the new features that are
> needed.

> Reason I ask for the handling of names for input parameters is because then
> I wouldn't have to care much what order the input parameters are in. The
> server would tell me their names and they could be in any order it wanted.

Not in Firebird 1.5. No XSQLDA structure changes were planned in
Firebird 1.5 and it is already feature-closed as I understand.
You may add this as feature request for Firebird 2.0.
There is a planned change of XSQLDA structure in this version.

> Also, let me give you a beware, when you have a column of a query defined
> using an inline select that has an input parameter and then in the order by
> clause you refer to that column by number the input parameter of the inline
> select gets repeated automatically. Ideally it would be nice if you
> consolidated that to reuse instead of duplicating.

Already fixed for all cases (group by and order by by ordinal). Fix is
very general and applies to all DSQL constructs (it uses lexer order
instead of pass1 order to process parameters).

-- 
Best regards,
 Nickolay                            mailto:sk...@bs...