TIBCQuery BLOB Subtype detect

[Macma]

Hi,

Is it possible to detect if BLOB filed generated by TIBCQuery results, are SubType 1 (text blob)?

Regards,
Macma

[Dimon]

You can detect SubType of a field in the following way:

Code: Select all

  SubType := TIBCFieldDesc(IBCQuery1.GetFieldDesc(FieldNo)).SQLSubType;

Also, you can set the TIBCConnection.Options.EnableMemos property to True, and then BLOB fields with subtype 1 will be mapped to TMemoField and TWideMemoField, and BLOB fields with subtype 0 - to TBlobField.

[Macma]

Thank You for respond.

Best Regards,
Macma

[Dimon]

Feel free to contact us if you have any further questions.