Page 1 of 1
DescribeParams = true raises Data type not supported error
Posted: Wed 07 Oct 2015 12:42
by upscene
Hi,
I have Options.DescribeParams set to True on a TIBCQuery. When I prepare a query like this:
Code: Select all
select *
from rdb$database
where :p is null
I get "Data type is not supported". I fully understand that this works fine if I set DescribeParams to False, but in my application, I try to display the data type for parameters before users enter values.
Now, wouldn't it be better if the data type for this parameter simply stayed "ftUnknown" instead of raising the error? The user then could select a data type or keep the item Null.
With regards,
Martijn Tonies
Upscene Productions
Re: DescribeParams = true raises Data type not supported error
Posted: Thu 08 Oct 2015 10:45
by ViktorV
If you want IBDAC not to generate the "Data type is not supported" error when DescribeParams is enabled, please post this suggestion at our user voice forum:
https://devart.uservoice.com/forums/104 ... e-firebird If the suggestion gets a lot of votes, we will consider the possibility to implement it.
Re: DescribeParams = true raises Data type not supported error
Posted: Thu 08 Oct 2015 12:37
by upscene
Would it be hard to implement?
Re: DescribeParams = true raises Data type not supported error
Posted: Fri 09 Oct 2015 14:32
by ViktorV
The "Data type is not supported" error generated when DescribeParams is enabled - is the standard behavior of our components, which is used by many our users. If your suggestion at
https://devart.uservoice.com gets enough votes, we will consider the possibility to implement it.
Re: DescribeParams = true raises Data type not supported error
Posted: Fri 09 Oct 2015 15:17
by upscene
I doubt it would be very high on the list.
This could be made backwards compatible easily with either an additional option or .Prepare parameter.
Currently, the exception message ignores the ability for users/developers to fetch parameter types where possible and set those themselves when needed.
Is the exception raised when the DBMS returns "unknown"?
Re: DescribeParams = true raises Data type not supported error
Posted: Mon 12 Oct 2015 10:54
by ViktorV
Please clarify, what do you mean by "the DBMS returns "unknown"?
Re: DescribeParams = true raises Data type not supported error
Posted: Thu 22 Oct 2015 17:56
by upscene
"unknown" for the parameter data type when trying to figure it out?
Re: DescribeParams = true raises Data type not supported error
Posted: Tue 27 Oct 2015 12:55
by ViktorV
We will investigate the possibility to implement this functionality in one of the next versions of IBDAC.
Re: DescribeParams = true raises Data type not supported error
Posted: Wed 28 Oct 2015 08:06
by upscene
Thank you, for interactive applications, detecting parameter data types where possible and let the user decide what data type the "unknown"s are, is very helpful.
Re: DescribeParams = true raises Data type not supported error
Posted: Fri 06 Nov 2015 14:20
by ViktorV
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.