Subject | Does the SQLType property work? |
---|---|
Author | terriertech |
Post date | 2004-10-08T16:02:16Z |
Hi, I am trying to figure out the data type of a field, which should
really be a simple task, but I am running into problems.
First up, if I use the IsBlob property it returns false even though my
field *is* a blob.
Second, if I look at x->Fields->Columns[i]->IsNumeric, it does not
tell me whether the field is an integer or floating point value.
I searched through the previous messages and found that I can use the
SQLType property, but the values being put into this property seem out
of whack. For example, the mapping goes something like this:
Varchar = 449
Char = 453
Timestamp = 511
Integer = 497
Blob = 521
The values are consistent, they just don't match anything I am seeing
in rdb$types. Am I supposed to somehow process the SQLType property
to get the actual field type?
JR
really be a simple task, but I am running into problems.
First up, if I use the IsBlob property it returns false even though my
field *is* a blob.
Second, if I look at x->Fields->Columns[i]->IsNumeric, it does not
tell me whether the field is an integer or floating point value.
I searched through the previous messages and found that I can use the
SQLType property, but the values being put into this property seem out
of whack. For example, the mapping goes something like this:
Varchar = 449
Char = 453
Timestamp = 511
Integer = 497
Blob = 521
The values are consistent, they just don't match anything I am seeing
in rdb$types. Am I supposed to somehow process the SQLType property
to get the actual field type?
JR