Hello:
Is there a way that I can get the query parameter types with the firebird
> .net provider?
> eg: If I've got a query:
> SELECT * FROM CUSTOMER
> WHERE
> CUSTOMER.CUSTOMERCLASSID = @CUSTOMERCLASSID
> AND CUSTOMER.CUSTOMERCREATIONDATE > CAST(@CREATIONDATE AS DATE)
>
> I would like to know what the types (INT, and DATE in this case) of the
> parameters in the query is (on prepare maybe?) so that I can create the
> controls dynamically to capture the input params from the user.
I think that the only way you have to do this is using stored procedures and
discovering the parameters at runtime ( using FbCommandBuilder.
DeriveParameters )
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
