Re: SQL insert/update text BLOB?

kistler@an.hp.com (Jim Kistler) offerred: +Okay, I can't find documentation on how to "insert" or "update" +a text BLOB with an SQL statement. That's because it cannot be done. Not with just plain old SQL. You can do it with esql/c. +Checking error message 617, I see that "BYTE and TEXT values must be +assigned as whole units to columns of the same type". + +What does "assigned as whole units" mean? That means you can select one blob column and assign it to another blob column. Getting blob data into the database in the first place is the tricky part. +I can enter the data with a form, so all is not lost, but shouldn't +I be able to do this with SQL? S "Should"? I think so. But right now, you can't. And it has been that way since blobs were first introduced in v4.0. ** Dave Kosenko davek@summitdata.com ** ** Director of Training Services (732) 469-4070 ** ** Summit Data Group (an Informix Authorized Education Center) ** ** Find my advise useful? Then take your Informix training at SDG ** ** see http://www.summitdata.com/training for details **