[Firebird-devel] Named parameters in client libraries

[Adriano d. S. F. <adr...@gm...>]

Hi Mark, Jiri, all!

How are client libraries (Jaybird, .NET Provider, Delphi ones)
describing its named parameters to their users?

I mean, given this SQL:

select *
  from rdb$database
  where :param = 1 or :param = '2'

We have here single name used in context with multiple types.

I suppose you transform this to:

select *
  from rdb$database
  where ? = 1 or ? = '2'

Which will map to two Firebird parameters with different types.

But for the user of the library, I suppose it's one parameter, correct?

And what type (and the deduction rules) this parameter will be described as?


Adriano