Select from BLOB field

Question

Select from BLOB field

crystalempress (Programmer)

(OP)

22 Feb 05 10:46

I have a Blob field that I need to get the information out of. The front end is a freeform text area for agents to type in remarks. I need those remarks, How do I extract them from this blob field?

donvittorio (Programmer) · Answer 1 · 2005-02-22 11:56:33

Could you be more specific about what you are trying to do?
BLOB fields can be selected in just the same way as any other, but problems often arise when trying to display them.
Delphi provides several ways for dealing with BLOB fields, you can use a TDBMemo to display them on screen, or you can use a TBlobField to save them to/load them from a file etc.

Steve

crystalempress (Programmer) · Answer 2 · 2005-02-22 12:21:14

I am using Interbase Client (SQL) to access my data. The data is Entered in a Client base front end as a free form text. This information is then stored as a Blob on the TRAMS.GDB on the backend. I need to get these comments out of the Blob field and send the information along with other related info on a specific transaction to a third party that need the information for demographic of their customers. I do not use Delphi. Currently I am using SQL Server to DTS this information out and this is where I get stuck with the Blob Field called Remarks?

Does this help?

Come Join Us!

Posting Guidelines

Jobs

Select from BLOB field