Re: Inserting Blobs

Chris Stratton wrote: > > I have never worked with BLObs before and cannot figure out how to > insert into the table.> > I have defined the blob field as text with the tablespace to hold it. > > When I try to run the SQL > > insert into comments (id,topicid,submit_date,comments) values > (1,2,'12/31/97','This is a test')> > Informix comes back and says I have not defined the data type. What does > this mean? I don't know which tool are you using, but in non-graphical interface you can load data in a blob field via the load command (in dbaccess). the powerful of this kind of field is using it in a windows environment, such as ms-access o ms-visualbasic, where you can bind it, using datacontrol, to an OLE control and store data automatically from within an OLE server like word or excel. r. -- Roberto Campo Siemens Nixdorf Informatica S.p.A. +39 6 66393.409 Fax: 692 campo@scn.de