Page 1 of 1

TIBCQuery BLOB Subtype detect

Posted: Fri 21 Feb 2014 10:00
by Macma
Hi,

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

Regards,
Macma

Re: TIBCQuery BLOB Subtype detect

Posted: Fri 07 Mar 2014 12:03
by 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.

Re: TIBCQuery BLOB Subtype detect

Posted: Fri 07 Mar 2014 12:20
by Macma
Thank You for respond.

Best Regards,
Macma

Re: TIBCQuery BLOB Subtype detect

Posted: Fri 07 Mar 2014 14:14
by Dimon
Feel free to contact us if you have any further questions.