Field Type with TOracleQuery

[LyleMartin]

Hello,

I am trying to do something like the following.

if Query.Field('field_name').FieldType=otClob

I have also tried
Query.Field('field_name').FieldDBType=otClob

Of course it is more complicated than that.. it really looks like:
Query.Field.(otherQuery.field('something')).FieldType (or FieldDBType)

I have tried the 4 versions above (using the simple field names and then more complex with FieldType and FieldDBType) and each time I get the error:
invalid variant operation

What am I doing wrong? This should be pretty simple. I've done this kind of thing with regular queries before and I am using the TOracleQuery methods.

Your help is greatly appreciated -- in advance!

Best,
-Lyle

Ms. J. Lyle Martin
Sr. Web Developer
Integic Corp.

 

[LyleMartin]

OK I figured it out. Don't know why it even compiled the other way. But this is more what the method call should look like.

Query.FieldDBType(QueryStyles.FieldAsString('disp_field_i'))=otClob

For size it shoudl be

Query.FieldSize('field_name')

Thanks anyway. I knew if I posted a message -- I would figure it out.

Hope this helps someone else.

Best,
-Lyle