Re: ResultField.Type=-2

[BB <adamnt42@xxxxxxxxx>]

I'm sorry, I guess that I'm not making myself clear.

I am getting -2 returned from ResultField.Type for a particular 
*postgresql* database that I am denied DML access to.

I'm guessing that for one occurrence that its a ByteA (picture) column 
but that is not apparent in other cases (maybe they are ByteA but I cant 
tell).

My question is not about database types, its about Gambas or more 
specifically the DB or DB2 components.

What does Gambas mean when it returns a field type that is not one of 
the "standard types"? Does it mean "I don't know what this field data 
type is." or "This field looks like some sort of array of bytes possibly 
but not certainly" or "this field contains fish on bicycles" or ...?

Why is it returning a negative number? Is the positive part of the 
number meaningful in any way i.e. it looks like your examples of other 
databases that it means something other than ByteA, but is that 
determinate? (From your replies it looks not! Could other column types 
also return a -2 field type?)

For that matter, as far as I can see ResultField.Type is the Gambas type 
i.e. what type Gambas converts the database value into, not the real 
database type. Which is only worse.

rgrds

b