Re: SQL insert/update text BLOB?
Jim,
No. Informix SQL cannot insert or manipulate BLOBs.
Regards
David Ashby
______________________________ Reply Separator _________________________________
Subject: SQL insert/update text BLOB?
Author: <kistler@an.hp.com (Jim Kistler)> at WCA-INET
Date: 11/6/98 4:23 PM
Okay, I can't find documentation on how to "insert" or "update"
a text BLOB with an SQL statement.
The error message says:
617: A blob data type must be supplied within this context.
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?
I find no helpful information in any documentation that I have.
I can enter the data with a form, so all is not lost, but shouldn't
I be able to do this with SQL?
Thanks,
Jim
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Jim Kistler - kistler@an.hp.com # Some see issues and ask, "Why?
Hewlett-Packard Co. Imaging Systems # Others see opportunities and
3000 Minuteman Road, Andover, MA 01810 # ask, "Why not?"
TEL: 978-659-2251 - FAX: 978-687-7265 #
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-