Hi,

I inherited a database where they created a blob field as type 2. I
have to live with it for the moment. I need to store an XML schema in
the field. I am also doing this all in code, so do let me know if I
need to type cast the the blob field

I am using a TIB_Query. Here is the stub of the code.

FIB_Insert.SQL.Clear;

FIB_Insert.SQL.Add('INSERT INTO VAC_EXTERNAL_JOB_BOARD ( REF_ID,
JNUM, UNMAPPED_DATA, POSTED ) VALUES ( ');
FIB_Insert.SQL.Add('1, :pJNUM, :pUNMAPPED_DATA, 0 ) ');

FIB_Insert.Prepare;
FIB_Insert.ParamByName('pJNUM').AsInteger := FVacTrackInfoRcrd.JNUM;
FIB_Insert.ParamByName('pUNMAPPED_DATA').Assign(tmpStrList.Text);

FIB_Insert.Execute;


I guess what I would like to do is Create a TStringList object, layout
the XML text, and use the assign method to save the text into the binary
blob. Will that work? Other suggestions. Thanks.

--
Thomas Miller
Chrome Portal Project Manager
CPCUG Programmers SIG Chairperson (formally Delphi)
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://programmers.cpcug.org/
http://sourceforge.net/projects/chromeportal/
http://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus