Re: [Firebird-net-provider] Changing .Net type based on a Domain type
On Thu, Sep 22, 2011 at 10:54 AM, Jiri Cincura wrote: > On Thu, Sep 22, 2011 at 2:45 PM, Sam Carleton > wrote: >> My current thought is there is some way to associate the >> isc_info_sql_type and isc_info_sql_sub_type with the domain type. So, >> along these lines, what is the relationship between a domain type and >> the isc_info_sql_type and isc_info_sql_sub_type? > > It's not related to domain itself, but the underlying type. Ok, so is the domain type only really useful during the design of the DB. I say that from the prospective of: It aids a DB Admin in designing the DB, but from the programming side of things it has no effect. Sam -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Changing .Net type based on a Domain type
On Thu, Sep 22, 2011 at 2:45 PM, Sam Carleton
wrote:
> My current thought is there is some way to associate the
> isc_info_sql_type and isc_info_sql_sub_type with the domain type. So,
> along these lines, what is the relationship between a domain type and
> the isc_info_sql_type and isc_info_sql_sub_type?
It's not related to domain itself, but the underlying type.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Changing .Net type based on a Domain type
The question is:
How can I hack the .Net provider such that I can change the .Net type
based on the domain type of the column?
My current thought is there is some way to associate the
isc_info_sql_type and isc_info_sql_sub_type with the domain type. So,
along these lines, what is the relationship between a domain type and
the isc_info_sql_type and isc_info_sql_sub_type?
Sam
On Thu, Sep 22, 2011 at 3:59 AM, Jiri Cincura wrote:
> On Wed, Sep 21, 2011 at 11:51 PM, Sam Carleton
> wrote:
>> Can someone shield some light on this?
>
> Maybe it's too early in the morning, but I don't know what the question is. :)
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
> --
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2dcopy1
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Changing .Net type based on a Domain type
On Wed, Sep 21, 2011 at 11:51 PM, Sam Carleton
wrote:
> Can someone shield some light on this?
Maybe it's too early in the morning, but I don't know what the question is. :)
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Changing .Net type based on a Domain type
I need to play some tricks, I am not at liberty to get into the details on why, so please do not ask. I have a situation where 3rd party code is using the results of the Firebird query. This is not the case, but it is similar: The 3rd party code demands that the type be an System.UInt16, if it is not that specific type, it blows up. So, the solution I have come up with is to add a new domain type UINT16 and it a base type that will hold the value. Then hack the Firebird .Net provider such that the DbField.GetDbDataType() detect that the value is this special domain type and return a new DbDataType. Folks, I know there might be some holes in this approach based on the info provided, but I simply am not providing all the facts because I am simply not at liberty to disclose them. I know, without any doubt that this approach will for the real situation, iff I can figure out the relationship between the isc_info_sql_type/isc_info_sql_sub_type and the domain type. When I look at the values, the isc_info_sql_sub_type is that of the base type of the domain, the isc_info_sql_type has a value of isc_info_sql_sub_type + 1. When I look in rdb$fields table, I don't find the numeric value of the isc_info_sql_type, nor do I find any relationship between the two. Can someone shield some light on this? Sam -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
